pgbadger

PostgreSQL log analyzer that generates detailed reports and statistics

brewmacoslinux
Try with needOr install directly
Source

About

Log analyzer for PostgreSQL

Commands

pgbadger

Examples

Analyze a PostgreSQL log file and generate an HTML report$ pgbadger /var/log/postgresql/postgresql.log -o report.html
Analyze logs with custom prefix and generate JSON output$ pgbadger -p '%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h ' logfile.log -j
Analyze multiple log files and generate a combined report$ pgbadger /var/log/postgresql/*.log -o combined_report.html