pgBadger is a PostgreSQL log analyzer built for speed with fully detailed reports from your PostgreSQL log file. It’s a single and small Perl script that outperform any other PostgreSQL log analyzer.

It is written in pure Perl language and uses a javascript library (flotr2) to draw graphs so that you don’t need to install any additional Perl modules or other packages. Furthermore, this library gives us more features such as zooming. pgBadger also uses the Bootstrap javascript library and the FontAwesome webfont for better design. Everything is embedded.

pgBadger is able to autodetect your log file format (syslog, stderr or csvlog). It is designed to parse huge log files as well as gzip compressed file. See a complete list of features below.

All charts are zoomable and can be saved as PNG images.


pgBadger is free software distributed under the PostgreSQL Licence.