pgBadger is an open source software designed to analyze PostgreSQL database logs faster than any other existing tool.
pgBadger features detailed reports about SQL queries, including overall statistics, the slowest queries, queries that took up the most time, the most frequent queries, the most frequent errors.
pgBadger also provides hourly queries statistics, hourly temporary file statistics., hourly checkpoints statistics, locks statistics, and much more.
What's New in This Release: [ read full changelog ]
· This version added many graphical improvements and improved rendering of logs over a few hours.
· Bugs were fixed, especially in reports of queries that generate the most temporary files.