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.1

Additional packages

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

What's new?

  • 2009-04-26 - pgFouine 1.1 "Release early, release often" finally released - This version introduces the following changes:
    • support for CSV logging (using -logtype csv)
    • support for lists and regexps in -user and -database filter options
    • normalization of IN() clauses
    • a simple garbage collector mechanism which should reduce dramatically the memory usage when a connection pooler is not used
    • fixes to a couple of regexps and bugs here and there (especially the sderr log analysis was partially broken in 1.0)
    • update of GeSHi to the latest stable version
    Special thanks to Russell Smith, Russell Garrett, Oleg Serov, Steve Woodcock, Max Valjanski, Cédric Villemain and Koen Martens for their patches and/or ideas. And thanks to all for your patience.
  • 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 28 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: