pgbadger

Log analyzer for PostgreSQL

https://pgbadger.darold.net/

/api/formula-linux/pgbadger.json (JSON API)

Linux formula code on GitHub

Current versions:

stable 11.1
head ⚡️ HEAD
bottle 🍾 catalina, mojave, high_sierra, x86_64_linux
You must configure your PostgreSQL server before using pgBadger.
Edit postgresql.conf (in $(brew --prefix)/var/postgres if you use Homebrew's
PostgreSQL), set the following parameters, and restart PostgreSQL:

    log_destination = 'stderr'
    log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d '
    log_statement = 'none'
    log_duration = off
    log_min_duration_statement = 0
    log_checkpoints = on
    log_connections = on
    log_disconnections = on
    log_lock_waits = on
    log_temp_files = 0
    lc_messages = 'C'
Fork me on GitHub