]>
granicus.if.org Git - pgbadger/log
Darold Gilles [Sun, 14 Feb 2016 09:24:32 +0000 (10:24 +0100)]
fix an other operator order issue.
Darold [Sun, 14 Feb 2016 09:21:08 +0000 (10:21 +0100)]
Merge pull request #265 from nginfo/master
Sort %SYMBOLS hashtable to remove "!=" / "=" bug.
Nicolas [Sat, 13 Feb 2016 19:30:49 +0000 (20:30 +0100)]
Sort %SYMBOLE hashtable for remove "!=" / "=" bug.
Darold Gilles [Sat, 6 Feb 2016 09:56:21 +0000 (10:56 +0100)]
Fix incorrect numbers on positional parameters in queries-generating-most-temporary-files. Thanks to Oskar Wiksten for the report.
Darold Gilles [Sat, 6 Feb 2016 09:27:06 +0000 (10:27 +0100)]
Update operators list in SQL code beautifier with last update in pgFormatter. Thanks to Laurenz Albe for the report and the list of missing operators.
Darold Gilles [Tue, 19 Jan 2016 22:21:48 +0000 (23:21 +0100)]
Cosmetic change to code and add some more debug information.
Darold Gilles [Tue, 19 Jan 2016 20:13:21 +0000 (21:13 +0100)]
Add --rebuild option to be able to rebuild all html reports in an incremental output directory where there is binary data files.
Darold Gilles [Mon, 18 Jan 2016 20:45:17 +0000 (21:45 +0100)]
Fix an other major bug introduced with journalctl code that prevent the use of the multiprocess.
Darold Gilles [Mon, 18 Jan 2016 10:22:37 +0000 (11:22 +0100)]
Update changelog and version to 7.3
Darold Gilles [Mon, 18 Jan 2016 09:11:51 +0000 (10:11 +0100)]
Automatically remove obsolete pid file when there is no other pgbadger process running (unix only)
Darold Gilles [Fri, 15 Jan 2016 23:17:05 +0000 (00:17 +0100)]
Update documentation about the --timezone command line option.
Darold Gilles [Fri, 15 Jan 2016 23:14:43 +0000 (00:14 +0100)]
Add --timezone=+/-HH to control the timezone used in charts. The javascript library runs at client side so the timezone used is the browser timezone so the displayed time in the charts can be different from the time in the log file. Thanks to CZAirwolf for the report.
Darold Gilles [Fri, 15 Jan 2016 21:49:39 +0000 (22:49 +0100)]
Fix Histogram of session times when there is no data.
Darold Gilles [Fri, 15 Jan 2016 21:45:58 +0000 (22:45 +0100)]
Fix unclosed test file.
Darold Gilles [Fri, 15 Jan 2016 21:38:16 +0000 (22:38 +0100)]
Fix an other case where pgbadger.pid was not removed.
Darold Gilles [Fri, 15 Jan 2016 21:35:05 +0000 (22:35 +0100)]
Always display slides part on connections report even if there is no data.
Darold Gilles [Fri, 15 Jan 2016 21:33:23 +0000 (22:33 +0100)]
Fix some label on sessions reports
Darold Gilles [Fri, 15 Jan 2016 21:29:35 +0000 (22:29 +0100)]
Add remove of pid file at normal ending.
Darold Gilles [Fri, 15 Jan 2016 13:04:18 +0000 (14:04 +0100)]
Fix wrong size/offset of log files that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem.
Darold Gilles [Fri, 15 Jan 2016 13:01:40 +0000 (14:01 +0100)]
Revert "Fix wrong size/offset of log files with unicode characters that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem."
This reverts commit
8775053eb06a2c2bf8fd6995e1f42ea82e3c88b3 .
Darold Gilles [Fri, 15 Jan 2016 12:46:33 +0000 (13:46 +0100)]
Fix wrong size/offset of log files with unicode characters that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem.
Darold Gilles [Thu, 14 Jan 2016 21:17:33 +0000 (22:17 +0100)]
Add command line option --pid-dir to be able to run two pgbadger at the same time
by setting an alternate path to the directory where the pid file will be written.
Darold Gilles [Thu, 14 Jan 2016 21:11:37 +0000 (22:11 +0100)]
Add pgbadger.pid file to prevent cron jobs overlaping on same log files.
Darold Gilles [Thu, 14 Jan 2016 15:48:36 +0000 (16:48 +0100)]
Report information about "LOG: skipping analyze of ..." into events reports.
Darold Gilles [Thu, 14 Jan 2016 14:12:52 +0000 (15:12 +0100)]
Report information about "LOG: sending cancel to blocking autovacuum" into events reports. Usefull to know which queries generate autovacuum kill do to a lock issue.
Darold Gilles [Wed, 13 Jan 2016 15:02:41 +0000 (16:02 +0100)]
Add more debug information about check log parsing decision.
Darold Gilles [Wed, 6 Jan 2016 08:37:02 +0000 (09:37 +0100)]
Update version to 7.2
Darold Gilles [Tue, 5 Jan 2016 19:40:11 +0000 (20:40 +0100)]
Update ChangeLog and version to 7.2
Darold Gilles [Tue, 5 Jan 2016 19:22:54 +0000 (20:22 +0100)]
Update copyright year.
Darold Gilles [Thu, 3 Dec 2015 14:56:52 +0000 (15:56 +0100)]
Fix missing detailed information (date, db, etc.) in Queries generating the largest temporary files report.
Darold Gilles [Thu, 3 Dec 2015 14:48:16 +0000 (15:48 +0100)]
Fix label of sessions histogram. Thanks to Guillaume Lelarge for the patch.
Darold Gilles [Thu, 3 Dec 2015 11:57:15 +0000 (12:57 +0100)]
Fix to handle cancelled query that generate more than one temporary file and more generaly aggregate size on queries with multiple > 1GB temporary files.
Darold Gilles [Thu, 3 Dec 2015 09:06:21 +0000 (10:06 +0100)]
Add "Total size" column in Temporary Files Activity table and fix size increment when a query have multiple 1GB temporary file.
Darold Gilles [Wed, 2 Dec 2015 22:33:44 +0000 (23:33 +0100)]
Fix temporary file query normailzation and examples
Darold Gilles [Fri, 27 Nov 2015 15:36:12 +0000 (16:36 +0100)]
Fix usage
Darold Gilles [Thu, 26 Nov 2015 15:54:46 +0000 (16:54 +0100)]
Add support to journalctl command output and add --journalctl_cmd command line option to enable this functionnality and set the command. Typically: --journalctl_cmd "journalctl -u postgresql-9.4"
Darold Gilles [Wed, 25 Nov 2015 16:20:35 +0000 (17:20 +0100)]
Fix uncomplete and wrong queries associated to temporary files when STATEMENT level log line was missing. Thanks to Mael Rimbault for the report.
Darold Gilles [Sat, 21 Nov 2015 09:55:12 +0000 (10:55 +0100)]
When -w or --watch-mode is used, message "canceling statement due to statement timeout" should be reported with other errors.
Darold Gilles [Wed, 18 Nov 2015 19:08:22 +0000 (20:08 +0100)]
Fix an extra call to <script ...> in jqplot.pointLabels.min.js __DATA__ and remove some unused vars.
Darold Gilles [Thu, 12 Nov 2015 08:19:17 +0000 (09:19 +0100)]
Allow dot in dbname and user name. Thanks to David Turvey for the patch.
Darold Gilles [Sun, 8 Nov 2015 16:01:35 +0000 (17:01 +0100)]
Remove use of unmaintained flotr2 javascript chart library and use of jqflot instead. There is some little differences related to this change but not so much.
Darold Gilles [Mon, 19 Oct 2015 18:14:33 +0000 (20:14 +0200)]
Fix bad formatting with anonymized values in queries.
Darold Gilles [Mon, 12 Oct 2015 20:29:09 +0000 (22:29 +0200)]
Add new keywords from PG 9.5 for code formating
Darold Gilles [Mon, 12 Oct 2015 19:17:25 +0000 (21:17 +0200)]
Add support to %n log_line_prefix option for Unix epoch (PG 9.6).
Darold Gilles [Mon, 12 Oct 2015 15:10:18 +0000 (17:10 +0200)]
Display 0ms instead of 0s when qery time is under the millisecond. Thanks to venkatabn for the report.
Darold Gilles [Fri, 18 Sep 2015 13:40:26 +0000 (15:40 +0200)]
Extend regex on cursor name normalization.
Darold [Fri, 18 Sep 2015 13:34:26 +0000 (15:34 +0200)]
Merge pull request #252 from rjuju/fix_cursor
Normalize cursor names
Julien Rouhaud [Fri, 18 Sep 2015 13:23:22 +0000 (15:23 +0200)]
Normalize cursor names
Darold Gilles [Sat, 15 Aug 2015 08:33:58 +0000 (19:33 +1100)]
Fix unregistred client hostname with default pattern. Thanks to Eric S. Lucinger Ruiz for the report.
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.