]> granicus.if.org Git - pgbadger/log
pgbadger
12 years agoUpdate version to 2.2
Darold Gilles [Wed, 14 Nov 2012 09:20:52 +0000 (10:20 +0100)]
Update version to 2.2

12 years agoUpdate Changelog and release version 2.2
Darold Gilles [Tue, 13 Nov 2012 20:38:48 +0000 (21:38 +0100)]
Update Changelog and release version 2.2

12 years agoAdd two more Pg keywords and run perltidy.
Darold Gilles [Tue, 13 Nov 2012 20:16:16 +0000 (21:16 +0100)]
Add two more Pg keywords and run perltidy.

12 years agoFix number of queries in progress bar with tsung output.
Darold Gilles [Tue, 13 Nov 2012 11:08:32 +0000 (12:08 +0100)]
Fix number of queries in progress bar with tsung output.

12 years agoRemove obsolete syslog-ng and temporary syslog-ll log format added to fix some syslog...
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.

12 years agoAdd comment about the check_incremental_position() method
Darold Gilles [Mon, 12 Nov 2012 18:33:07 +0000 (19:33 +0100)]
Add comment about the check_incremental_position() method

12 years agoFix bad report with empty graphs when log files was not in chronological order.
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.

12 years agoAdd report of the current total of queries and events parsed in progress bar. Thanks...
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.

12 years agoFix parser on syslog with level info after the timestamp like <local0.info>. Thanks...
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.

12 years agoFix parser on syslog with level info after the timestamp like <local0.info>. Thanks...
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.

