pgBadger 2.3 released
Version 2.3 of pgBadger, a PostgreSQL log analyzer build for speed with
fully detailed reports from your PostgreSQL log file, has been
officially released and is publicly available for download.
This release fixes several major issues especially with csvlog and a
memory leak with log parsing using a start date. There's also several
improvement like new reports of number of queries by database and
application. Mouse over reported queries will show the database, user,
remote client and application name where they are executed.
A new binary input/output format have been introduced to allow saving or
reading precomputed statistics. This will allow incremental reports
based on periodical runs of pgbadger. This is a work in progress fully
available with next coming major release.
Several SQL code beautifier improvement from pgFormatter have also been
merged.
Useful Links:
Website: http://dalibo.github.com/pgbadger/
Download: http://sourceforge.net/projects/pgbadger/
Development: https://github.com/dalibo/pgbadger
Changelog: https://github.com/dalibo/pgbadger/blob/master/ChangeLog
About pgBadger :
pgBadger is a PostgreSQL log analyzer build for speed with fully
detailed reports from your PostgreSQL log file. It is written in pure
Perl language and uses a javascript library to draw graphs so that you
don't need additional Perl modules or any other package to install.
pgBadger is able to auto detect your log file format (syslog, stderr or
csvlog). It is designed to parse huge log files as well as gzip/bzip2
compressed file.
pgBdger reports everything about your SQL queries:
Overall statistics.
The slowest queries.
Queries that took up the most time.
The most frequent queries.
The most frequent errors.
The following reports are also available with hourly charts:
Hourly queries statistics.
Hourly temporary file statistics.
Hourly checkpoints statistics.
Locks statistics.
Queries by type (select/insert/update/delete).
Sessions per database/user/client.
Connections per database/user/client.
All charts are zoomable and can be saved as PNG images.
pgBadger supports any custom format set into log_line_prefix of your
postgresql.conf file provide that you use the %t, %p and %l patterns.
pgBadger works on any platform and is available under the PostgreSQL
licence.
--
Gilles Darold
http://dalibo.com - http://dalibo.org
