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.
Now numbers are normalized, e.g. "select bar where foo=222" normalizes to the same query as "select bar where foo=123312321". This means more accurate information on what queries are occurring most frequently, taking the most time, etc.. OverallStatsReport no longer displays "longest ran in 0.0 seconds". OverallStatsReport now displays the correct number of unique queries. 0.9 listed the same number for both total and unique queries. Various bugs in syslog parsing have been fixed. It's still a better idea to use the PostgreSQL log, though.
This release adds the ability to handle PostgreSQL logs where log_pid/log_timestamp/log_connection has been enabled. It has been modified to support both "query:" and "statement:" as log entry preambles (i.e., it works with PostgreSQL 7.4 logs now). The SQL colorizing works a bit better, and the documentation has been updated to include better postgresql.conf configuration details.
This release adds UPDATE queries to the "Queries by type" report,
support for parsing query duration data from the PostgreSQL log, a
"Queries that took up the most time" report, a "Slowest queries" report,
and a table of contents for the HTML report.
This release adds support for using a PostgreSQL log file (syslog is still supported). A bug which resulted in errors if the number of valid queries in a log was less than -top has been fixed. The SQL colorizing works a bit better now. There are various tweaks to the HTML reports.