12 years agoMerge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Wed, 7 Nov 2012 01:10:14 +0000 (02:10 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger

12 years agoMerge pull request #39 from davidfetter/master
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

12 years agos/Text::CSV/$&_XS/g
David Fetter [Tue, 6 Nov 2012 22:19:29 +0000 (14:19 -0800)]
s/Text::CSV/$&_XS/g

12 years agoMerge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Mon, 5 Nov 2012 08:41:02 +0000 (09:41 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger

12 years agoRemove the use of dynamic variables on parsing some command line arguments.
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.

12 years agoFix several issue with tsung output.
Darold [Sun, 28 Oct 2012 16:51:29 +0000 (17:51 +0100)]
Fix several issue with tsung output.

12 years agoFix issue on select_only mode
Darold [Sun, 28 Oct 2012 16:11:23 +0000 (17:11 +0100)]
Fix issue on select_only mode

12 years agoAdd report of shut down events
Darold [Sun, 28 Oct 2012 15:57:52 +0000 (16:57 +0100)]
Add report of shut down events

12 years agoAdd debug information on command line used to pipe compressed log file when -v is...
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.

12 years agoMove tsung authenticate request into connection transaction.
Darold [Sat, 27 Oct 2012 08:32:11 +0000 (10:32 +0200)]
Move tsung authenticate request into connection transaction.

12 years agoAdd -U | --exclude-user command line option to generate report excluded user. Thanks...
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.

12 years agoAdd -S | --select-only option to build report only on select queries. Add first suppo...
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.

12 years agoFix bug, --include-query was added to exclude_query array.
Darold Gilles [Wed, 24 Oct 2012 12:50:18 +0000 (14:50 +0200)]
Fix bug, --include-query was added to exclude_query array.

12 years agoAdd --include-query and --include-file to specify regx of the queries that must only...
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.

12 years agoFix auto detection of log_min_duration_statement format.
Darold [Tue, 23 Oct 2012 07:38:46 +0000 (09:38 +0200)]
Fix auto detection of log_min_duration_statement format.

12 years agoFix parser issue with Windows logs without timezone information. Thanks to Nicolas...
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.

12 years agoFix bug in %r = remote host and port log line prefix detection. Thanks to Hubert...
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.

12 years agoAdd -C | --nocomment option to remove comment like /* ... */ from queries. Thanks...
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.

12 years agoFix escaping of log_line_prefix . Thanks to Hubert Depesz Lubaczewski for the patch.
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.

12 years agoFix wrong detection of update queries when a query has a object names containing...
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.

12 years agoUpdate Changelog and release version 2.1
Darold Gilles [Fri, 12 Oct 2012 17:01:28 +0000 (19:01 +0200)]
Update Changelog and release version 2.1

12 years agoAdd new --enable-log_min_duration option to force pgbadger to use lines generated...
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.

12 years agoAdd syslog-ng format to better handle syslog traces with notation like: [ID * local2...
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.

12 years agoAdd --enable-log_duration command line option to force pgbadger to only use the log_d...
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.

12 years agoFix display of empty hourly graph when no data were found.
Darold Gilles [Thu, 11 Oct 2012 20:25:56 +0000 (22:25 +0200)]
Fix display of empty hourly graph when no data were found.

12 years agoRemove query type report when log_duration is enabled.
Darold Gilles [Thu, 11 Oct 2012 20:04:31 +0000 (22:04 +0200)]
Remove query type report when log_duration is enabled.

12 years agoFix a major bug in query with bind parameter. Thanks to Marc Cousin for the report.
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.

12 years agoChange version to 2.1
Darold [Wed, 10 Oct 2012 21:45:41 +0000 (23:45 +0200)]
Change version to 2.1

12 years agoUpdate changelog
Darold [Wed, 10 Oct 2012 21:44:24 +0000 (23:44 +0200)]
Update changelog

12 years agoFix detection of compressed log files and allow automatic detection and uncompress...
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.

12 years agoAdd gunzip -l command to find the real size of a compressed file.
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.

12 years agoFix log_duration lonly reports to not take care about query detail but just count...
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

12 years agoAllow usage of log_duration and log_statement instead of log_min_duration_statement...
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.

12 years agoFix autodetect log format to handle with additional info like: [ID * local2.info...
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.

12 years agoFix issue on syslog format with additional info like: [ID * local2.info]. Thanks...
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.

12 years agoAdd support to log_duration without queries detail report. Thanks to Vincent Laborie...
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.

12 years agoRemoved unrecognized log line generated by deadlock_timeout.
Darold Gilles [Wed, 26 Sep 2012 20:11:15 +0000 (22:11 +0200)]
Removed unrecognized log line generated by deadlock_timeout.

12 years agoFix issue with compressed csvlog. Thanks to Philip Freeman for the report.
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.

12 years agoAdd missing information about unsupported csv log input from stdin. It must be read...
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.

12 years agoFix issue #28: Illegal division by zero with log file without query and txt output...
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.

12 years agoUpdate documentation about the -N | --appname option
Darold [Sat, 15 Sep 2012 17:10:10 +0000 (19:10 +0200)]
Update documentation about the -N | --appname option

12 years agoRename --name to --appname
Guillaume Lelarge [Sat, 15 Sep 2012 12:04:22 +0000 (14:04 +0200)]
Rename --name to --appname

12 years agoFix min/max value in xasis that was always represented 2 days by default. Thanks...
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

12 years agoFix major bug when running pgbadger with the -e option. Thanks to Casey Allen Shobe...
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

12 years agoChange project url to http://dalibo.github.com/pgbadger/
Darold Gilles [Wed, 12 Sep 2012 13:35:30 +0000 (15:35 +0200)]
Change project url to http://dalibo.github.com/pgbadger/

12 years agoFix lot of issues in CSV parser and force locale to be C. Thanks to Casey Allen Shobe...
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.

12 years agoMerge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Tue, 11 Sep 2012 12:58:24 +0000 (14:58 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger

12 years agoImprove speed with custom log_line_prefix
Darold Gilles [Tue, 11 Sep 2012 12:57:43 +0000 (14:57 +0200)]
Improve speed with custom log_line_prefix

12 years agoMerge pull request #26 from elementalvoid/helpdoc-fix
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

12 years agoFixed 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.

12 years agoRemove the obsolete --regex-user and --regex-db options that was used to specify...
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

12 years agoAdd -c|--client and -N|--name to limit report to the given client hostname and/or...
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

12 years agoReplace Time column report header by Hour
Darold [Sun, 9 Sep 2012 10:28:11 +0000 (12:28 +0200)]
Replace Time column report header by Hour

12 years agoFix another issue in log_line_prefix parser with stderr format
Darold [Sun, 9 Sep 2012 10:04:46 +0000 (12:04 +0200)]
Fix another issue in log_line_prefix parser with stderr format

12 years agoAdd a more complex example using log_line_prefix
Darold [Sun, 9 Sep 2012 09:24:11 +0000 (11:24 +0200)]
Add a more complex example using log_line_prefix

12 years agoFix log_line_prefix issue using timepstamp with millisecond
Darold [Sun, 9 Sep 2012 09:20:12 +0000 (11:20 +0200)]
Fix log_line_prefix issue using timepstamp with millisecond

12 years agoAdd support to use any custom log_line_prefix with new option -p | --prefix. See...
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.

12 years agoFix false autodetection of CSV format when log_statement is enable or in possible...
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.

12 years agoFix display of empty graph of connections per seconds
Darold Gilles [Thu, 6 Sep 2012 13:30:13 +0000 (15:30 +0200)]
Fix display of empty graph of connections per seconds

12 years agoAllow character : in log line prefix, it will no more break the log parsing. Thanks...
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

12 years agoAdd report of configuration parameter changes into the errors report and change error...
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.

12 years agoAllow pgbadger to recognize " autovacuum launcher" messages.
Darold Gilles [Wed, 29 Aug 2012 06:59:48 +0000 (08:59 +0200)]
Allow pgbadger to recognize " autovacuum launcher" messages.

12 years agoUpdate version to 2.0
Darold Gilles [Tue, 21 Aug 2012 16:32:19 +0000 (18:32 +0200)]
Update version to 2.0

12 years agoUpdate Changelog
Darold Gilles [Tue, 21 Aug 2012 16:28:50 +0000 (18:28 +0200)]
Update Changelog

12 years agoFix 0 size README
Darold Gilles [Tue, 21 Aug 2012 15:56:16 +0000 (17:56 +0200)]
Fix 0 size README

12 years agoAdd documentation about -P (--no-prettify) command line option to disable the SQL...
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

12 years agoChange license from BSD like to PostgreSQL license
Darold Gilles [Tue, 21 Aug 2012 15:25:52 +0000 (17:25 +0200)]
Change license from BSD like to PostgreSQL license

12 years agoFix wrong pointer on Connections per host menu.
Darold Gilles [Tue, 21 Aug 2012 10:00:33 +0000 (12:00 +0200)]
Fix wrong pointer on Connections per host menu.

12 years agoMerge pull request #23 from rjuju/master
Darold [Tue, 21 Aug 2012 09:38:50 +0000 (02:38 -0700)]
Merge pull request #23 from rjuju/master

Small fix for sql formatting

12 years agoFix sql formatting, adding scrollbars
Julien Rouhaud [Tue, 21 Aug 2012 09:21:56 +0000 (11:21 +0200)]
Fix sql formatting, adding scrollbars

12 years agoAdd SQL formater on SQL queries. When you will click on a query it will be beautified
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

12 years agoRemove option -g and -p to the documentation.
Darold Gilles [Mon, 20 Aug 2012 13:43:27 +0000 (15:43 +0200)]
Remove option -g and -p to the documentation.

12 years agoThe progress bar is now enabled by default, the -p option has been removed. Use ...
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

12 years agoGraphs are now generated by default for HTML output, option -g as been remove and...
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

12 years agoFix case sensitivity in command line options. Patch by 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

12 years agoAdd -T|--title option to change report title. Patch by Yury Bushmelev
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

12 years agoAdding new option --exclude-file to exclude specific commands with regex stated in...
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)

12 years agoCSV log parser have been entirely rewritten to handle csv with multiline, it also...
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

12 years agoAlphabetical reordering of options list in method usage() and documentation
Darold [Sat, 28 Jul 2012 18:52:25 +0000 (20:52 +0200)]
Alphabetical reordering of options list in method usage() and documentation

12 years agoAdd -l | --last-parsed options to allow incremental run of pgbadger
Darold [Sat, 28 Jul 2012 18:41:31 +0000 (20:41 +0200)]
Add -l | --last-parsed options to allow incremental run of pgbadger

12 years agoRemove obsolete -l | --logfile command line option, the -l option will be reused...
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

12 years agoReplace call to timelocal_nocheck by timegm_nocheck, to convert date/time into second...
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.

12 years agoChange regex on log parser to allow missing ending space in log_line_prefix. This...
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.

12 years agoprint a warning when an empty log file is found
Darold [Sat, 21 Jul 2012 22:31:01 +0000 (00:31 +0200)]
print a warning when an empty log file is found

12 years agoAdd perltidy rc file to format pgbadger Perl code - patch from depesz
Darold [Sat, 21 Jul 2012 22:25:33 +0000 (00:25 +0200)]
Add perltidy rc file to format pgbadger Perl code - patch from depesz

12 years agoChange version to 1.2
Darold Gilles [Sun, 15 Jul 2012 17:07:36 +0000 (19:07 +0200)]
Change version to 1.2

12 years agoAdd -v | --verbose to enable debug mode. It is now disable by default
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

12 years agoThis new report sums the messages by log types. The report shows the number of messag...
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

12 years agoAdd hourly report of checkpoint warning when checkpoints are occuring too frequently...
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

12 years agoAdd missing pie graph on locks by type report
Darold Gilles [Tue, 10 Jul 2012 16:42:41 +0000 (18:42 +0200)]
Add missing pie graph on locks by type report