Practical Query Analyzer
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 |
|---|---|
| Licenses | BSD Original |
| Implementation | Ruby |
Recent releases
- 27 Nov 2005 22:16
Changes: 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.]".
- 31 Jan 2005 10:51
Changes: 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.
- 27 Jul 2004 14:05
Changes: 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.
- 18 Jun 2004 13:36
Changes: MySQL support is better now, and there's a "parse errors" report to aid in troubleshooting. The default log format is "pglog".
- 08 Jun 2004 15:33
Changes: This release includes MySQL support. A "-logtype mysql" option has been added.
