]>
granicus.if.org Git - pgbadger/log
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.
Darold Gilles [Wed, 3 Apr 2013 21:53:22 +0000 (23:53 +0200)]
Fix case where pgbadger does not update the last-parsed file. Thanks to Kong Man for the report.
Darold Gilles [Wed, 3 Apr 2013 21:30:39 +0000 (23:30 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold [Sun, 24 Mar 2013 08:49:40 +0000 (01:49 -0700)]
Merge pull request #81 from eulerto/cdata
Add CDATA to make validator happy.
Darold [Sat, 23 Mar 2013 08:25:04 +0000 (01:25 -0700)]
Merge pull request #80 from eulerto/master
Trivial fixes
Euler Taveira de Oliveira [Sat, 23 Mar 2013 04:10:31 +0000 (01:10 -0300)]
Add CDATA to make validator happy.
It is a good practice to use CDATA section for inline javascript when
using XHTML.
Euler Taveira de Oliveira [Sat, 23 Mar 2013 03:02:37 +0000 (00:02 -0300)]
Forgot to replace PgBadger in a few places.
Euler Taveira de Oliveira [Sat, 23 Mar 2013 02:57:58 +0000 (23:57 -0300)]
Name is pgBadger.
The software is named pgBadger. Fix some places that call it PgBadger (p
is lowercase).
Euler Taveira de Oliveira [Sat, 23 Mar 2013 02:55:20 +0000 (23:55 -0300)]
Unbreak id attribute.
Id attribute is unique. Each time an id is used in an element it must
have a different value.
Euler Taveira de Oliveira [Sat, 23 Mar 2013 02:54:49 +0000 (23:54 -0300)]
Fix copy'n'pasto.
Euler Taveira de Oliveira [Sat, 23 Mar 2013 02:51:50 +0000 (23:51 -0300)]
Replace 'Av.' with 'Avg'.
The latter is more widely known than the former.
Darold Gilles [Thu, 21 Mar 2013 22:45:02 +0000 (23:45 +0100)]
Fix case where stat were multiplied by N when -J was set to N. Thanks to thegnorf for the report.
Darold Gilles [Thu, 21 Mar 2013 08:34:40 +0000 (09:34 +0100)]
Add a line about log_statement set to all in documentation.
Darold [Wed, 13 Mar 2013 13:39:40 +0000 (06:39 -0700)]
Merge pull request #75 from daamien/master
Quick note on how to Conrtibute
damien clochard [Wed, 13 Mar 2013 13:34:37 +0000 (14:34 +0100)]
Change the title
damien clochard [Wed, 13 Mar 2013 13:31:59 +0000 (14:31 +0100)]
Note on how to contribute
wq
Darold Gilles [Mon, 11 Mar 2013 11:24:35 +0000 (12:24 +0100)]
Fix issue with logs read from stdin. Thanks to hubert depesz lubaczewski for the report.
Darold Gilles [Thu, 7 Mar 2013 22:12:46 +0000 (23:12 +0100)]
Force pgbadger to not try to beautify queries bigger than 10kb, this will take too much time. This value can be reduce in the future if hang with long queries still happen. Thanks to John Rouillard for the report.
Darold Gilles [Sun, 3 Mar 2013 20:45:38 +0000 (21:45 +0100)]
Apply previous patch to syslog format.
Darold Gilles [Sun, 3 Mar 2013 15:49:16 +0000 (16:49 +0100)]
Fix an other issue in replacing bind param when the bind value is alone on a single line. Thanks to Kjeld Peters for the report.
Darold Gilles [Sun, 3 Mar 2013 11:15:54 +0000 (12:15 +0100)]
Fix parsing of compressed files together with uncompressed files using the the -j option. Uncompressed files are now processed using split method and compressed ones are parsed per one dedicated process.
Darold Gilles [Sun, 3 Mar 2013 09:51:58 +0000 (10:51 +0100)]
Add missing zcat command control in previous patch.
Darold Gilles [Sun, 3 Mar 2013 09:45:51 +0000 (10:45 +0100)]
Replace zcat by gunzip -c to fix an issue on MacOsx. Thanks to Kjeld Peters for the report.
Darold Gilles [Sun, 3 Mar 2013 09:28:02 +0000 (10:28 +0100)]
Escape HTML code inside queries. Thanks to denstark for the report.
Darold Gilles [Sat, 2 Mar 2013 18:20:21 +0000 (19:20 +0100)]
Add Min/Max in addition to Average duration values in queries reports. Thanks to John Rouillard fot the feature request.
Darold Gilles [Sat, 2 Mar 2013 17:23:58 +0000 (18:23 +0100)]
Fix top slowest array size with binary format.
Darold Gilles [Sat, 2 Mar 2013 15:42:12 +0000 (16:42 +0100)]
Fix an other case with bind parameters with value in next line and the top N slowest queries that was repeated until N even if the real number of queries was lower. Thanks to Kjeld Peters for the reports.
Darold Gilles [Sat, 2 Mar 2013 10:28:34 +0000 (11:28 +0100)]
Fix non replacement of bind parameters where there is line breaks in the parameters, aka multiline bind parameters. Thanks to Kjeld Peters for the report.
Darold Gilles [Sat, 2 Mar 2013 09:27:33 +0000 (10:27 +0100)]
Fix error with seekable export tag with Perl v5.8. Thanks to Jeff Bohmer for the report.
Darold Gilles [Thu, 28 Feb 2013 21:42:27 +0000 (22:42 +0100)]
Fix parsing of syslog lines begining with a timestamp like "2013-02-28T10:35:11-05:00". Thanks to Ryan P. Kelly for the report.
Darold Gilles [Wed, 27 Feb 2013 17:31:42 +0000 (18:31 +0100)]
Fix issue #65 where using -c | --dbclient with csvlog was broken. Thanks to Jaime Casanova for the report.
Darold Gilles [Fri, 22 Feb 2013 00:16:11 +0000 (01:16 +0100)]
Update ChangeLog with last commit for release 3.1.
Darold Gilles [Fri, 22 Feb 2013 00:14:43 +0000 (01:14 +0100)]
Fix empty report in watchlog mode (-w option).
Darold Gilles [Thu, 21 Feb 2013 23:36:07 +0000 (00:36 +0100)]
Update ChangeLog and version to 3.1
Darold Gilles [Thu, 21 Feb 2013 23:26:40 +0000 (00:26 +0100)]
Fix dies on command line options error.
Darold Gilles [Thu, 21 Feb 2013 23:21:35 +0000 (00:21 +0100)]
Fix missing report of most frequent events/errors report. Thanks to Vincent Laborie for the report.
Darold Gilles [Thu, 21 Feb 2013 22:55:16 +0000 (23:55 +0100)]
Fix missing report of slowest normalized queries.
Darold Gilles [Thu, 21 Feb 2013 22:41:20 +0000 (23:41 +0100)]
Fix display of last print of progress bar when quiet mode is enabled.
Darold Gilles [Wed, 20 Feb 2013 20:51:52 +0000 (21:51 +0100)]
Update Changelog for v3.0
Darold Gilles [Wed, 20 Feb 2013 20:40:38 +0000 (21:40 +0100)]
Add more details about parallel parsing.