Projects / Practical Query Analyzer

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.


Recent releases

  •  28 Nov 2005 06:16

    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.]".

    •  31 Jan 2005 18:51

      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.

      •  27 Jul 2004 21:05

        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.

        •  18 Jun 2004 20:36

          Release Notes: 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 22:33

            Release Notes: This release includes MySQL support. A "-logtype mysql" option has been added.


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.