]>
granicus.if.org Git - pgbadger/log
Darold Gilles [Sun, 26 Jul 2015 13:01:00 +0000 (15:01 +0200)]
Remove redundant regular expressions.
Darold Gilles [Sat, 25 Jul 2015 17:31:46 +0000 (19:31 +0200)]
Apply README changes from Josh Kupershmidt to source file doc/pgBadger.pod, README is generated using: pod2text doc/pgBadger.pod > README
Darold [Sat, 25 Jul 2015 17:01:54 +0000 (19:01 +0200)]
Merge pull request #246 from schmiddy/readme-fixes
Various README fixes
Josh Kupershmidt [Sat, 25 Jul 2015 16:50:37 +0000 (09:50 -0700)]
Few more copyediting fixes.
Josh Kupershmidt [Fri, 24 Jul 2015 18:01:54 +0000 (11:01 -0700)]
Copyediting of the README.
Tweaking awkward phrasing, correcting subject-verb agreements, typos,
and misspellings. Capitalize "pgBadger" consistently to refer to the program
other than command-line examples, where it should be all-lowercase.
Darold Gilles [Tue, 21 Jul 2015 08:08:36 +0000 (10:08 +0200)]
Fix potential incorrect creation of subdirectory in incremental mode.
Darold Gilles [Wed, 15 Jul 2015 07:17:57 +0000 (09:17 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Wed, 15 Jul 2015 07:17:37 +0000 (09:17 +0200)]
Allow single white space after duration even if this should not appear.
Darold Gilles [Sat, 11 Jul 2015 09:42:22 +0000 (11:42 +0200)]
Update ChangeLog and version to 7.1
Darold Gilles [Wed, 1 Jul 2015 17:23:39 +0000 (19:23 +0200)]
Fix unwanted seek on old parsing position when log entry is stdin. Thanks to Olivier Schiavo for the report.
Darold Gilles [Tue, 30 Jun 2015 16:03:01 +0000 (18:03 +0200)]
Try to fix a potential issue in log start/end date parsing. Thanks to gityerhubhere for the report.
Darold Gilles [Tue, 30 Jun 2015 15:27:10 +0000 (17:27 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Mon, 22 Jun 2015 16:36:48 +0000 (18:36 +0200)]
Fix broken queries with multiline in bind parameters. Thank to Nicolas Thauvin for the report.
Darold Gilles [Tue, 26 May 2015 07:41:30 +0000 (09:41 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Tue, 19 May 2015 21:34:16 +0000 (23:34 +0200)]
Add new report Sessions per application. Thanks to Keith Fiske for the feature request.
Darold Gilles [Wed, 13 May 2015 15:21:34 +0000 (17:21 +0200)]
Add Json Operators to SQL Beautifier. Thanks to Tom Burnett and Hubert depesz Lubaczewski.
Darold [Wed, 13 May 2015 15:02:49 +0000 (17:02 +0200)]
Merge pull request #238 from ISVTEC/master
Makefile.PL: changed manpage section from '1' to '1p', fixes #237
Cyril Bouthors [Wed, 13 May 2015 13:50:51 +0000 (17:50 +0400)]
Makefile.PL: changed manpage section from '1' to '1p', fixes #237
Darold Gilles [Wed, 13 May 2015 06:56:22 +0000 (08:56 +0200)]
Update Copyright date-range and installation instructions that was still refering to version 5. Thanks to Steve Crawford for the report.
Darold Gilles [Fri, 8 May 2015 17:10:39 +0000 (19:10 +0200)]
Fix typo in changelog
Darold Gilles [Fri, 8 May 2015 17:05:59 +0000 (19:05 +0200)]
Update ChangeLog and version to 7.0
Darold Gilles [Fri, 8 May 2015 16:57:45 +0000 (18:57 +0200)]
Fix link anchor on duration by user report.
Darold Gilles [Fri, 8 May 2015 16:39:29 +0000 (18:39 +0200)]
Update documentation.
Darold Gilles [Fri, 8 May 2015 16:36:01 +0000 (18:36 +0200)]
Fix number of event samples displayed in event reports.
Darold Gilles [Fri, 8 May 2015 16:35:12 +0000 (18:35 +0200)]
Add new report about events distribution per x minutes.
Darold Gilles [Fri, 8 May 2015 12:48:36 +0000 (14:48 +0200)]
Add app=%a default prefix to documentation.
Darold Gilles [Fri, 8 May 2015 12:41:40 +0000 (14:41 +0200)]
Add reports of "App(s) involved" with top queries. Thanks to Antti Koivisto for the feature request.
Darold Gilles [Thu, 23 Apr 2015 13:30:22 +0000 (15:30 +0200)]
Remove newline between a ) and , in the beautifier.
Darold Gilles [Fri, 17 Apr 2015 14:49:04 +0000 (16:49 +0200)]
Add link to automatically open the explain plan on http://explain.depesz.com/
Darold Gilles [Fri, 17 Apr 2015 13:49:11 +0000 (15:49 +0200)]
Add support to auto_explain, EXPLAIN plan will be added together with top slowest queries whane available in the log file.
Darold Gilles [Fri, 17 Apr 2015 08:11:51 +0000 (10:11 +0200)]
Update documentation with last reports.
Darold Gilles [Thu, 16 Apr 2015 17:42:09 +0000 (19:42 +0200)]
Solve some issues from pull request #234, Duration Chart is now an independant chart linked to a menu called "Duration per user".
Darold [Thu, 16 Apr 2015 17:38:54 +0000 (19:38 +0200)]
Merge pull request #234 from Korriliam/master
A graph embedding the time per user
Darold Gilles [Thu, 16 Apr 2015 16:00:52 +0000 (18:00 +0200)]
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.
Darold Gilles [Tue, 14 Apr 2015 15:05:26 +0000 (17:05 +0200)]
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 [Mon, 13 Apr 2015 11:55:34 +0000 (13:55 +0200)]
Add --enable-checksum to show a md5 hash of each reported queries. Thanks to Thomas Reiss for the feature request.
Darold Gilles [Mon, 13 Apr 2015 07:25:43 +0000 (09:25 +0200)]
Update ChangeLog and version to 9.4
Darold Gilles [Fri, 10 Apr 2015 14:58:47 +0000 (16:58 +0200)]
Make anonymization more useful. Thanks to Hubert depesz Lubaczewski for the patch.
Darold Gilles [Thu, 9 Apr 2015 17:57:14 +0000 (19:57 +0200)]
Fix previous patch for csvlog generated with a PostgreSQL version before 9.0
Darold [Thu, 9 Apr 2015 17:38:40 +0000 (19:38 +0200)]
Merge pull request #233 from eshkinkot/master
Try continue CSV parsing after broken CSV line
Darold Gilles [Thu, 9 Apr 2015 17:33:51 +0000 (19:33 +0200)]
Fix bug in SQL beautifier which removed operator. Thanks to Thomas Reiss for the report.
Sergey Burladyan [Thu, 9 Apr 2015 12:41:17 +0000 (15:41 +0300)]
Fix loop exit, check terminate quickly and correct comments indentation
Sergey Burladyan [Thu, 9 Apr 2015 11:08:46 +0000 (14:08 +0300)]
Try continue CSV parsing after broken CSV line
Guillaume Le Bihan [Thu, 2 Apr 2015 12:52:07 +0000 (14:52 +0200)]
Merge https://github.com/dalibo/pgbadger
Guillaume Le Bihan [Mon, 30 Mar 2015 12:49:51 +0000 (14:49 +0200)]
Add in Queries by user a graph showing the duration proportion per user. Some troubles with js.
Darold Gilles [Fri, 27 Mar 2015 13:40:56 +0000 (14:40 +0100)]
Update ChangeLog and version to 6.3
Darold Gilles [Fri, 27 Mar 2015 12:56:39 +0000 (13:56 +0100)]
Update flotr2.min.js to latest github code.
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.
Guillaume Le Bihan [Thu, 26 Mar 2015 10:56:14 +0000 (11:56 +0100)]
Added += for normalyzed_user
Guillaume Le Bihan [Tue, 24 Mar 2015 15:17:09 +0000 (16:17 +0100)]
Some changes in load_stats sub...
Guillaume Le Bihan [Tue, 24 Mar 2015 14:26:40 +0000 (15:26 +0100)]
Fix for the multiprocessing and the recording of the value in tmp file.
Darold Gilles [Fri, 20 Mar 2015 21:57:58 +0000 (22:57 +0100)]
Add full example to chain pgbadger and pgbadger_tool with --csv-slowest.
Darold Gilles [Fri, 20 Mar 2015 21:52:59 +0000 (22:52 +0100)]
Add tool to output top queries to CSV format, for follow-up analysis. Thanks to briklen for the patch.
Guillaume Le Bihan [Thu, 19 Mar 2015 17:30:00 +0000 (18:30 +0100)]
Add a list of user involved to the time consuming queries panel and to the Most frequent queries one.
Darold Gilles [Thu, 19 Mar 2015 12:40:49 +0000 (13:40 +0100)]
Add geometric operators. Thanks to Rodolphe Quiedeville for the report.
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, 5 Mar 2015 16:32:09 +0000 (17:32 +0100)]
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.
Darold Gilles [Sun, 1 Mar 2015 09:25:33 +0000 (10:25 +0100)]
Automatically remove %q from prefix. Thanks to mbecroft for the report.
Darold Gilles [Thu, 26 Feb 2015 17:01:22 +0000 (18:01 +0100)]
Fix broken counting of queries/sec after last changes about log_duration. Thanks to Grzegorz Garlewicz for the report.
Darold Gilles [Thu, 12 Feb 2015 18:46:45 +0000 (19:46 +0100)]
Do not store DEALLOCATE log entries.
Darold Gilles [Thu, 12 Feb 2015 15:23:19 +0000 (16:23 +0100)]
Fix queries histogram where range was not appears in the right order. Thanks to Grzegorz Garlewicz for the report.
Darold Gilles [Thu, 12 Feb 2015 14:00:25 +0000 (15:00 +0100)]
Fix min yaxis in histogram graph. Thanks to grzeg1 for the patch.
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.
Darold [Wed, 4 Feb 2015 12:24:46 +0000 (13:24 +0100)]
Merge pull request #220 from shamanime/patch-1
Fix typo in 'queries'
Jefferson Queiroz Venerando [Wed, 4 Feb 2015 12:05:06 +0000 (10:05 -0200)]
Fix typo in 'queries'
The first letter was missing.
Darold Gilles [Tue, 6 Jan 2015 21:54:03 +0000 (22:54 +0100)]
Reformat usage output and add explanation of the --noreport command line option.
Darold [Fri, 2 Jan 2015 09:18:18 +0000 (10:18 +0100)]
Merge pull request #219 from vocatan/master
Small typographical corrections
Bill Mitchell [Tue, 30 Dec 2014 18:43:53 +0000 (13:43 -0500)]
Small typographical corrections
Dalibo [Tue, 30 Dec 2014 11:18:57 +0000 (12:18 +0100)]
Fix documentation about minimal pattern in custom log format. Thanks to Julien Rouhaud for the suggestion.
Dalibo [Fri, 19 Dec 2014 14:28:25 +0000 (15:28 +0100)]
Add support to log_timezones with + and - signs to timestamp with milliseconds (%m).
Darold [Fri, 19 Dec 2014 14:26:08 +0000 (15:26 +0100)]
Merge pull request #218 from jacksonfoz/patch-1
Add support to log_timezones with + and - signs
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 [Wed, 17 Dec 2014 19:43:56 +0000 (20:43 +0100)]
Add time consuming information in tables of Queries per database/application/user/host. Thanks to Thomas 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.
Darold Gilles [Fri, 28 Nov 2014 12:03:28 +0000 (13:03 +0100)]
Change substitution markup in apptempt to fix a new look-behind assertions error. Thanks to Paolo Cavallini for the report.
Dalibo [Thu, 13 Nov 2014 18:09:35 +0000 (19:09 +0100)]
Use bar graph for Histogram of query times.
Dalibo [Thu, 13 Nov 2014 17:16:28 +0000 (18:16 +0100)]
Use bar graph in histogram of sessions times
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 [Tue, 11 Nov 2014 12:12:34 +0000 (13:12 +0100)]
Fix Illegal division by zero at line 3832. Thanks to MarcoTrek for the report.
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 19:52:05 +0000 (20:52 +0100)]
Reformat numbers in pie graph tracker. Thanks to jirihlinka for the report.
Dalibo [Fri, 7 Nov 2014 19:36:18 +0000 (20:36 +0100)]
Add formating of number in pie graph tracker.
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 [Mon, 3 Nov 2014 19:31:16 +0000 (20:31 +0100)]
Remove everything that error_info from json output when -w | --watch-mode is enable. Thanks to jason.
Darold Gilles [Mon, 3 Nov 2014 17:20:40 +0000 (18:20 +0100)]
Fix undefined subroutine encode_json when using -x json. Thanks to jason for the report.
Darold Gilles [Thu, 30 Oct 2014 17:40:01 +0000 (18:40 +0100)]
Add autodetection of client=%h or remote=%h from the log so that adding a prefix is not needed when it respect the default of pgbadger.
Darold Gilles [Wed, 29 Oct 2014 14:36:26 +0000 (15:36 +0100)]
Redefine sessions duration histogram bound. Thanks to Guillaume Lelarge for the report.
Darold Gilles [Wed, 29 Oct 2014 13:49:50 +0000 (14:49 +0100)]
Add connection time histogram. Thanks to Guillaume Lelarge for the feature request.
Darold Gilles [Fri, 17 Oct 2014 16:23:20 +0000 (18:23 +0200)]
Add new option -M | --no-multiline to not collect multiline statement to avoid garbage especially on errors that generate a huge report.
Darold [Wed, 8 Oct 2014 14:47:31 +0000 (16:47 +0200)]
Merge pull request #202 from brunomgalmeida/master
Do not return SUCCESS error code 0 when aborted or something fails
Bruno Almeida [Wed, 8 Oct 2014 11:11:58 +0000 (11:11 +0000)]
Do not return SUCCESS error code 0 when aborted or something fails
Darold Gilles [Tue, 7 Oct 2014 19:18:45 +0000 (21:18 +0200)]
Fix typo in ChangeLog.
Darold Gilles [Tue, 7 Oct 2014 19:02:04 +0000 (21:02 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Tue, 7 Oct 2014 18:58:35 +0000 (20:58 +0200)]
Update changelog and version to 6.2
Darold Gilles [Tue, 7 Oct 2014 18:58:35 +0000 (20:58 +0200)]
Update changelog and version to 6.1
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 14:24:31 +0000 (16:24 +0200)]
Add a note into documentation about prefix [%l-1]. Thanks to sterfield for the suggestion.
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.
Darold Gilles [Mon, 6 Oct 2014 13:39:04 +0000 (15:39 +0200)]
Remove CSV test modification.