]>
granicus.if.org Git - pgbadger/log
Darold Gilles [Wed, 14 Nov 2012 09:20:52 +0000 (10:20 +0100)]
Update version to 2.2
Darold Gilles [Tue, 13 Nov 2012 20:38:48 +0000 (21:38 +0100)]
Update Changelog and release version 2.2
Darold Gilles [Tue, 13 Nov 2012 20:16:16 +0000 (21:16 +0100)]
Add two more Pg keywords and run perltidy.
Darold Gilles [Tue, 13 Nov 2012 11:08:32 +0000 (12:08 +0100)]
Fix number of queries in progress bar with tsung output.
Darold Gilles [Mon, 12 Nov 2012 22:14:19 +0000 (23:14 +0100)]
Remove obsolete syslog-ng and temporary syslog-ll log format added to fix some syslog autodetection issues. There is now just one syslog format: syslog, differences between syslog formats are detected and the log parser is adaptive.
Darold Gilles [Mon, 12 Nov 2012 18:33:07 +0000 (19:33 +0100)]
Add comment about the check_incremental_position() method
Darold Gilles [Mon, 12 Nov 2012 15:49:43 +0000 (16:49 +0100)]
Fix bad report with empty graphs when log files was not in chronological order.
Darold Gilles [Wed, 7 Nov 2012 14:05:43 +0000 (15:05 +0100)]
Add report of the current total of queries and events parsed in progress bar. Thanks to Jehan-Guillaume de Rorthais for the patch.
Darold Gilles [Wed, 7 Nov 2012 10:53:59 +0000 (11:53 +0100)]
Fix parser on syslog with level info after the timestamp like <local0.info>. Thanks to Jehan-Guillaume de Rorthais for the report.
Darold Gilles [Wed, 7 Nov 2012 10:53:38 +0000 (11:53 +0100)]
Fix parser on syslog with level info after the timestamp like <local0.info>. Thanks to Jehan-Guillaume de Rorthais for the report.
Darold Gilles [Wed, 7 Nov 2012 01:10:14 +0000 (02:10 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold [Wed, 7 Nov 2012 01:08:05 +0000 (17:08 -0800)]
Merge pull request #39 from davidfetter/master
Text::CSV_XS is a good bit faster than Text::CSV
David Fetter [Tue, 6 Nov 2012 22:19:29 +0000 (14:19 -0800)]
s/Text::CSV/$&_XS/g
Darold Gilles [Mon, 5 Nov 2012 08:41:02 +0000 (09:41 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Mon, 5 Nov 2012 08:40:06 +0000 (09:40 +0100)]
Remove the use of dynamic variables on parsing some command line arguments.
Darold [Sun, 28 Oct 2012 16:51:29 +0000 (17:51 +0100)]
Fix several issue with tsung output.
Darold [Sun, 28 Oct 2012 16:11:23 +0000 (17:11 +0100)]
Fix issue on select_only mode
Darold [Sun, 28 Oct 2012 15:57:52 +0000 (16:57 +0100)]
Add report of shut down events
Darold [Sat, 27 Oct 2012 10:21:02 +0000 (12:21 +0200)]
Add debug information on command line used to pipe compressed log file when -v is provide.
Darold [Sat, 27 Oct 2012 08:32:11 +0000 (10:32 +0200)]
Move tsung authenticate request into connection transaction.
Darold Gilles [Fri, 26 Oct 2012 22:06:19 +0000 (00:06 +0200)]
Add -U | --exclude-user command line option to generate report excluded user. Thanks to Birta Levente for the feature request.
Allow some options to be specified multiple time or be written as a coma separated list of value, here are these options: --dbname, --dbuser, --dbclient, --dbappname, --exclude_user.
Darold Gilles [Fri, 26 Oct 2012 19:09:25 +0000 (21:09 +0200)]
Add -S | --select-only option to build report only on select queries. Add first support to tsung output, see usage. Thanks to Guillaume Lelarge for the feature request.
Darold Gilles [Wed, 24 Oct 2012 12:50:18 +0000 (14:50 +0200)]
Fix bug, --include-query was added to exclude_query array.
Darold Gilles [Wed, 24 Oct 2012 12:12:14 +0000 (14:12 +0200)]
Add --include-query and --include-file to specify regx of the queries that must only be included in the report. Thanks to Marc Cousin for the feature request.
Darold [Tue, 23 Oct 2012 07:38:46 +0000 (09:38 +0200)]
Fix auto detection of log_min_duration_statement format.
Darold Gilles [Fri, 19 Oct 2012 08:27:51 +0000 (10:27 +0200)]
Fix parser issue with Windows logs without timezone information. Thanks to Nicolas Thauvin for the report.
Darold Gilles [Thu, 18 Oct 2012 21:24:04 +0000 (23:24 +0200)]
Fix bug in %r = remote host and port log line prefix detection. Thanks to Hubert Depesz Lubaczewski for the report.
Darold Gilles [Thu, 18 Oct 2012 21:14:24 +0000 (23:14 +0200)]
Add -C | --nocomment option to remove comment like /* ... */ from queries. Thanks to Hubert Depesz Lubaczewski for the feature request.
Darold Gilles [Thu, 18 Oct 2012 20:50:39 +0000 (22:50 +0200)]
Fix escaping of log_line_prefix . Thanks to Hubert Depesz Lubaczewski for the patch.
Darold Gilles [Thu, 18 Oct 2012 20:47:15 +0000 (22:47 +0200)]
Fix wrong detection of update queries when a query has a object names containing update and set. Thanks to Vincent Laborie for the report.
Darold Gilles [Fri, 12 Oct 2012 17:01:28 +0000 (19:01 +0200)]
Update Changelog and release version 2.1
Darold Gilles [Fri, 12 Oct 2012 16:27:29 +0000 (18:27 +0200)]
Add new --enable-log_min_duration option to force pgbadger to use lines generated by the log_min_duration_statement even if the log_duration format is autodetected. Useful if you use both but do not log all queries. Thanks to Vincent Laborie for the feature request.
Darold Gilles [Fri, 12 Oct 2012 10:48:57 +0000 (12:48 +0200)]
Add syslog-ng format to better handle syslog traces with notation like: [ID * local2.info]. It is autodetected and can be forced in the -f option with value: syslog-ng.
Darold Gilles [Fri, 12 Oct 2012 08:42:55 +0000 (10:42 +0200)]
Add --enable-log_duration command line option to force pgbadger to only use the log_duration trace even if log_min_duration_statement traces are autodetected.
Darold Gilles [Thu, 11 Oct 2012 20:25:56 +0000 (22:25 +0200)]
Fix display of empty hourly graph when no data were found.
Darold Gilles [Thu, 11 Oct 2012 20:04:31 +0000 (22:04 +0200)]
Remove query type report when log_duration is enabled.
Darold Gilles [Thu, 11 Oct 2012 19:32:46 +0000 (21:32 +0200)]
Fix a major bug in query with bind parameter. Thanks to Marc Cousin for the report.
Darold [Wed, 10 Oct 2012 21:45:41 +0000 (23:45 +0200)]
Change version to 2.1
Darold [Wed, 10 Oct 2012 21:44:24 +0000 (23:44 +0200)]
Update changelog
Darold [Wed, 10 Oct 2012 18:00:41 +0000 (20:00 +0200)]
Fix detection of compressed log files and allow automatic detection and uncompress of .gz, .bz2 and .zip files.
Darold [Wed, 10 Oct 2012 17:00:29 +0000 (19:00 +0200)]
Add gunzip -l command to find the real size of a compressed file.
Darold [Wed, 10 Oct 2012 16:32:44 +0000 (18:32 +0200)]
Fix log_duration lonly reports to not take care about query detail but just count and duration
Darold [Wed, 10 Oct 2012 10:14:28 +0000 (12:14 +0200)]
Allow usage of log_duration and log_statement instead of log_min_duration_statement. Thanks to Philip Freeman for the report.
Darold [Sun, 7 Oct 2012 20:44:33 +0000 (22:44 +0200)]
Fix autodetect log format to handle with additional info like: [ID * local2.info] in syslog format.
Darold [Sun, 7 Oct 2012 20:40:42 +0000 (22:40 +0200)]
Fix issue on syslog format with additional info like: [ID * local2.info]. Thanks to kapsalar for the report.
Darold [Sun, 7 Oct 2012 18:36:03 +0000 (20:36 +0200)]
Add support to log_duration without queries detail report. Thanks to Vincent Laborie for the feature request.
Darold Gilles [Wed, 26 Sep 2012 20:11:15 +0000 (22:11 +0200)]
Removed unrecognized log line generated by deadlock_timeout.
Darold Gilles [Wed, 26 Sep 2012 19:25:27 +0000 (21:25 +0200)]
Fix issue with compressed csvlog. Thanks to Philip Freeman for the report.
Darold Gilles [Wed, 26 Sep 2012 19:11:05 +0000 (21:11 +0200)]
Add missing information about unsupported csv log input from stdin. It must be read from a file. Thank to Philip Freeman for the report.
Darold Gilles [Tue, 25 Sep 2012 09:03:38 +0000 (11:03 +0200)]
Fix issue #28: Illegal division by zero with log file without query and txt output. Thanks to rlowe for the report.
Darold [Sat, 15 Sep 2012 17:10:10 +0000 (19:10 +0200)]
Update documentation about the -N | --appname option
Guillaume Lelarge [Sat, 15 Sep 2012 12:04:22 +0000 (14:04 +0200)]
Rename --name to --appname
Darold Gilles [Wed, 12 Sep 2012 21:18:04 +0000 (23:18 +0200)]
Fix min/max value in xasis that was always represented 2 days by default. Thanks to Casey Allen Shobe for the report
Darold Gilles [Wed, 12 Sep 2012 17:38:49 +0000 (19:38 +0200)]
Fix major bug when running pgbadger with the -e option. Thanks to Casey Allen Shobe for the report and the great help
Darold Gilles [Wed, 12 Sep 2012 13:35:30 +0000 (15:35 +0200)]
Change project url to http://dalibo.github.com/pgbadger/
Darold Gilles [Wed, 12 Sep 2012 13:22:06 +0000 (15:22 +0200)]
Fix lot of issues in CSV parser and force locale to be C. Thanks to Casey Allen Shobe for the reports.
Darold Gilles [Tue, 11 Sep 2012 12:58:24 +0000 (14:58 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Tue, 11 Sep 2012 12:57:43 +0000 (14:57 +0200)]
Improve speed with custom log_line_prefix
Darold [Tue, 11 Sep 2012 08:20:00 +0000 (01:20 -0700)]
Merge pull request #26 from elementalvoid/helpdoc-fix
Fixed help text for --exclude-file
Matt Klich [Mon, 10 Sep 2012 17:14:35 +0000 (11:14 -0600)]
Fixed help text for --exclude-file
Old help text indicated the option name was --exclude_text which was
incorrect.
Darold [Mon, 10 Sep 2012 07:14:57 +0000 (09:14 +0200)]
Remove the obsolete --regex-user and --regex-db options that was used to specify a search pattern in the log_line_prefix to find the user and db name. This is replaced by the --prefix option
Darold [Mon, 10 Sep 2012 06:34:54 +0000 (08:34 +0200)]
Add -c|--client and -N|--name to limit report to the given client hostname and/or the application name
Darold [Sun, 9 Sep 2012 10:28:11 +0000 (12:28 +0200)]
Replace Time column report header by Hour
Darold [Sun, 9 Sep 2012 10:04:46 +0000 (12:04 +0200)]
Fix another issue in log_line_prefix parser with stderr format
Darold [Sun, 9 Sep 2012 09:24:11 +0000 (11:24 +0200)]
Add a more complex example using log_line_prefix
Darold [Sun, 9 Sep 2012 09:20:12 +0000 (11:20 +0200)]
Fix log_line_prefix issue using timepstamp with millisecond
Darold Gilles [Fri, 7 Sep 2012 22:45:04 +0000 (00:45 +0200)]
Add support to use any custom log_line_prefix with new option -p | --prefix. See README for an example.
Darold Gilles [Thu, 6 Sep 2012 13:38:12 +0000 (15:38 +0200)]
Fix false autodetection of CSV format when log_statement is enable or in possible other cases. This was resulting in error: "FATAL: cannot use CSV". Thanks to Thomas Reiss for the report.
Darold Gilles [Thu, 6 Sep 2012 13:30:13 +0000 (15:30 +0200)]
Fix display of empty graph of connections per seconds
Darold Gilles [Wed, 29 Aug 2012 07:58:50 +0000 (09:58 +0200)]
Allow character : in log line prefix, it will no more break the log parsing. Thanks to John Rouillard for the report
Darold Gilles [Wed, 29 Aug 2012 07:42:26 +0000 (09:42 +0200)]
Add report of configuration parameter changes into the errors report and change errors report by events report to handle important messages that are not errors.
Darold Gilles [Wed, 29 Aug 2012 06:59:48 +0000 (08:59 +0200)]
Allow pgbadger to recognize " autovacuum launcher" messages.
Darold Gilles [Tue, 21 Aug 2012 16:32:19 +0000 (18:32 +0200)]
Update version to 2.0
Darold Gilles [Tue, 21 Aug 2012 16:28:50 +0000 (18:28 +0200)]
Update Changelog
Darold Gilles [Tue, 21 Aug 2012 15:56:16 +0000 (17:56 +0200)]
Fix 0 size README
Darold Gilles [Tue, 21 Aug 2012 15:38:17 +0000 (17:38 +0200)]
Add documentation about -P (--no-prettify) command line option to disable the SQL format beautifier
Darold Gilles [Tue, 21 Aug 2012 15:25:52 +0000 (17:25 +0200)]
Change license from BSD like to PostgreSQL license
Darold Gilles [Tue, 21 Aug 2012 10:00:33 +0000 (12:00 +0200)]
Fix wrong pointer on Connections per host menu.
Darold [Tue, 21 Aug 2012 09:38:50 +0000 (02:38 -0700)]
Merge pull request #23 from rjuju/master
Small fix for sql formatting
Julien Rouhaud [Tue, 21 Aug 2012 09:21:56 +0000 (11:21 +0200)]
Fix sql formatting, adding scrollbars
Darold Gilles [Tue, 21 Aug 2012 08:11:06 +0000 (10:11 +0200)]
Add SQL formater on SQL queries. When you will click on a query it will be beautified
Darold Gilles [Mon, 20 Aug 2012 13:43:27 +0000 (15:43 +0200)]
Remove option -g and -p to the documentation.
Darold Gilles [Tue, 14 Aug 2012 22:16:34 +0000 (00:16 +0200)]
The progress bar is now enabled by default, the -p option has been removed. Use -q | --quiet to disable it
Darold Gilles [Tue, 14 Aug 2012 22:06:58 +0000 (00:06 +0200)]
Graphs are now generated by default for HTML output, option -g as been remove and option -G added to allow disabling graph generation. Request from Julien Rouhaud
Darold Gilles [Tue, 14 Aug 2012 14:30:49 +0000 (16:30 +0200)]
Fix case sensitivity in command line options. Patch by Julien Rouhaud
Darold Gilles [Tue, 14 Aug 2012 13:23:54 +0000 (15:23 +0200)]
Add -T|--title option to change report title. Patch by Yury Bushmelev
Darold Gilles [Mon, 13 Aug 2012 20:44:27 +0000 (22:44 +0200)]
Adding new option --exclude-file to exclude specific commands with regex stated in a file. This is a rewrite of the opened pull request 21 by neoeahit (Vipul)
Darold Gilles [Mon, 13 Aug 2012 19:51:20 +0000 (21:51 +0200)]
CSV log parser have been entirely rewritten to handle csv with multiline, it also add approximative duration for csvlog. Reported by Ludhimila Kendrick
Darold [Sat, 28 Jul 2012 18:52:25 +0000 (20:52 +0200)]
Alphabetical reordering of options list in method usage() and documentation
Darold [Sat, 28 Jul 2012 18:41:31 +0000 (20:41 +0200)]
Add -l | --last-parsed options to allow incremental run of pgbadger
Darold [Sat, 28 Jul 2012 09:43:02 +0000 (11:43 +0200)]
Remove obsolete -l | --logfile command line option, the -l option will be reused to spacify an incremental file
Darold Gilles [Thu, 26 Jul 2012 08:07:11 +0000 (10:07 +0200)]
Replace call to timelocal_nocheck by timegm_nocheck, to convert date/time into second from the epoch. This should fix timezone issue.
Darold Gilles [Tue, 24 Jul 2012 09:22:31 +0000 (11:22 +0200)]
Change regex on log parser to allow missing ending space in log_line_prefix. This seems a common mistake.
Darold [Sat, 21 Jul 2012 22:31:01 +0000 (00:31 +0200)]
print a warning when an empty log file is found
Darold [Sat, 21 Jul 2012 22:25:33 +0000 (00:25 +0200)]
Add perltidy rc file to format pgbadger Perl code - patch from depesz
Darold Gilles [Sun, 15 Jul 2012 17:07:36 +0000 (19:07 +0200)]
Change version to 1.2
Darold Gilles [Thu, 12 Jul 2012 15:09:29 +0000 (17:09 +0200)]
Add -v | --verbose to enable debug mode. It is now disable by default
Darold Gilles [Thu, 12 Jul 2012 13:45:58 +0000 (15:45 +0200)]
This new report sums the messages by log types. The report shows the number of messages of each log type, and a percentage. It also displays a graph. Patch by Guillaume Lelarge
Darold Gilles [Wed, 11 Jul 2012 21:43:06 +0000 (23:43 +0200)]
Add hourly report of checkpoint warning when checkpoints are occuring too frequently, it will display the hourly count and the average occuring time
Darold Gilles [Tue, 10 Jul 2012 16:42:41 +0000 (18:42 +0200)]
Add missing pie graph on locks by type report