]>
granicus.if.org Git - pgbadger/log
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.
Darold Gilles [Mon, 18 Nov 2013 22:04:35 +0000 (23:04 +0100)]
Fix wrong requests number in Queries by user and by host. Thanks to Jehan-Guillaume de Rorthais for the report.
Darold Gilles [Fri, 15 Nov 2013 14:52:01 +0000 (15:52 +0100)]
Fix issue with rsyslog format failing to parse logs. Thanks to Tim Sampson for the report.
Darold Gilles [Thu, 14 Nov 2013 18:31:49 +0000 (19:31 +0100)]
Associate autovacuum and autoanalyze log entry to the corresponding database name. Thanks to Herve Werner for the feature request.
Darold Gilles [Wed, 13 Nov 2013 17:22:19 +0000 (18:22 +0100)]
Change "Simultaneous Connections" label into "Established Connections", it is less confusing as many people think that this is the number of simultaneous sessions, which is not the case. It only count the number of connections established at same time. Thanks to Ronan Dunklau for the report.
Darold Gilles [Fri, 8 Nov 2013 08:15:18 +0000 (09:15 +0100)]
fix a typo in ChangeLog
Darold Gilles [Fri, 8 Nov 2013 07:33:49 +0000 (08:33 +0100)]
Update to version 4.1
Darold Gilles [Thu, 7 Nov 2013 22:16:40 +0000 (23:16 +0100)]
Add log_autovacuum_min_duration into documentation in chapter about postgresql configuration directives. Thanks to Hervé Werner for the report.
Darold Gilles [Thu, 7 Nov 2013 14:56:20 +0000 (15:56 +0100)]
Add chapter about "Incremental reports" into documentation.
Darold Gilles [Thu, 7 Nov 2013 13:14:13 +0000 (14:14 +0100)]
Fix reports with per minutes average where last time fraction was not reported. Thanks to Ludovic Levesque and Vincent Laborie for the report.
Ronan Dunklau [Thu, 7 Nov 2013 10:05:37 +0000 (11:05 +0100)]
Fix unterminated comment.
Darold Gilles [Mon, 4 Nov 2013 22:39:59 +0000 (23:39 +0100)]
Add --exclude-appname commande line option to eliminate unwanted traffic generated by a specific application. Thanks to Steve Crawford for the feature request.
Darold Gilles [Mon, 4 Nov 2013 21:59:33 +0000 (22:59 +0100)]
Allow external links use into URL to go to a specific report. Thanks to Hubert depesz Lubaczewski for the feature request.
Darold Gilles [Mon, 4 Nov 2013 20:12:32 +0000 (21:12 +0100)]
Fix empty reports when parsing compressed files with the -j option which is not allowed with compressed file. Thanks to Vincent Laborie for the report.
Darold Gilles [Mon, 4 Nov 2013 18:09:04 +0000 (19:09 +0100)]
Prevent progress bar length to increase after 100% when real size is greater than estimated size (compressed file only).
Darold [Fri, 1 Nov 2013 13:05:02 +0000 (06:05 -0700)]
Merge pull request #117 from darkixion/master
Correct some spelling and grammar in ChangeLog and pgbadger.
Thom Brown [Thu, 31 Oct 2013 22:11:24 +0000 (22:11 +0000)]
Correct some spelling and grammar in ChangeLog and pgbadger.
Darold Gilles [Thu, 31 Oct 2013 18:53:20 +0000 (19:53 +0100)]
Fix major bug on SQL traffic reports with wrong min value and bad average value on select reports, add min/max for select queries. Thanks to Vincent Laborie for the report.
Darold Gilles [Thu, 31 Oct 2013 07:57:17 +0000 (08:57 +0100)]
Major update to pgBadger v4.0
Darold Gilles [Mon, 28 Oct 2013 15:27:36 +0000 (16:27 +0100)]
Fix missing queries using temp files and locks with CSV log files. Thanks to avandras for the report.
Darold Gilles [Fri, 11 Oct 2013 13:23:26 +0000 (15:23 +0200)]
Fix --end bug, was set to same date as --begin. Thanks to Andrzej Zawadzki for the report.
Darold Gilles [Tue, 17 Sep 2013 08:36:59 +0000 (10:36 +0200)]
Update ChangeLog and verson to 3.6.
Darold Gilles [Sat, 7 Sep 2013 14:55:15 +0000 (16:55 +0200)]
Fix grammar in --quiet usage. Thanks to stephen-a-ingramfor the report.
Darold Gilles [Tue, 3 Sep 2013 13:08:26 +0000 (15:08 +0200)]
Fix reporting period to starts after the last --last-parsed value instead of the first log line. Thanks to Keith Fiske for the report.
Darold Gilles [Fri, 2 Aug 2013 15:35:21 +0000 (17:35 +0200)]
Add --csv-separator command line usage to documaentation.
Darold Gilles [Fri, 2 Aug 2013 15:33:24 +0000 (17:33 +0200)]
Fix CSV log parser and add --csv-separator command line option to allow change of the default csv field separator, coma, in any other character.
Darold [Wed, 31 Jul 2013 10:15:48 +0000 (03:15 -0700)]
Merge pull request #101 from segv/master
Avoid "negative look behind not implemented" errors on perl 5.16/5.18
Marco Baringer [Tue, 30 Jul 2013 14:39:53 +0000 (16:39 +0200)]
Support timestamps for begin/end with fractional seconds (so it'll handle postgresql's normal string representation of timestamps).
NB: This parses, but does not propertly handle, time zones.
Marco Baringer [Tue, 30 Jul 2013 14:38:50 +0000 (16:38 +0200)]
When using negative look behind set the sub-regexp to -i (not case insensitive) to avoid issues where some upper case letter sequence, like SS or ST, happens to correspond to a single char as lowercase and hits perls inability to match variable length regexps via negative look behind.
Marco Baringer [Tue, 30 Jul 2013 14:31:29 +0000 (16:31 +0200)]
Change shebang from /usr/bin/perl to /usr/bin/env perl so that user-local (perlbrew) perls will get used.
Darold Gilles [Thu, 18 Jul 2013 17:27:28 +0000 (19:27 +0200)]
Fix empty graph of autovacuum and autoanalyze.
Darold Gilles [Thu, 18 Jul 2013 17:08:49 +0000 (19:08 +0200)]
Fix checkpoint graphs that was not displayed any more.
Darold Gilles [Thu, 11 Jul 2013 15:24:39 +0000 (17:24 +0200)]
Update ChangLog and version to 3.5
Darold Gilles [Thu, 11 Jul 2013 14:03:10 +0000 (16:03 +0200)]
Split temporary files report into two graphs (files size and number of file) to no more used a second Y axis with flotr2 - mouse tracker was not working as expected.
Darold Gilles [Thu, 11 Jul 2013 13:47:06 +0000 (15:47 +0200)]
Duration series representing the second yaxis in graph have been removed and are now draw in a new "Average queries duration" graph. pretty_print_number() have also been modified to handle seconds and microseconds.
gilles [Thu, 11 Jul 2013 09:52:41 +0000 (11:52 +0200)]
Change pretty print size to display IEC units and use toFixed() instead of round.
Darold Gilles [Mon, 8 Jul 2013 08:09:33 +0000 (10:09 +0200)]
Add mouse crosshair above graphs and pretty print of yaxis values.
Darold Gilles [Fri, 5 Jul 2013 16:39:45 +0000 (18:39 +0200)]
Remove Query type reports when log contains only duration.
Darold Gilles [Fri, 5 Jul 2013 16:02:43 +0000 (18:02 +0200)]
Fix display of checkpoint hourly report with no entry.
Darold Gilles [Fri, 5 Jul 2013 14:54:17 +0000 (16:54 +0200)]
Fix count in Query type report.
Darold Gilles [Fri, 5 Jul 2013 14:07:32 +0000 (16:07 +0200)]
Fix an other issue with multiline queries
Darold Gilles [Wed, 3 Jul 2013 13:07:47 +0000 (15:07 +0200)]
Fix minimal statistics output when nothing was load from log file. Thanks to Herve Werner for the report.
Darold Gilles [Fri, 28 Jun 2013 19:30:43 +0000 (21:30 +0200)]
Fix several bug in log line parser. Thanks to Den Untevskiy for the report.
Darold Gilles [Wed, 26 Jun 2013 22:11:33 +0000 (00:11 +0200)]
Fix bug in last parsed storage when log files was not provided in the right order. Thanks to Herve Werner for the report.
Darold Gilles [Wed, 26 Jun 2013 14:47:50 +0000 (16:47 +0200)]
Fix orphan lines wrongly associated to previous queries instead of temporary file and lock logged statement. Thanks to Den Untevskiy for the report.
Darold Gilles [Wed, 26 Jun 2013 13:54:39 +0000 (15:54 +0200)]
Fix number of different samples shown in events report.
Darold Gilles [Wed, 26 Jun 2013 13:13:51 +0000 (15:13 +0200)]
Fix HTML escaping on all pending cases. Thanks to Mael Rimbault for the report.
Darold Gilles [Mon, 24 Jun 2013 21:04:49 +0000 (23:04 +0200)]
Escape HTML tags on error messages examples. Thanks to Mael Rimbault for the report.
Darold Gilles [Mon, 24 Jun 2013 18:06:12 +0000 (20:06 +0200)]
Remove some temporary debug informations used with some LOG messages reported as events.
Darold Gilles [Mon, 24 Jun 2013 18:04:44 +0000 (20:04 +0200)]
Fix several issues with restartpoint and temporary files reports. Thanks to Guillaume Lelarge for the report.
Darold Gilles [Thu, 20 Jun 2013 21:35:10 +0000 (23:35 +0200)]
Fix issue when an absolute path was given to the incremental file. Thanks to Herve Werner for the report.
Darold Gilles [Thu, 20 Jun 2013 17:24:33 +0000 (19:24 +0200)]
Remove creation of incremental temporary file $tmp_last_parsed when we are not in multiprocess mode. Thanks to Herve Werner for the report.
Darold Gilles [Tue, 18 Jun 2013 20:58:18 +0000 (22:58 +0200)]
fix typo in changelog
Darold Gilles [Tue, 18 Jun 2013 20:49:37 +0000 (22:49 +0200)]
Update ChangeLog and version to 3.4.
Darold Gilles [Tue, 18 Jun 2013 20:48:54 +0000 (22:48 +0200)]
Fix condition to display autoanalyze graph.
Darold Gilles [Tue, 18 Jun 2013 20:48:07 +0000 (22:48 +0200)]
Update documentation
Darold Gilles [Tue, 18 Jun 2013 20:14:12 +0000 (22:14 +0200)]
Update flotr2.min.js to latest github code and add mouse tracking over y2axix.
Darold Gilles [Tue, 18 Jun 2013 19:37:44 +0000 (21:37 +0200)]
Add label/legend information to ticks displayed on mouseover graphs.
Darold Gilles [Tue, 18 Jun 2013 17:31:06 +0000 (19:31 +0200)]
Fix documentation about log_statment and log_min_duration_statement. Thanks to Herve Werner for the report.
Darold Gilles [Tue, 18 Jun 2013 13:02:42 +0000 (15:02 +0200)]
Fix missing top queries for locks and temporary files in multiprocess mode.
Darold Gilles [Tue, 18 Jun 2013 09:11:21 +0000 (11:11 +0200)]
Clear main hash where per minutes information are stored.
Darold Gilles [Mon, 17 Jun 2013 15:40:36 +0000 (17:40 +0200)]
Remove storage of unused information about connection.
Darold Gilles [Mon, 17 Jun 2013 12:10:14 +0000 (14:10 +0200)]
Divide the huge dump_as_html() method with one method per each report. Checkpoint and temporary file have now a period of 5 minutes per defaut instead of one hour.
Darold Gilles [Wed, 12 Jun 2013 12:53:10 +0000 (14:53 +0200)]
Change fixed increment of 1 hour to 5 minutes on graphs "SELECT queries", "Write queries". Remove graph "All queries" as with a five minutes increment it would duplicate the "Queries per second". Thanks to Josh Berkus for the feature request.
Darold [Fri, 24 May 2013 06:45:17 +0000 (23:45 -0700)]
Merge pull request #95 from stasic/master
fixed a typo
Arsen Stasic [Thu, 23 May 2013 21:27:28 +0000 (23:27 +0200)]
typo
Darold Gilles [Wed, 15 May 2013 15:22:40 +0000 (17:22 +0200)]
Add default HTML charset to utf-8 and a command line option --charset to change default. Thanks to thomashankeuhh for the feature request.
Darold Gilles [Tue, 14 May 2013 21:54:17 +0000 (23:54 +0200)]
Fix missing temporary files query reports in some conditions. Thanks to Guillaume Lelarge and Thomas Reiss for the report.
Darold Gilles [Mon, 13 May 2013 09:54:31 +0000 (11:54 +0200)]
Fix some parsing issue with log generated by pg 7.4
Darold Gilles [Wed, 1 May 2013 15:53:29 +0000 (17:53 +0200)]
Update documentation about new reports.
Darold Gilles [Wed, 1 May 2013 15:41:59 +0000 (17:41 +0200)]
Update ChangeLog and version to 3.3
Darold Gilles [Wed, 1 May 2013 14:27:51 +0000 (16:27 +0200)]
Remove parallel processing under Windows platform as the use of waitpid is freezing pgbadger. Thanks to Saurabh Agrawal for the report.
Darold Gilles [Tue, 30 Apr 2013 13:23:34 +0000 (15:23 +0200)]
Fix Error in tempfile() under Windows. Thanks to Saurabh Agrawal for the report.
Darold Gilles [Mon, 29 Apr 2013 12:28:07 +0000 (14:28 +0200)]
Fix wrong queries storage with lock and temporary file reports. Thanks to Thomas Reiss for the report.
Darold Gilles [Sat, 27 Apr 2013 09:58:40 +0000 (11:58 +0200)]
Fix text reports about temporary files.
Darold Gilles [Sat, 27 Apr 2013 09:20:09 +0000 (11:20 +0200)]
Add text output for the four new report.
Darold Gilles [Sat, 27 Apr 2013 09:18:35 +0000 (11:18 +0200)]
Add samples queries to Most frequent waiting queries report.
Darold Gilles [Fri, 26 Apr 2013 18:47:44 +0000 (20:47 +0200)]
Add two more reports about locks: Most frequent waiting queries (N), Queries that waited the most. Add two other reports about temporary files: Queries generating the most temporary files (N) and Queries generating the largest temporary files. Thanks to Thomas Reiss for the patch.
Darold Gilles [Wed, 17 Apr 2013 18:52:35 +0000 (20:52 +0200)]
Cosmetic change to the Min/Max/Avg duration column in Slowest queries (N) report.
Darold Gilles [Wed, 17 Apr 2013 18:44:20 +0000 (20:44 +0200)]
Fix report of samples error in csvlog format. Thanks to tpoindessous for the report.
Darold Gilles [Wed, 17 Apr 2013 15:14:03 +0000 (17:14 +0200)]
Add --disable-autovacuum to the documentation. Thanks to tpoindessous for the report.
Darold Gilles [Fri, 12 Apr 2013 14:51:12 +0000 (16:51 +0200)]
Fix unmatched ) in regex when using %s in prefix.
Darold Gilles [Fri, 12 Apr 2013 10:23:35 +0000 (12:23 +0200)]
Fix bad average size of temporary file in Overall statistics report. Thanks to Jehan Guillaume de Rorthais for the report.
Darold [Wed, 10 Apr 2013 17:07:35 +0000 (10:07 -0700)]
Merge pull request #88 from gleu/restartpoint
Add restartpoint reporting
Guillaume Lelarge [Wed, 10 Apr 2013 16:32:23 +0000 (18:32 +0200)]
Add restartpoint reporting
Table and graph...
Darold Gilles [Wed, 10 Apr 2013 16:25:37 +0000 (18:25 +0200)]
Made some minor change in CSS.
Darold Gilles [Tue, 9 Apr 2013 16:54:06 +0000 (18:54 +0200)]
Replace %% in log line prefix internally by a single %. Thanks to Cal Heldenbrand for the report.
Darold Gilles [Tue, 9 Apr 2013 08:42:48 +0000 (10:42 +0200)]
Fix perl documentation header, thanks to Cyril Bouthors for the patch.
Darold Gilles [Sun, 7 Apr 2013 18:17:59 +0000 (20:17 +0200)]
Update Changelog and version to 3.2
Darold Gilles [Thu, 4 Apr 2013 12:16:28 +0000 (14:16 +0200)]
In multiprocess mode, fix case where pgbadger does not update the last-parsed file and do not take care of the previous run. Thanks to Kong Man for the report.