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](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 pgbad...@darold.net.
Links :
* Download: [http://pgbadger.darold.net/](http://pgbadger.darold.net/)
* Support: use GitHub report tool at
[https://github.com/darold/pgbadger/issues](https://github.com/darold/pgbadger/issues)
or contact pgbad...@darold.net.
For a complete list of commercial support near of your place take a look
at the [PostgreSQL Professional
Services](http://www.postgresql.org/support/professional_support) 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/](http://pgbadger.darold.net/)
