From 19e249c7e332a17215ac5eb2db4cb706e7fc2f30 Mon Sep 17 00:00:00 2001 From: Darold Gilles Date: Fri, 27 Mar 2015 14:40:56 +0100 Subject: [PATCH] Update ChangeLog and version to 6.3 --- ChangeLog | 112 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ pgbadger | 2 +- 2 files changed, 113 insertions(+), 1 deletion(-) diff --git a/ChangeLog b/ChangeLog index 8f09954..0f6e24e 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,3 +1,115 @@ +2015-03-27 version 6.3 + +This new release fixes some bugs and adds some new reports: + + * A new per user details (total duration and times executed) for each query + reported in Top Queries reports. The details are visible from a new button + called "User(s) involved". + * Add "Average queries per session" and "Average queries duration per session" + in Sessions tab of the Global statistics. + * Add connection time histogram. + * Use bar graph for Histogram of query times and sessions times. + +There's also some cool new features and options: + + * Add -L | --logfile-list option to read a list of logfiles from an external + file. + * Add support to log_timezones with + and - signs for timestamp with + milliseconds (%m). + * Add --noreport option to instruct pgbadger to not build any HTML reports + in incremental mode. pgBadger will only create binary files. + * Add auto detection of client=%h or remote=%h from the log so that adding + a prefix is not needed when it respect the default of pgbadger. + * Redefine sessions duration histogram bound to be more accurate. + * Add new option -M | --no-multiline to not collect multi-line statement + and avoid storing and reporting garbage when needed. + * Add --log-duration option to force pgbadger to associate log entries + generated by both log_duration=on and log_statement=all. + +The pgbadger_tools script have also been improve with new features: + + * Add a new tool to pgbadger_tool to output top queries in CSV format for + follow-up analysis. + * Add --explain-time-consuming and --explain-normalized options to generate + explain statement about top time consuming and top normalized slowest + queries. + +Here is the full list of changes/fixes: + + - Update flotr2.min.js to latest github code. + - 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. + - pgbadger_tool: add tool to output top queries to CSV format, for + follow-up analysis. Thanks to briklen for the patch. + - Add geometric operators to SQL beautifier. Thanks to Rodolphe + Quiedeville for the report. + - 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. + - Add -L|--logfile-list command line option to read a list of logfiles + from a file. Thanks to Hubert depesz Lubaczewski for the feature + request. + - Automatically remove %q from prefix. Thanks to mbecroft for report. + - Do not store DEALLOCATE log entries anymore. + - Fix queries histogram where range was not appears in the right order. + Thanks to Grzegorz Garlewicz for the report. + - Fix min yaxis in histogram graph. Thanks to grzeg1 for the patch. + - 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. + - Small typographical corrections. Thanks to Jefferson Queiroz Venerando + and Bill Mitchell the patches. + - Reformat usage output and add explanation of the --noreport command + line option. + - Fix documentation about minimal pattern in custom log format. Thanks + to Julien Rouhaud for the suggestion. + - Add support to log_timezones with + and - signs to timestamp with + milliseconds (%m). Thanks to jacksonfoz for the patch. + pgbadger was not recognize log files with timezones like 'GMT+3'. + - Add --noreport command line option to instruct pgbadger to not build + any reports in incremental mode. pgBadger will only create binary + files. Thanks to hubert Depesz Lubaczewski for the feature request. + - Add time consuming information in tables of Queries per database... + Thanks to Thomas for the feature request. + - 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. + - Change substitution markup in attempt to fix a new look-behind + assertions error. Thanks to Paolo Cavallini for the report. + - Use bar graph for Histogram of query times and sessions times. + - 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 following the copy direction (stdin or stdout). + - Fix Illegal division by zero at line 3832. Thanks to MarcoTrek for + the report. + - 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. + - Reformat numbers in pie graph tracker. Thanks to jirihlinka for the + report. + - pgbadger_tools: 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. + - Remove everything than error information from json output when -w | + --watch-mode is enable. Thanks to jason. + - Fix undefined subroutine encode_json when using -x json. Thanks to + jason for the report. + - Add auto detection of client=%h or remote=%h from the log so that + adding a prefix is not needed when it respect the default of pgbadger. + - Redefine sessions duration histogram bound to be more accurate. Thanks + to Guillaume Lelarge for the report. + - Add connection time histogram. Thanks to Guillaume Lelarge for the + feature request. + - Add new option -M | --no-multiline to not collect multi-line statement + to avoid garbage especially on errors that generate a huge report. + - Do not return SUCCESS error code 0 when aborted or something fails. + Thanks to Bruno Almeida for the patch. + 2014-10-07 version 6.2 This is a maintenance release to fix a regression in SQL traffic graphs and diff --git a/pgbadger b/pgbadger index 3155bd1..690ca28 100755 --- a/pgbadger +++ b/pgbadger @@ -50,7 +50,7 @@ use IO::Pipe; use FileHandle; use Socket; -$VERSION = '6.2'; +$VERSION = '6.3'; $SIG{'CHLD'} = 'DEFAULT'; -- 2.40.0