pgFouine is a PostgreSQL log analyzer. It allows you to have a clear overview of your database activity, and can generate reports with slowest queries, most frequent queries, errors, graphs, and so on.
pgFouine is written in PHP and is designed to parse huge log files with a low memory footprint.
pgfouine.php -file path/to/your/log/file.log > report.html
For comprehensive usage information, just run:
What's New in This Release: [ read full changelog ]
· support for rsyslog date format contributed by Peter Eisentraut
· a new option to shorten the query text if needed (-maxquerylength)
· a csv-query report
· several important fixes for a couple of corner cases which led to wrong statistics
· a -quiet option