All releases of Practical Query Analyzer

  •  28 Nov 2005 06:16
Avatar

    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
    Avatar

      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
      Avatar

        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
        Avatar

          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
          Avatar

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

            •  07 Jun 2004 19:44
            Avatar

              Release Notes: The syslog report now includes duration information, there are more text reports, and this release runs a bit faster than 1.0.

              •  17 May 2004 20:47
              Avatar

                Release Notes: 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.

                •  11 May 2004 17:31
                Avatar

                  Release Notes: 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.

                  •  07 May 2004 19:40
                  Avatar

                    Release Notes: 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.

                    •  28 Apr 2004 20:32
                    Avatar

                      Release Notes: 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.

                      Screenshot

                      Project Spotlight

                      episoder

                      A tool to tell you about new episodes of your favourite TV shows.

                      Screenshot

                      Project Spotlight

                      BalanceNG

                      A modern software IP load balancer.