]>
granicus.if.org Git - pgbadger/log
Darold Gilles [Mon, 28 Apr 2014 20:20:38 +0000 (22:20 +0200)]
Fix increment of session when --disable-session is activated.
Darold Gilles [Mon, 28 Apr 2014 19:41:30 +0000 (21:41 +0200)]
Fix missing unit in Checkpoints Activity report when time value is empty. Thanks to Herve Werner for the report.
Darold Gilles [Mon, 28 Apr 2014 19:35:29 +0000 (21:35 +0200)]
Fix double information in histogram data when period is the hour.
Darold Gilles [Mon, 28 Apr 2014 18:29:39 +0000 (20:29 +0200)]
Add support to named PREPARE and EXECUTE queries. Calls to EXECUTE statements are now replaced by the prepared query and show samples with parameters. Thanks to Brian DeRocher for the feature request.
Darold [Mon, 28 Apr 2014 12:29:10 +0000 (14:29 +0200)]
Merge pull request #154 from brunomgalmeida/master
Included Remote and Client information into the most-frequent-errors-eve...
brunomgalmeida [Mon, 28 Apr 2014 11:43:33 +0000 (12:43 +0100)]
Included Remote and Client information into the most-frequent-errors-events-examples
Darold [Fri, 25 Apr 2014 09:52:20 +0000 (11:52 +0200)]
Merge pull request #153 from schmiddy/doc_fixes
Copyediting of the documentation. Attempting to fix various awkward
Josh Kupershmidt [Thu, 24 Apr 2014 01:00:42 +0000 (21:00 -0400)]
Copyediting of the documentation. Attempting to fix various awkward
phrasings, grammar, and spelling. Consistently capitalize "pgBadger"
as such, except for command examples which should stay all-lowercase.
Darold Gilles [Tue, 15 Apr 2014 14:59:24 +0000 (16:59 +0200)]
Fix incremental mode under Windows by replacing %F and %u POSIX::strftime format to %Y-%m-%d and %w. Thanks to dthiery for the report.
Darold Gilles [Tue, 15 Apr 2014 12:00:39 +0000 (14:00 +0200)]
Remove Examples button when there is no examples available.
Darold Gilles [Tue, 15 Apr 2014 11:28:49 +0000 (13:28 +0200)]
Fix label on tips in histogram of errors reports.
Darold Gilles [Tue, 15 Apr 2014 09:29:25 +0000 (11:29 +0200)]
Fix error details in incremental mode in Most Frequent Errors/Events report. Thanks to Herve Werner for the report.
Darold Gilles [Mon, 14 Apr 2014 17:55:58 +0000 (19:55 +0200)]
Fix Sync time value in Checkpoints buffers report. Thanks to Herve Werner for the report.
Darold Gilles [Mon, 14 Apr 2014 17:23:23 +0000 (19:23 +0200)]
Fix wrong connections per host count. Thanks to Herve Werner for the report.
Darold Gilles [Sun, 13 Apr 2014 16:06:44 +0000 (18:06 +0200)]
Allow pgbadger to parse remote log file using a passwordless ssh connection.
Darold Gilles [Sat, 12 Apr 2014 09:07:45 +0000 (11:07 +0200)]
Histogram granularity can be adjusted using the -A command line option. By default they will report the mean of each top queries/error occuring per hour, but you can specify the granularity down to the minute.
Darold Gilles [Thu, 10 Apr 2014 21:34:40 +0000 (23:34 +0200)]
Add new detail information on top queries to show when the query is a bind query.
Darold Gilles [Thu, 10 Apr 2014 19:21:55 +0000 (21:21 +0200)]
Fix queries that exceed the size of the container.
Darold Gilles [Thu, 10 Apr 2014 16:56:27 +0000 (18:56 +0200)]
Add unit (seconds) to checkpoint write/sync time in the checkpoints activity report.
Darold Gilles [Thu, 10 Apr 2014 11:24:18 +0000 (13:24 +0200)]
Fix missing -J option in usage.
Darold Gilles [Thu, 10 Apr 2014 08:42:02 +0000 (10:42 +0200)]
Simplify and fix the patch on incomplete lines in split_logfile. Thanks to brunomgalmeida for the patch.
Darold Gilles [Mon, 7 Apr 2014 17:39:02 +0000 (19:39 +0200)]
Fix incomplete lines in split_logfile to rewind to the begining of the line. Thanks to brunomgalmeida for the patch.
Darold Gilles [Sat, 5 Apr 2014 08:23:58 +0000 (10:23 +0200)]
Fix pull request 147 to completely remove error example part when --sample is set to 0.
Darold [Sat, 5 Apr 2014 08:10:50 +0000 (10:10 +0200)]
Merge pull request #147 from wmorancfi/master
Make --sample 0 work
Darold Gilles [Sat, 5 Apr 2014 07:55:12 +0000 (09:55 +0200)]
Add tsung xml header sample to output file.
wmorancfi [Fri, 4 Apr 2014 19:39:52 +0000 (15:39 -0400)]
Update pgbadger
Make it possible to do --sample 0 (prior it was falling back to the default of 3)
Darold Gilles [Tue, 1 Apr 2014 21:12:59 +0000 (23:12 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Tue, 1 Apr 2014 21:12:50 +0000 (23:12 +0200)]
Fix tsung output
Darold Gilles [Mon, 31 Mar 2014 19:47:03 +0000 (21:47 +0200)]
Fix xz command to be script readable and always have size in bytes: xz --robot -l %f | grep totals | awk "{print $5}"
Darold [Mon, 31 Mar 2014 19:26:04 +0000 (21:26 +0200)]
Merge pull request #145 from luisuribe/master
Adding missing curly brace
Luis Uribe [Mon, 31 Mar 2014 19:19:12 +0000 (14:19 -0500)]
Adding missing curly brace
Darold [Mon, 31 Mar 2014 12:37:36 +0000 (14:37 +0200)]
Merge pull request #144 from anayrat/patch-1
xz support
anayrat [Mon, 31 Mar 2014 12:18:43 +0000 (14:18 +0200)]
xz support
Darold Gilles [Thu, 27 Mar 2014 08:59:29 +0000 (09:59 +0100)]
Do not increment queries duration histogram when prepare|parse|bind log are found, but only with execute log. Thanks to Josh Berkus for the report.
Darold Gilles [Tue, 25 Mar 2014 15:11:57 +0000 (16:11 +0100)]
Fix normalization of error message about unique violation when creating intermediate dirs. Thanks to Tim Sampson for the report.
Darold Gilles [Wed, 12 Mar 2014 11:30:56 +0000 (12:30 +0100)]
Allow use of Perl metacharacters like [..] in application name. Thanks to Magnus Persson for the report.
Darold Gilles [Mon, 10 Mar 2014 20:06:49 +0000 (21:06 +0100)]
Fix dataset tip to be displayed above image control button. Thanks to Ronan Dunklau for the fix.
Darold Gilles [Mon, 10 Mar 2014 16:49:27 +0000 (17:49 +0100)]
Renamed the Reset bouton to "To Chart" to avoid confusion with unzoom feature.
Darold Gilles [Mon, 10 Mar 2014 16:39:41 +0000 (17:39 +0100)]
Fix writing of empty incremental last parsed file.
Darold Gilles [Mon, 10 Mar 2014 16:33:59 +0000 (17:33 +0100)]
Fix several other graphs
Darold Gilles [Mon, 10 Mar 2014 15:46:37 +0000 (16:46 +0100)]
Fix additional message at end of query or error when it was logged from application output. Thanks to Herve Werner for the report.
Darold Gilles [Mon, 10 Mar 2014 15:31:55 +0000 (16:31 +0100)]
Fix checkpoint and vacuum graphs when all dataset does not have all values. Thanks to Herve Werner for the report.
Darold Gilles [Mon, 10 Mar 2014 10:05:59 +0000 (11:05 +0100)]
Fix week numbered -1 in calendar view.
Darold Gilles [Fri, 7 Mar 2014 12:09:09 +0000 (13:09 +0100)]
Change week/day menu in incremental index, it is now represented as usual with a calendar view per month. Thanks to Thom Brown for the feature request.
Darold Gilles [Thu, 6 Mar 2014 22:10:40 +0000 (23:10 +0100)]
Load FileHandle to fix error: Can not locate object method "seek" via package "IO::Handle" with perl 5.8. Thanks to hkrizek for the report.
Darold Gilles [Sat, 1 Mar 2014 15:35:04 +0000 (16:35 +0100)]
Fix count of queries in progress bar when there is compressed file and multiprocess is enabled. Thanks to Johnny Tan for the report.
Darold Gilles [Thu, 27 Feb 2014 09:02:44 +0000 (10:02 +0100)]
Fix debug message "Start parsing at offset"
Darold Gilles [Mon, 17 Feb 2014 11:22:17 +0000 (12:22 +0100)]
Add ordering in queries times histogram. Thanks to Ulf Renman for the report.
Darold [Mon, 10 Feb 2014 16:14:58 +0000 (17:14 +0100)]
Merge pull request #133 from darkixion/master
Fix various typos.
Thom Brown [Mon, 10 Feb 2014 14:43:50 +0000 (14:43 +0000)]
Fix various typos.
Darold Gilles [Sat, 8 Feb 2014 08:46:20 +0000 (09:46 +0100)]
Fix Makefile error, "WriteMakefile: Need even number of args at Makefile.PL" with perl 5.8. Thanks to Fangr Zhang for the report.
Darold Gilles [Thu, 6 Feb 2014 16:46:08 +0000 (17:46 +0100)]
Fix some typo in changelog
Darold Gilles [Thu, 6 Feb 2014 13:55:19 +0000 (14:55 +0100)]
Update ChangeLog and version to v5.0
Darold Gilles [Thu, 6 Feb 2014 12:25:56 +0000 (13:25 +0100)]
Keep long SQL queries in the width of the parent container.
Darold Gilles [Tue, 4 Feb 2014 11:30:25 +0000 (12:30 +0100)]
Add new histogram reports on top queries and top errors/event. It shows at what hours and in which quantity the queries or errors appears.
Darold Gilles [Thu, 30 Jan 2014 22:16:36 +0000 (23:16 +0100)]
Add seeking to last parser position in log file in incremental mode. This prevent parsing all the file to find the last line parse from previous run. This only works when parsing a single flat file, -j option is permitted. Thanks to ioguix for the kick.
Darold Gilles [Thu, 30 Jan 2014 16:52:29 +0000 (17:52 +0100)]
Rewrite reloading of last log time from binary files.
Darold Gilles [Thu, 30 Jan 2014 16:24:04 +0000 (17:24 +0100)]
Fix issue with week number in incremental mode that was producing empty reports.
Darold Gilles [Thu, 30 Jan 2014 15:35:38 +0000 (16:35 +0100)]
Fix missing statistics of last parsed queries in incremental mode.
Darold Gilles [Thu, 30 Jan 2014 10:33:49 +0000 (11:33 +0100)]
Fix bug in incremental mode that prevent reindexing a previous day. Thanks to Martin Prochazka for the great help.
Darold Gilles [Mon, 27 Jan 2014 18:12:41 +0000 (19:12 +0100)]
Fix missing "Avg duration" column header in details of Most frequent queries (N).
Darold Gilles [Mon, 27 Jan 2014 17:52:23 +0000 (18:52 +0100)]
Add one more range on query times histogram (0-1ms).
Darold Gilles [Mon, 27 Jan 2014 17:42:23 +0000 (18:42 +0100)]
Add vertical crosshair on graph.
Darold Gilles [Mon, 27 Jan 2014 15:46:35 +0000 (16:46 +0100)]
Fix case where queries and events was not updated when using -b and -e command line. Thanks to Nicolas Thauvin for the report.
Darold Gilles [Thu, 23 Jan 2014 08:08:10 +0000 (09:08 +0100)]
Fix week sorting on incremental report main index page. Thanks to Martin Prochazka for the report.
Darold Gilles [Wed, 22 Jan 2014 16:29:22 +0000 (17:29 +0100)]
Added more range to the histogram of query times, but should be dynamic.
Darold Gilles [Wed, 22 Jan 2014 15:37:28 +0000 (16:37 +0100)]
Add "Histogram of query times" report to show statistics like 0-100ms : 80%, 100-500ms :14%, 500-1000ms : 3%, 1000-10000s : 2%, > 10000ms : 1%. Thanks to tmihail for the feature request.
Darold Gilles [Tue, 21 Jan 2014 13:57:58 +0000 (14:57 +0100)]
Format mouse tracker on graphs to show all dataset value at a time.
Darold Gilles [Mon, 20 Jan 2014 17:13:37 +0000 (18:13 +0100)]
Add control of -o vs -O option with incremental mode.
Darold Gilles [Mon, 20 Jan 2014 08:34:53 +0000 (09:34 +0100)]
Add more information about the incremental mode in documentation.
Darold Gilles [Thu, 16 Jan 2014 09:23:33 +0000 (10:23 +0100)]
Change log level of missing LAST_PARSED.tmp file to WARNING and add a HINT.
Darold Gilles [Sat, 11 Jan 2014 18:06:40 +0000 (19:06 +0100)]
Update copyright date to 2014
Darold Gilles [Mon, 6 Jan 2014 21:00:35 +0000 (22:00 +0100)]
Fix search of week days using a week number and a year.
Darold Gilles [Mon, 6 Jan 2014 09:40:28 +0000 (10:40 +0100)]
Fix empty reports of connections. Thanks to Reeshna Ramakrishnan for the rreport.
Darold Gilles [Mon, 6 Jan 2014 09:08:56 +0000 (10:08 +0100)]
Fix display of connections peak when no connection was reported.
Darold Gilles [Mon, 6 Jan 2014 08:55:22 +0000 (09:55 +0100)]
Remove the <del> tag for non existant daily reports.
Darold Gilles [Mon, 6 Jan 2014 08:48:55 +0000 (09:48 +0100)]
Fix warning on META_MERGE for ExtUtils::MakeMaker < 6.46. Thanks to Julien Rouhaud for the patch.
Darold Gilles [Mon, 6 Jan 2014 08:45:19 +0000 (09:45 +0100)]
Add documentation about automatic incremental mode.
Darold Gilles [Sun, 29 Dec 2013 17:54:14 +0000 (18:54 +0100)]
Remove debug information.
Darold Gilles [Sun, 29 Dec 2013 17:52:46 +0000 (18:52 +0100)]
Add incremental mode to pgBadger. This mode will build a report per day and a cumulative report per week. It also create an index interface to easiest access to the different report. Must be run, for example, as: pgbadger /var/log/postgresql.log.1 -I -O /var/www/pgbadger/ after a daily PostgreSQL log file rotation.
Darold Gilles [Thu, 26 Dec 2013 09:39:15 +0000 (10:39 +0100)]
Add -O | --outdir path to specify the directory where out file must be saved.
Darold Gilles [Mon, 23 Dec 2013 15:08:54 +0000 (16:08 +0100)]
Automatic queries formatting is now done on double click event, simple click was painful when you want to copy some part of the queries. Thanks to Guillaume Smet for the feature request.
Darold Gilles [Sat, 21 Dec 2013 12:18:28 +0000 (13:18 +0100)]
Remove calls of binmode to force html file output to be utf8 as there is some bad side effect. Thanks to akorotkov for the report.
Darold Gilles [Fri, 13 Dec 2013 11:01:16 +0000 (12:01 +0100)]
Remove use of Time::HiRes, some distributions does not include this module.
Darold Gilles [Sat, 7 Dec 2013 08:52:43 +0000 (09:52 +0100)]
Fix "Wide character in print" Perl message by setting binmode to :utf8. Thanks to Casey Allen Shobe for the report.
Darold Gilles [Wed, 4 Dec 2013 13:19:28 +0000 (14:19 +0100)]
Fix application name search regex to handle application name with space like "pgAdmin III - Query Tool".
Darold Gilles [Tue, 3 Dec 2013 20:35:49 +0000 (21:35 +0100)]
Fix wrong use of qw// without parenthesis, introduce in previous commit.
Darold Gilles [Sun, 1 Dec 2013 22:47:21 +0000 (23:47 +0100)]
Fix wrong timestamps saved with top queries. Thanks to Herve Werner for the report.
Darold Gilles [Sun, 1 Dec 2013 22:32:52 +0000 (23:32 +0100)]
Fix missing logs types statitics when using binary mode. Thanks to Herve Werner for the report.
Darold Gilles [Fri, 29 Nov 2013 08:54:10 +0000 (09:54 +0100)]
Fix Queries by application table column header: Database replaced by Application. Thanks to Herve Werner for the report.
Darold Gilles [Thu, 28 Nov 2013 07:51:44 +0000 (08:51 +0100)]
Add "Max number of times the same event was reported" report in Global stats Events tab.
Darold Gilles [Thu, 28 Nov 2013 07:46:07 +0000 (08:46 +0100)]
Fix "Unrecognized character \xC2;" introduce in previous commit.
Darold Gilles [Thu, 28 Nov 2013 07:43:41 +0000 (08:43 +0100)]
Replace "Number of errors" by "Number of ERROR entries" and add "Number of FATAL entries".
Darold Gilles [Thu, 28 Nov 2013 07:39:13 +0000 (08:39 +0100)]
Replace "Number of errors" by "Number of events" and "Total errors found" by "Total events found" in Events reports. Thanks to Herve Werner for the report.
Darold Gilles [Thu, 28 Nov 2013 07:33:52 +0000 (08:33 +0100)]
Fix title error in Sessions per database.
Darold Gilles [Wed, 27 Nov 2013 12:03:19 +0000 (13:03 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Mon, 25 Nov 2013 16:06:59 +0000 (17:06 +0100)]
Fix clicking on the info link to not go back to the top of the page. Thanks to Guillaume Smet for the report and solution.
Darold Gilles [Mon, 25 Nov 2013 13:36:45 +0000 (14:36 +0100)]
Fix incremental report from binary output where binary data was not loaded if no queries were present in log file. Thanks to Herve Werner for the report.
Darold Gilles [Tue, 19 Nov 2013 14:52:37 +0000 (15:52 +0100)]
Fix parsing issue when log_error_verbosity = verbose. Thanks to vorko for the report.
Darold Gilles [Tue, 19 Nov 2013 14:32:28 +0000 (15:32 +0100)]
Add Session peak information and a report about Simultaneous sessions. log_connections and log_disconnections must be enabled.