]>
granicus.if.org Git - pgbadger/log
Gilles Darold [Wed, 15 Feb 2017 18:04:01 +0000 (19:04 +0100)]
Fix again last patch
Gilles Darold [Wed, 15 Feb 2017 17:56:01 +0000 (18:56 +0100)]
Fix previous commit
Gilles Darold [Wed, 15 Feb 2017 17:54:35 +0000 (18:54 +0100)]
Remove test to read log file during log format auto-detection when the file is hosted remotly. Thanks to clomdd for the report.
Darold Gilles [Fri, 10 Feb 2017 11:51:38 +0000 (12:51 +0100)]
Add autodetection of log format in remote mode to allow remote parsing of pgbouncer log file together with PostgreSQL log file.
Darold Gilles [Mon, 6 Feb 2017 13:28:25 +0000 (14:28 +0100)]
Fix number of sessions wrongly increasing after log line validation. Thanks to Achilleas Mantzios for the report.
Gilles Darold [Wed, 1 Feb 2017 22:31:02 +0000 (23:31 +0100)]
Minor reformatting of the pgBadger Description.
Darold [Wed, 1 Feb 2017 22:29:11 +0000 (23:29 +0100)]
Merge pull request #329 from cscatolini/master
Fix repeated info in README and doc.
cscatolini [Wed, 1 Feb 2017 21:57:19 +0000 (19:57 -0200)]
Fix repeated info in README and doc.
Gilles Darold [Sat, 28 Jan 2017 19:04:30 +0000 (20:04 +0100)]
Fix reports with histogram that was not showing data upper than the last range.
Gilles Darold [Sat, 28 Jan 2017 17:52:50 +0000 (18:52 +0100)]
Fix parsing of journalctl without the the log line number pattern ([%l-n]). Thanks to Christian Schmitt for the report.
Gilles Darold [Tue, 24 Jan 2017 12:33:46 +0000 (13:33 +0100)]
Update ChangeLog and version to 9.1
Gilles Darold [Tue, 24 Jan 2017 12:00:15 +0000 (13:00 +0100)]
Add new error class report to documentation.
Gilles Darold [Tue, 24 Jan 2017 11:58:22 +0000 (12:58 +0100)]
Add report of error class distribution when SQLState is available in the log line prefix. Thanks to jacks33 for the feature request.
Gilles Darold [Tue, 24 Jan 2017 08:07:10 +0000 (09:07 +0100)]
Update copyright to 2017.
Gilles Darold [Mon, 23 Jan 2017 16:06:45 +0000 (17:06 +0100)]
Fix incremental global index on resize. Thanks to clomdd for the report.
Gilles Darold [Mon, 23 Jan 2017 14:47:20 +0000 (15:47 +0100)]
Update SQL Beautifier to pgFormatter v1.6 code.
Gilles Darold [Mon, 9 Jan 2017 13:08:44 +0000 (14:08 +0100)]
Fix command tag log_line_prefix placeholder %i to allow space character.
Gilles Darold [Wed, 4 Jan 2017 17:24:47 +0000 (18:24 +0100)]
Some other error message normalization improvement.
Gilles Darold [Wed, 4 Jan 2017 16:50:26 +0000 (17:50 +0100)]
Improve error message normalization.
Gilles Darold [Wed, 4 Jan 2017 12:31:34 +0000 (13:31 +0100)]
Fix huge performance lost introduced with patch on explain plan parser.
Gilles Darold [Mon, 2 Jan 2017 22:23:41 +0000 (23:23 +0100)]
Fix --exclude-line options and removing of obsolete directory when retention is enabled and --noreport is used.
Gilles Darold [Mon, 2 Jan 2017 09:32:39 +0000 (10:32 +0100)]
Fix normalization of error message: cannot drop table ...
Darold Gilles [Fri, 30 Dec 2016 15:24:10 +0000 (16:24 +0100)]
Fix typo in previous pull request.
Darold [Fri, 30 Dec 2016 15:23:15 +0000 (16:23 +0100)]
Merge pull request #320 from ng-pe/master
Fix autovacuum report
Nicolas GOLLET [Wed, 28 Dec 2016 11:05:36 +0000 (12:05 +0100)]
fix typo in "vacuum activity table"
change "Back to the top of the Temporary Files Activity table" to "Back to the top of the Autovacuum Activity table"
Nicolas GOLLET [Wed, 28 Dec 2016 09:14:21 +0000 (10:14 +0100)]
Fix autovacuum report :
- fix autovacuum statistic (empty graph) : parsing regex add 'optional' tabulation
- fix some labels in vacuum graph caption.
Darold [Fri, 16 Dec 2016 08:54:31 +0000 (09:54 +0100)]
Merge pull request #319 from madtibo/master
logo is from Damien Cazeils (and english in comments is better)
Thibaut [Thu, 15 Dec 2016 16:42:09 +0000 (17:42 +0100)]
logo is from Damien Cazeils (and english in comments is better)
Gilles Darold [Wed, 7 Dec 2016 23:31:03 +0000 (00:31 +0100)]
Add information about pgbouncer log format in the -f option. Thanks to clomdd for the report.
Gilles Darold [Tue, 6 Dec 2016 20:18:46 +0000 (21:18 +0100)]
Add --normalized-only information in documentation.
Gilles Darold [Tue, 6 Dec 2016 20:13:44 +0000 (21:13 +0100)]
- Fix broken report of date-time introduced in previous patch.
- Add --normalized-only option to generate a text report of all
normalized queries found in a log with count.
Gilles Darold [Tue, 6 Dec 2016 18:29:54 +0000 (19:29 +0100)]
Fix duration/query association when log_duration=on and log_statement=all. Thanks to Eric Jensen for the report.
Gilles Darold [Tue, 6 Dec 2016 15:08:07 +0000 (16:08 +0100)]
Fix normalization of messages about advisory lock. Thanks to Thibaut Madelaine for the report.
Gilles Darold [Tue, 6 Dec 2016 14:34:13 +0000 (15:34 +0100)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Sat, 26 Nov 2016 10:05:24 +0000 (11:05 +0100)]
Fix report of auto_explain output. Thanks to fch77700 for the report.
Gilles Darold [Fri, 4 Nov 2016 09:05:53 +0000 (10:05 +0100)]
Fix unwanted log format autodetection with log entry from stdin. Thanks to Jesus Adolfo Parra for the report.
Darold [Thu, 27 Oct 2016 21:56:30 +0000 (23:56 +0200)]
Merge pull request #310 from dynjnelson/master
fix a spelling error and add open left paren to the stop for regex_prefix_dbclient
Jon Nelson [Thu, 27 Oct 2016 15:41:23 +0000 (10:41 -0500)]
add left open parentheses to the "stop" chars of regex_prefix_dbclient
to handle the postgresql client string format that includes source port
Jon Nelson [Thu, 27 Oct 2016 15:40:36 +0000 (10:40 -0500)]
fix speling error of Temporay -> Temporary
Gilles Darold [Thu, 20 Oct 2016 08:45:01 +0000 (10:45 +0200)]
Allow %c (session id) to replace %p (pid) as unique session id. Thanks to Jerryliuk for the report.
Gilles Darold [Wed, 19 Oct 2016 16:25:06 +0000 (18:25 +0200)]
Allow pgbadger to parse default log_line_prefix that will be used in 10.0: '%m [%p] '
Gilles Darold [Wed, 19 Oct 2016 11:29:54 +0000 (13:29 +0200)]
Fix missing first line with interpreter call.
Darold Gilles [Fri, 14 Oct 2016 13:51:25 +0000 (15:51 +0200)]
Fix missing Avg values in CSV report. Thanks to Yosuke Tomita for the report.
Darold Gilles [Wed, 12 Oct 2016 12:41:41 +0000 (14:41 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Darold Gilles [Wed, 12 Oct 2016 12:38:43 +0000 (14:38 +0200)]
Add waiting for lock messages to event reports.
Gilles Darold [Tue, 27 Sep 2016 12:16:15 +0000 (14:16 +0200)]
Fix error message in autodetect_format() method.
Darold Gilles [Wed, 21 Sep 2016 13:06:38 +0000 (15:06 +0200)]
Add --start-monday option to start calendar weeks in monday instead of default to sunday. Thanks to Joosep Mae for the feature request.
Darold Gilles [Wed, 21 Sep 2016 11:53:22 +0000 (13:53 +0200)]
Fix --histo-average option. Thanks to Yves Martin for the report.
Gilles Darold [Sat, 17 Sep 2016 08:52:39 +0000 (10:52 +0200)]
Remove plural form of --ssh-option in documentation. Thanks to mark-a-s for the report.
Darold Gilles [Mon, 12 Sep 2016 11:08:27 +0000 (13:08 +0200)]
Fix --exclude-time filter and rewrite code to skip unwanted line
as well code to update the progress bar. Thanks to Michael Chesterton
for the report.
Gilles Darold [Fri, 9 Sep 2016 10:35:00 +0000 (12:35 +0200)]
Fix support to %r placeholder in prefix instead of %h.
Gilles Darold [Fri, 2 Sep 2016 10:52:56 +0000 (12:52 +0200)]
Update ChangeLog and version to 9.0
Gilles Darold [Thu, 1 Sep 2016 08:29:59 +0000 (10:29 +0200)]
Try to detect user/database/host from connection strings if
log_connection is enabled and log_line_prefix doesn't include
them.
Extend the regex to autodetect database name, user name, client
ip address and application name. The regex now are the foolowing:
db => qr/(?:db|database)=([^,]*)/;
user => qr/(?:user|usr)=([^,]*)/;
client => qr/(?:client|remote|ip|host)=([^,]*)/;
appname => qr/(?:app|application)=([^,]*)/;
I hope this patch will limit the number of RTFM support answer.
Gilles Darold [Wed, 31 Aug 2016 21:18:11 +0000 (23:18 +0200)]
Add backward compatibility with older version of pgbadger in incremental mode
by creating a subdirectory for new CSS and Javascript files. This subdirectory
is named with the major version number of pgbadger. Any change in those files
that will break backward compatibility with old reports will increase the major
release number.
Increase the size of the pgbadger logo that appears too small with the new font
size.
Gilles Darold [Wed, 31 Aug 2016 20:54:46 +0000 (22:54 +0200)]
Normalize detailed information in all reports.
Gilles Darold [Wed, 31 Aug 2016 20:26:08 +0000 (22:26 +0200)]
Fix duplicate copy icon in locks report.
Gilles Darold [Wed, 31 Aug 2016 17:29:51 +0000 (19:29 +0200)]
Forgot to update the README with embedded truetype font change.
Gilles Darold [Wed, 31 Aug 2016 17:27:56 +0000 (19:27 +0200)]
Replace embedded fontawesome-webfont.ttf with FontAwesome.otf. Thanks to Christoph Berg for the report.
Gilles Darold [Wed, 31 Aug 2016 14:35:16 +0000 (16:35 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Gilles Darold [Wed, 31 Aug 2016 14:34:58 +0000 (16:34 +0200)]
Fix missing chart on histogram of session time. Thanks to Guillaume Lelarge for the report.
Darold [Wed, 31 Aug 2016 11:27:50 +0000 (13:27 +0200)]
Merge pull request #300 from credativ/resource-licenses
Add LICENSE file noting the licenses used by the resource files
Christoph Berg [Wed, 31 Aug 2016 11:23:46 +0000 (13:23 +0200)]
Add LICENSE file noting the licenses used by the resource files
Darold [Wed, 31 Aug 2016 10:16:40 +0000 (12:16 +0200)]
Merge pull request #299 from credativ/updt_embedded_rsc
Minor fixes to the updt_embedded_rsc mechanism
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 15:11:34 +0000 (17:11 +0200)]
Remove single last comma at end of piechart dataset. Thanks to Julien Tachoires for the report.
Gilles Darold [Tue, 30 Aug 2016 15:09:52 +0000 (17:09 +0200)]
Change display of normalized error
Gilles Darold [Tue, 30 Aug 2016 12:52:05 +0000 (14:52 +0200)]
Remove unused or autogenerated files
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.
Thanks to Christoph Berg for the feature request.
Gilles Darold [Sat, 27 Aug 2016 08:17:13 +0000 (10:17 +0200)]
Update ChangeLog and version to 8.3.
Gilles Darold [Thu, 18 Aug 2016 16:25:59 +0000 (18:25 +0200)]
Add replication command message statistics to the Events reports. Thanks to Michael Paquier for the feature request.
Gilles Darold [Thu, 18 Aug 2016 16:15:10 +0000 (18:15 +0200)]
Fix autodetection of stderr format with timestamp as epoch (%n).
Gilles Darold [Thu, 18 Aug 2016 14:18:36 +0000 (16:18 +0200)]
Fix histogram over multiples days to be cumulative per hour, not an average of the number of event per day.
Gilles Darold [Thu, 18 Aug 2016 13:46:32 +0000 (15:46 +0200)]
Fix parsing of remote file that was failing when the file does not exists locally. Thanks to clomdd for the report.
Darold [Thu, 18 Aug 2016 12:42:56 +0000 (14:42 +0200)]
Merge pull request #294 from jacksonfoz/master
Detect timezones like GMT+3 on CSV logs
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",,,,,,,,,""
Gilles Darold [Thu, 11 Aug 2016 14:51:15 +0000 (16:51 +0200)]
Update Changelog and version to 8.2
Gilles Darold [Thu, 11 Aug 2016 12:27:32 +0000 (14:27 +0200)]
Fix report of database system messages.
Gilles Darold [Wed, 10 Aug 2016 18:01:20 +0000 (20:01 +0200)]
Fix report of deadlock and error with detail+statement and pl/pgSQL statement.
Gilles Darold [Wed, 10 Aug 2016 16:44:53 +0000 (18:44 +0200)]
Fix multiline statement concatenation after an error.
Fix box size for report of queries generatin the most
temporary files and the most waiting queries.
Gilles Darold [Mon, 8 Aug 2016 20:18:40 +0000 (22:18 +0200)]
Rewrite code to better handle temporary file queries with multiline queries.
Gilles Darold [Fri, 5 Aug 2016 15:58:28 +0000 (17:58 +0200)]
Put all work on syslog and stderr orphan lines in a single method parse_orphan_line().
Gilles Darold [Fri, 5 Aug 2016 11:27:48 +0000 (13:27 +0200)]
Fix garbage in event examples queries in error only mode (-w). Thanks to Thomas Reiss for the report.
Darold [Fri, 5 Aug 2016 09:15:32 +0000 (11:15 +0200)]
Merge pull request #293 from tom--bo/auto_explain
Fix getting dataset related to query duration when using auto_explain…
tom--bo [Fri, 5 Aug 2016 08:56:50 +0000 (17:56 +0900)]
Fix getting dataset related to query duration when using auto_explain logs.
Gilles Darold [Thu, 4 Aug 2016 15:41:04 +0000 (17:41 +0200)]
Download of graph are now done through a modal dialog window.
Darold Gilles [Mon, 1 Aug 2016 09:30:32 +0000 (11:30 +0200)]
Fix compiled prefix when a log line prefix is specified, this issue is related to the last parsed mechanism rewrite.
Gilles Darold [Fri, 29 Jul 2016 22:29:29 +0000 (00:29 +0200)]
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.
Gilles Darold [Thu, 28 Jul 2016 13:57:13 +0000 (15:57 +0200)]
Revert "Fix description of -l | --last-parsed option."
This reverts commit
1463129df1ff0961249a3ea6a0645f1489033e9b .
Gilles Darold [Thu, 28 Jul 2016 13:26:00 +0000 (15:26 +0200)]
Fix description of -l | --last-parsed option.
Gilles Darold [Tue, 5 Jul 2016 15:23:19 +0000 (17:23 +0200)]
Add code to remove remaining $$PGBGYA$$ tags.
Darold Gilles [Fri, 1 Jul 2016 13:00:34 +0000 (15:00 +0200)]
Remove a debug line.
Darold Gilles [Thu, 30 Jun 2016 09:44:58 +0000 (11:44 +0200)]
Fix an other possible case of truncated date in LAST_PARSED file. Thanks to brafaeloliveira for the report.
Darold Gilles [Wed, 22 Jun 2016 10:50:08 +0000 (12:50 +0200)]
Set default scale to 1 in pretty_print_number() javascript function.
Darold Gilles [Wed, 22 Jun 2016 10:25:25 +0000 (12:25 +0200)]
Fix autodetection of PgBouncer files containing only stats lines. Thanks to Glyn Astill for the patch.
Darold Gilles [Wed, 15 Jun 2016 13:56:00 +0000 (15:56 +0200)]
Add date to samples of queries generating most temporary files.
Gilles Darold [Fri, 10 Jun 2016 16:27:56 +0000 (18:27 +0200)]
Fix other case of warning message of empty file.
Gilles Darold [Fri, 10 Jun 2016 16:24:50 +0000 (18:24 +0200)]
Merge branch 'master' of github.com:dalibo/pgbadger
Gilles Darold [Fri, 10 Jun 2016 16:24:26 +0000 (18:24 +0200)]
DOn not display warning message of empty log when quiet mode is enable.
Darold [Thu, 9 Jun 2016 20:43:53 +0000 (22:43 +0200)]
Merge pull request #282 from robertvargason/read_from_stdin_hotfix
Fix reading from stdin by disabling pgbouncer file format detection