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 -- Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-announce