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.

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.

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

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

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