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.
|Tags||Database Database Engines/Servers|
Release Notes: 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.]".
Release Notes: 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.
Release Notes: 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.
Release Notes: MySQL support is better now, and there's a "parse errors" report to aid in troubleshooting. The default log format is "pglog".
Release Notes: This release includes MySQL support. A "-logtype mysql" option has been added.