pgFouine - a PostgreSQL log analyzer

« Qu'est-ce tu fouines ? » « Je fouine pas ! »

About pgFouine

pgFouine is a PostgreSQL log analyzer used to generate detailed reports from a PostgreSQL log file. pgFouine can help you to determine which queries you should optimize to speed up your PostgreSQL based application.

pgFouine is written in PHP, is object oriented and easily extensible if you need specific reports.
pgFouine is free software and is distributed under the GNU General Public License.
pgFouine is designed to parse huge log files with a low memory footprint.
You can visit the pgFouine project site hosted by pgFoundry.

Download pgFouine 1.2

Additional packages

Note that pgFouine is available in most Linux distributions and *BSD flavors.

What's new?

2010-02-24 - pgFouine 1.2 "Jardin d'Eden" released - This version is mostly a bugfix release and introduces the following changes:
- 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
2009-04-26 - pgFouine 1.1 "Release early, release often" released
2007-03-30 - pgFouine 1.0 released
2007-03-28 - Thanks to Devrim Gunduz, pgFouine is now available in EPEL (RHEL extras).
2006-12-11 - pgFouine 0.7.2 released
2006-12-02 - Thanks to Devrim Gunduz, pgFouine is now available in Fedora Extras (FC5, FC6).
2006-10-28 - pgFouine 0.7.1 released
2006-08-24 - Thanks to Clément Stenac, pgFouine is now available in Debian.
2006-08-17 - pgFouine 0.7 released
2006-05-21 - pgFouine 0.6 released
2006-03-26 - pgFouine 0.5 released
2006-02-11 - pgFouine 0.4.99 released
2006-01-10 - pgFouine 0.2.1 released
2005-12-16 - pgFouine 0.2 released
2005-11-19 - pgFouine 0.1 released

About the author

pgFouine is written by Guillaume Smet.
Guillaume is 29 years old. He lives in Lyon (France) and works for Open Wide, a french company dedicated to Open Source software development, integration, hosting and support.

Thanks

pgFouine 0.1 parser was heavily based on PQA parser written by Tom Copeland and Thomas Favier.
pgFouine uses:
- GeSHi to colorize SQL queries,
- Artichow to draw graphs,
- SimpleTest for unit testing,
- sorttable to make a few tables dynamically sortable.