Postgresql log viewer

• parses and shows postgresql logs (fed from standard input)
• if the log contains query, it fills query params so that query can be copied and executed
• formats queries when user navigates into :log/message in ui

Usage

First download jar in releases then follow instructions for specific ui below.

UI

Portal

tail -f /var/lib/pgsql/data/log/postgresql-$(date +%a).json | java -jar ./plv-portal.jar

Command window: Ctrl+Shift+P or Meta+Shift+P

See this video on how it can be used.

Reveal

tail -f /var/lib/pgsql/data/log/postgresql-$(date +%a).json | java -jar ./plv-reveal.jar

Requirements

Postgresl settings

# this tool parses json log only
log_destination = 'jsonlog'

# in order to see statements in log, this has to be enabled
log_statement = 'all'

Installed software

• Google Chrome or Chromium
• Clojure cli tools