30th September 2021: PostgreSQL 14 Released!

pgBadger v11.5 has been released

Posted on 2021-02-19 by Gilles Darold
Related Open Source

Grenoble, France - February 18th, 2021

pgbadger v11.5

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

pgBadger 11.5 was released today, this is a maintenance release that fixes issues reported by users during last three months with some improvement:

  • Add report about sessions idle time, computed using: "total sessions time - total queries time / number of sessions This require that log_connection and log disconnection have been enabled and that log_min_duration_statement = 0 (all queries logged) to have a reliable value. This can help to know how much idle time is lost, and if a pooler transaction mode would be useful. This report is available in the "Sessions" tab of "Global Stats" and in the "Sessions" tab of "General Activity" reports (per hour).
  • Add anonymization of numeric values, replaced by 4 random digits.
  • Update SQL beautifier based on pgFormatter 5.0.
  • Fix parsing of Google CloudSQL log file multi-line statement.
  • Add support to microseconds in Heroku logplex log line prefix.
  • Add support to multi-line statement in jsonlog format.

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

Links & Credits

Thank to the developers who submitted patches and users who reported bugs and feature requests, they are all cited in 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 :

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. http://www.postgresql.org/support/professional_support

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/