postgres pgBadger - ghdrako/doc_snipets GitHub Wiki

• https://github.com/darold/pgbadger

pgBadger is a powerful and user-friendly performance analysis tool that parses PostgreSQL log files to generate insightful reports on database activity. It provides detailed HTML reports, offering statistics on queries, connections, lock events, and other key performance metrics. These reports are invaluable for diagnosing slow queries, identifying bottlenecks, and gaining a holistic view of database performance.

Before using pgBadger, you need to ensure that PostgreSQL is properly configured to log the necessary information. In particular, settings like log_statement, log_duration, and log_min_duration_statement should be enabled to capture query execution times and other relevant details.

Once your logs are configured, running pgBadger is simple. Use the following command to analyze your log file and generate a detailed HTML report:

pgbadger /path/to/postgresql.log

This will produce an HTML report that you can open in any web browser. The report breaks down important performance metrics, including slowest queries, query durations, connection peaks, and overall database load. You can drill down into specific queries, analyze time trends, or visualize database activity with interactive graphs and charts.

For large-scale deployments or continuous monitoring, pgBadger can process multiple log files, handle compressed logs, and run incremental analysis. This makes it an indispensable tool for performance tuning, identifying long-running queries, and ensuring optimal database health over time.

pgBadger organizes lock-related query information from your postgresql.log.The lock information is put into categories like “Most frequent waiting queries”and “Queries that waited the most,” which can help your investigations.