Practical Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type (select/insert/update/delete), and more for both PostgreSQL and MySQL log files.
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.
This release fixes a silly bug that prevented it from being run directly. It has various internal improvements. If you install it via RubyGems, you can run it using "pqa -f file1 [file2, etc.]".
A bug that would sometimes associate a duration
measurement with the incorrect query was fixed. A
bug which would cause the HTML report to error out
with a nil-dereference exception was fixed. A bug
which caused PQA to choke on SQL statements that
were issued as part of a stored procedure was
fixed. The ability to run under Ruby 1.6.8 was
restored.
Several bugs have been fixed in the syslog parser; which should be less likely to report lines like "postgres started" as errors. Also, it checks for both LOG and DEBUG lines.
