November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!

pgBadger 2.1 released

Posted on 2012-10-17 by Dalibo

Paris, France - October 17th, 2012

DALIBO is proud to announce the release of version 2.1 of pgBadger, the new PostgreSQL log analyzer. pgBadger is built for speed with fully detailed reports from your PostgreSQL log file. It's a single and small Perl script that aims to replace and to outperform the old PHP script pgFouine.

pgBadger 2.1 allows more flexibility

pgBadger is back with a new release and some long-awaited features:

  • you can now use a custom log_line_prefix (see below)
  • you can provide log files compressed with gzip, bzip2 or zip tools
  • you can use log_duration instead of log_min_duration_statement

 

This new release comes with some bugfixes and many improvements such as :

  • Huge overhaul of the cvslog format parsing for better performance
  • New syslog-ng parser
  • Better handling of empty graphs and tables
  • Handling of autovacuum launcher messages
  • Report of configuration changes

 

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

All pgBadger users should upgrade as soon as possible.

How to use the new --prefix parameter ?

With pgBadger 2.1, you don't need to modify the log__line_prefix parameter in the postgresql.conf file. Instead you can use the --prefix option to describe your log_line_prefix to pgBadger.

For instance, you can run the following command line:

perl pgbadger --prefix '%m %u@%d %p %r %a : ' postgresql.log

However, if you are using the stderr output, you will need to log at least the timestamp (%t), the PID (%p) and the session/line number (%l).

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Philip Freeman, Casey Allen Shobe and Vincent Laborie. 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 on our mailing list.

Links :

 

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold, also author of ora2pg 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 server and identify which SQL queries need to be optimized.

Docs, Download & Demo at http://dalibo.github.com/pgbadger/

 

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.com