Vientiane, Laos - December 8th, 2024

pgBadger

pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your PostgreSQL log files.

pgBadger 13.0 was released today, this release of pgBadger fixes some reported by users since last release and adds some new features:

• Add two new option to be able to redefined inbound of query and session histogram.
• --histogram-query VAL: use custom inbound for query times histogram. Default inbound in milliseconds: 0,1,5,10,25,50,100,500,1000,10000
• --histogram-session VAL: use custom inbound for session times histogram. Default inbound in milliseconds: 0,500,1000,30000,60000,600000,1800000,3600000,28800000
• Add support of auto_explain plan for csv and json log formats.
• Add three LOG messages that was not reported as events: unexpected EOF, incomplete startup packet and detected deadlock while waiting for.

Backward compatibility issues:

• Change the way LOG level events reported in the Events reports are stored. Some of them was still reported and counted as errors instead as LOG level entries. The fix stores and reports them as EVENTLOG to differentiate them from queries. This change introduce a backward compatibility break when pgbadger is used in incremental mode. You will have the double behavior during the week of the upgrade.

For the complete list of changes, please checkout the release note on https://github.com/darold/pgbadger/releases

Links & Credits

I would like to thank all users who submitted patches and users who reported bugs and feature requests, they are all cited the ChangeLog file.

pgBadger is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly to pgbadger@darold.net.

Links :

• Download: http://pgbadger.darold.net/
• Support: use GitHub report tool at https://github.com/darold/pgbadger/issues or contact pgbadger@darold.net.

For a complete list of commercial support near of your place take a look at the PostgreSQL Professional Services page, they all do great job and most of them can help you.

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold (also author of ora2pg, the powerful migration tool). pgBadger is a fast and easy tool to analyze your SQL traffic and create HTML5 reports with dynamics graphs. pgBadger is the perfect tool to understand the behavior of your PostgreSQL servers and identify which SQL queries need to be optimized.

Docs, Download & Demo at http://pgbadger.darold.net/