Christoph Berg [Wed, 31 Aug 2016 10:01:28 +0000 (12:01 +0200)]
Minor fixes to the updt_embedded_rsc mechanism
Don't add a new newline before __DATA__ (and remove the newlines
accumulated so far); create resources/min/ for temporary files (and add
it to .gitignore); fix a typo.
Gilles Darold [Tue, 30 Aug 2016 17:25:51 +0000 (19:25 +0200)]
Add patch to jqplot library to fix an infinite loop when trying to download
some charts. Thanks to Julien Tachoires for the help to solve this issue.
Script tools/updt_embedded_rsc.pl will apply the patch to resource file
resources/jquery.jqplot.js and doesn't complain if it has already been
applied.
Gilles Darold [Tue, 30 Aug 2016 12:44:05 +0000 (14:44 +0200)]
Update all resources files (js+css) and create a directory to include
source of javascript libraries used in pgbadger. There is also a new
script tools/updt_embedded_rsc.pl the can be used to generate the
minified version of those files and embedded them into pgbadger.
This script will also embedded the fontawesome-webfont.ttf truetype
font into the fontawesome.css file. At this point it still need some
works especialy for backward compatibility with old version of the
badger.
jacksonfoz [Thu, 18 Aug 2016 12:31:27 +0000 (09:31 -0300)]
Detect timezones like GMT+3 on CSV logs
During the execution of pgbadger lines like this are not autodetected as csv:
2016-08-18 08:31:00.365 GMT+3,"user_project","devdb",16576,"172.17.43.32:59633",57b59c74.40c0,2,"",2016-08-18 08:31:00 GMT+3,,0,FATAL,57P03,"the database system is shutting down",,,,,,,,,""
Huge rewrite of the incremental mechanism applied to log files to handle PostgreSQL and pgbouncer logs at the same time. Multiprocess can now be used with pgbouncer log.
Darold Gilles [Tue, 22 Mar 2016 14:16:52 +0000 (15:16 +0100)]
Fix wrong report of statements responsible of temporary files. Thanks to Luan Nicolini Marcondes for the report. This patch also exclude lien with log level LOCATION to be parsed.
Darold Gilles [Wed, 24 Feb 2016 15:23:50 +0000 (16:23 +0100)]
Fix a major issue introduced with support to pgbouncer that prevent parsing of compressed PostgreSQL log files. Thanks to Levente Birta for the report.
Darold Gilles [Fri, 15 Jan 2016 23:14:43 +0000 (00:14 +0100)]
Add --timezone=+/-HH to control the timezone used in charts. The javascript library runs at client side so the timezone used is the browser timezone so the displayed time in the charts can be different from the time in the log file. Thanks to CZAirwolf for the report.
Darold Gilles [Fri, 15 Jan 2016 13:01:40 +0000 (14:01 +0100)]
Revert "Fix wrong size/offset of log files with unicode characters that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem."
Darold Gilles [Fri, 15 Jan 2016 12:46:33 +0000 (13:46 +0100)]
Fix wrong size/offset of log files with unicode characters that was breaking incremental mode. Thanks a lot to CZAirwolf for the report and the help to find the problem.
Darold Gilles [Thu, 14 Jan 2016 21:17:33 +0000 (22:17 +0100)]
Add command line option --pid-dir to be able to run two pgbadger at the same time
by setting an alternate path to the directory where the pid file will be written.
Darold Gilles [Thu, 14 Jan 2016 14:12:52 +0000 (15:12 +0100)]
Report information about "LOG: sending cancel to blocking autovacuum" into events reports. Usefull to know which queries generate autovacuum kill do to a lock issue.
Darold Gilles [Thu, 3 Dec 2015 11:57:15 +0000 (12:57 +0100)]
Fix to handle cancelled query that generate more than one temporary file and more generaly aggregate size on queries with multiple > 1GB temporary files.
Darold Gilles [Thu, 26 Nov 2015 15:54:46 +0000 (16:54 +0100)]
Add support to journalctl command output and add --journalctl_cmd command line option to enable this functionnality and set the command. Typically: --journalctl_cmd "journalctl -u postgresql-9.4"