]>
granicus.if.org Git - pgbadger/log
Gilles Darold [Fri, 29 Jul 2016 22:29:29 +0000 (00:29 +0200)]
Huge rewrite of the incremental mechanism applied to log files to handle PostgreSQL and pgbouncer logs at the same time. Multiprocess can now be used with pgbouncer log.
Gilles Darold [Thu, 28 Jul 2016 13:57:13 +0000 (15:57 +0200)]
Revert "Fix description of -l | --last-parsed option."
This reverts commit
1463129df1ff0961249a3ea6a0645f1489033e9b .
Gilles Darold [Thu, 28 Jul 2016 13:26:00 +0000 (15:26 +0200)]
Fix description of -l | --last-parsed option.
Gilles Darold [Tue, 5 Jul 2016 15:23:19 +0000 (17:23 +0200)]
Add code to remove remaining $$PGBGYA$$ tags.
Darold Gilles [Fri, 1 Jul 2016 13:00:34 +0000 (15:00 +0200)]
Remove a debug line.
Darold Gilles [Thu, 30 Jun 2016 09:44:58 +0000 (11:44 +0200)]
Fix an other possible case of truncated date in LAST_PARSED file. Thanks to brafaeloliveira for the report.
Darold Gilles [Wed, 22 Jun 2016 10:50:08 +0000 (12:50 +0200)]
Set default scale to 1 in pretty_print_number() javascript function.
Darold Gilles [Wed, 22 Jun 2016 10:25:25 +0000 (12:25 +0200)]
Fix autodetection of PgBouncer files containing only stats lines. Thanks to Glyn Astill for the patch.
Darold Gilles [Wed, 15 Jun 2016 13:56:00 +0000 (15:56 +0200)]
Add date to samples of queries generating most temporary files.
Gilles Darold [Fri, 10 Jun 2016 16:27:56 +0000 (18:27 +0200)]
Fix other case of warning message of empty file.
Gilles Darold [Fri, 10 Jun 2016 16:24:50 +0000 (18:24 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Gilles Darold [Fri, 10 Jun 2016 16:24:26 +0000 (18:24 +0200)]
DOn not display warning message of empty log when quiet mode is enable.
Darold [Thu, 9 Jun 2016 20:43:53 +0000 (22:43 +0200)]
Merge pull request #282 from robertvargason/read_from_stdin_hotfix
Fix reading from stdin by disabling pgbouncer file format detection
Robert Vargason [Thu, 9 Jun 2016 08:41:34 +0000 (10:41 +0200)]
Fix reading from stdin by disabling pgbouncer file format detection
Gilles Darold [Thu, 9 Jun 2016 07:35:47 +0000 (09:35 +0200)]
Fix case of duplicate normalyzed error message with "nonstandard use of ...".
Darold Gilles [Sat, 4 Jun 2016 09:42:12 +0000 (20:42 +1100)]
Fix storage of current temporary file related request.
Darold [Mon, 23 May 2016 20:32:26 +0000 (07:32 +1100)]
Merge pull request #278 from komeda-shinji/master
We should use the mnemonic rather than a signal number.
KOMEDA Shinji [Mon, 23 May 2016 11:06:08 +0000 (20:06 +0900)]
We should use the mnemonic rather than a signal number.
Gilles Darold [Thu, 21 Apr 2016 14:05:38 +0000 (16:05 +0200)]
Update ChangeLog and version to 8.1.
Darold Gilles [Mon, 18 Apr 2016 17:15:01 +0000 (19:15 +0200)]
Fix case where pid file remain after dying.
Darold Gilles [Mon, 18 Apr 2016 08:07:49 +0000 (10:07 +0200)]
Add requirement of log_error_verbosity = default to documentation.
Darold Gilles [Thu, 31 Mar 2016 16:34:50 +0000 (18:34 +0200)]
Report message "LOG: using stale statistics instead of current ones because stats collector is not responding" in events view.
Darold Gilles [Fri, 25 Mar 2016 08:51:53 +0000 (09:51 +0100)]
Remove obsolte days when we are in binary mode with noreport
Darold Gilles [Tue, 22 Mar 2016 14:16:52 +0000 (15:16 +0100)]
Fix wrong report of statements responsible of temporary files. Thanks to Luan Nicolini Marcondes for the report. This patch also exclude lien with log level LOCATION to be parsed.
Darold Gilles [Thu, 17 Mar 2016 15:01:05 +0000 (16:01 +0100)]
Fix limit on number of sample at report generation and remove pending LAST_PARSED.tmp file.
Darold Gilles [Thu, 17 Mar 2016 12:37:44 +0000 (13:37 +0100)]
Add tool to export errors statistics rport in docuwiki format.
Darold Gilles [Thu, 17 Mar 2016 12:35:57 +0000 (13:35 +0100)]
Update load_stat() function and global variables to support pgbouncer statistics. Update version to 2.0.
Darold [Mon, 14 Mar 2016 15:04:14 +0000 (16:04 +0100)]
Merge pull request #267 from rjuju/expand_query_type
Handle more kind or query types.
Julien Rouhaud [Mon, 14 Mar 2016 14:22:56 +0000 (15:22 +0100)]
Handle more kind or query types.
Darold Gilles [Mon, 14 Mar 2016 13:44:44 +0000 (14:44 +0100)]
Fix pgbouncer log parser to handle message: FATAL: the database system is shutting down
Darold Gilles [Sat, 12 Mar 2016 11:02:30 +0000 (12:02 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Sat, 12 Mar 2016 11:02:16 +0000 (12:02 +0100)]
Fix whitespace placed in between the E and the quote character. Thanks to clijunky for the report.
Darold Gilles [Wed, 24 Feb 2016 15:24:07 +0000 (16:24 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Wed, 24 Feb 2016 15:23:50 +0000 (16:23 +0100)]
Fix a major issue introduced with support to pgbouncer that prevent parsing of compressed PostgreSQL log files. Thanks to Levente Birta for the report.
Darold Gilles [Mon, 22 Feb 2016 11:12:44 +0000 (12:12 +0100)]
Update ChangeLog and version to 8.0
Darold Gilles [Mon, 22 Feb 2016 11:09:48 +0000 (12:09 +0100)]
Update documentation about new options and pgbouncer reports.
Darold Gilles [Mon, 22 Feb 2016 11:04:25 +0000 (12:04 +0100)]
Fix typo in pgbouncer report.
Darold Gilles [Fri, 19 Feb 2016 19:32:49 +0000 (20:32 +0100)]
Add report about Most used reserved pools
Darold Gilles [Fri, 19 Feb 2016 13:47:44 +0000 (14:47 +0100)]
Fix progress bar with pgbouncer (only events are increased).
Darold Gilles [Fri, 19 Feb 2016 10:44:29 +0000 (11:44 +0100)]
Add reports on pgBouncer log file.
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.