Add tree new report: Number of cancelled queries (graph), Queries generating the most cancellation (N) and Queries most cancelled lists. Thanks to Thomas Reiss for the feature request.
Fix case where temporary file statement must be retrieved from the previous LOG statement and not in the following STATEMENT log entry. Thanks to Mael Rimbault for the report.
Darold Gilles [Thu, 26 Mar 2015 18:59:44 +0000 (19:59 +0100)]
Add per user detail information (total duration and times executed) for each query reported in "Time consuming queries", "Most frequent queries" "and Normalized slowest queries". The details are visible from a new button called "User(s) involved" near the "Examples" button. Thanks to Guillaume Le Bihan for the patch and tsn77130 for the feature request.
Darold Gilles [Thu, 19 Mar 2015 12:13:50 +0000 (13:13 +0100)]
Fix non closing session when a process crash with message: "terminating connection because of crash of another server process". Thanks to Mael Rimbault for the report.
Darold Gilles [Thu, 12 Feb 2015 13:07:06 +0000 (14:07 +0100)]
Add --log-duration command line option to force pgbadger to associate log entries generated by both log_duration = on and log_statement = all. Thanks to grzeg1 for the feature request.
jacksonfoz [Fri, 19 Dec 2014 14:09:27 +0000 (12:09 -0200)]
Add support to log timezones with + and - signs
pgbadger does not recognize log files (queries and events) with timezones like 'GMT+3'.
On postgresql.conf file the log_timezone variable is set as 'Etc/GMT+3' and lines are generated like this (stderr format):
2014-12-19 00:02:40 GMT+3 [1981]: [239-1] user=,db= LOG: checkpoint starting: time
Darold Gilles [Wed, 17 Dec 2014 22:47:29 +0000 (23:47 +0100)]
Add --noreport command line option to intruct pgbadger to not build any reports in incremental mode. pgBadger will only create binary files. Thanks to hubert Depesz Lubaczewski for the feature request.
Darold Gilles [Mon, 15 Dec 2014 12:25:27 +0000 (13:25 +0100)]
Add more details about the CSV parser error. It now prints the line number and the last parameter that generate the failure. This should allow to see the malformed log entry.
Dalibo [Tue, 11 Nov 2014 21:49:13 +0000 (22:49 +0100)]
Fix wrong count of min/max queries per second. Thanks to Guillaume Lelarge for the report. Add COPY statement to SELECT or INSERT statements statistics.
Dalibo [Fri, 7 Nov 2014 22:50:56 +0000 (23:50 +0100)]
Add "Average queries per session" and "Average queries duration per session" in Sessions tab of the Global stat. Thanks to Guillaume Lelarge for the feature request.
Dalibo [Fri, 7 Nov 2014 18:03:58 +0000 (19:03 +0100)]
Add --explain-time-consuming and --explain-normalized to generate explain statement about top time consuming and top normalized slowest queries. Thanks to Josh Kupershmid fot the feature request.
Darold Gilles [Tue, 7 Oct 2014 17:25:22 +0000 (19:25 +0200)]
Add -D | --dns-resolv command line option to replace ip adresses by their DNS name. Be warned that this can slow down pgBagder a lot. Thanks to Jiri Hlinka for the feature request.
Darold Gilles [Tue, 7 Oct 2014 08:41:23 +0000 (10:41 +0200)]
Do not display queries in Slowest individual, Time consuming and Normalized slowest queries reports when there is no duration in log file. Diplay NO DATASET instead.
Enable allow_loose_quotes and undef escape_char in Text::CSV_XS call to fix CSV format error when fields have quote inside an unquoted field. Thanks to Josh Berkus for the report.
Add --file-per-query and --format-query option to write each slowest query in a separate file named qryXXX.sql and perform minimal formating of the queries. Thanks to Rodolphe Quiedeville for the patch.
Allow pgbadger_tools --explain-slowest to automatically execute the EXPLAIN statements an report the plan. See pgbadger_tools --help for more explanation.
Add a new program pgbadger_tools.pl to demonstrate how to deal with pgBadger binary files to build your own new feature. The first one 'explain-slowest' allow printing of top slowest queries as EXPLAIN statements.