pglog-analyze / script for slow queries analysis

Hello everybody,

   we are a small company doing web-development - mostly over PosgreSQL,
   and as we are wery happy with it we have decided to publish some of
   the tools we have written and that proved to be useful (under GPL).

   The first tool is a PHP script we use to analyze postgres.log, namely
   the slow queries logged there. We've seen PQA and several other
   tools, but none of them had the features we demanded, so we wrote
   it ourselves. It builds a HTML report with charts by various criteria
   (average, median, worst case, ...), details of individual queries,
   various kinds of graphs (by hour, by type, by hour, etc.).

   You can find it here (along with some screenshots etc.)

      http://opensource.pearshealthcyber.cz/

   It's the first revision of the first project we publish, but we hope
   everything will go smoothly. If you'll find some bug or if you have
   some feature you'd like to have in there, let us know. Just write an
   e-mail directly to me, as I'm responsible for OS projects, and I'll
   try to fix that.

   Tomas Vondra
   <tomas.vondra@farmacie.cz>
   Pears Health Cyber Ltd.

--

 Programming today is a race between software engineers striving to
 build bigger and better idiot-proof programs, and the universe trying
 to build bigger and better idiots. So far, the universe is winning.