]> granicus.if.org Git - pgbadger/log
pgbadger
6 years agoMerge pull request #438 from SteveNewson/osx_sed_support
Gilles Darold [Tue, 11 Sep 2018 15:03:36 +0000 (17:03 +0200)]
Merge pull request #438 from SteveNewson/osx_sed_support

Fixes SED use for OSX builds

6 years agoFixes SED use for OSX builds
Steve Newson [Tue, 11 Sep 2018 14:50:06 +0000 (15:50 +0100)]
Fixes SED use for OSX builds

6 years agoFix illegal division by zero in incrental mode. Thanks to aleszeleny for the report.
Gilles Darold [Mon, 10 Sep 2018 12:59:36 +0000 (14:59 +0200)]
Fix illegal division by zero in incrental mode. Thanks to aleszeleny for the report.

6 years agoUpdate ChangeLog with last change for v10.0 v10.0
Gilles Darold [Sun, 9 Sep 2018 17:18:14 +0000 (19:18 +0200)]
Update ChangeLog with last change for v10.0

6 years agoReplace SQL::Beautify with v3.0 of pgFormatter::Beautify
Gilles Darold [Sun, 9 Sep 2018 16:52:19 +0000 (18:52 +0200)]
Replace SQL::Beautify with v3.0 of pgFormatter::Beautify

6 years agoFix checkpoint distance and estimate not reported in incremental mode.
Gilles Darold [Sun, 9 Sep 2018 14:56:49 +0000 (16:56 +0200)]
Fix checkpoint distance and estimate not reported in incremental mode.
Thanks to aleszeleny for the report.

6 years agoUpdate Changelog and version to 10.0
Gilles Darold [Sun, 9 Sep 2018 13:10:21 +0000 (15:10 +0200)]
Update Changelog and version to 10.0

6 years agoFix title of pgbouncer simultaneous session report. Thansks yo Jehan Guillaume De...
Gilles Darold [Sun, 2 Sep 2018 15:41:46 +0000 (17:41 +0200)]
Fix title of pgbouncer simultaneous session report. Thansks yo Jehan Guillaume De Rorthais for the report.

6 years agoAdd support of pgbouncer syslog log file format. Thanks to djester for the feature...
Gilles Darold [Sat, 1 Sep 2018 19:28:19 +0000 (21:28 +0200)]
Add support of pgbouncer syslog log file format. Thanks to djester for the feature request.

6 years agoFix error when a remote log is empty. Thanks to Parasit Hendersson for the report.
Gilles Darold [Sat, 1 Sep 2018 12:33:13 +0000 (14:33 +0200)]
Fix error when a remote log is empty. Thanks to Parasit Hendersson for the report.

6 years agoAdd support to all auto_explain format (text, xml, json and yaml).
Gilles Darold [Sat, 1 Sep 2018 11:27:26 +0000 (13:27 +0200)]
Add support to all auto_explain format (text, xml, json and yaml).

6 years agoFix test with binary format. Binary file must be generated as it is dependent of...
Gilles Darold [Sat, 1 Sep 2018 08:39:00 +0000 (10:39 +0200)]
Fix test with binary format. Binary file must be generated as it is dependent of the plateform. Thanks to Michal Nowak for the report.

6 years agoFix case where an empty explain plan is generated.
Gilles Darold [Thu, 30 Aug 2018 23:20:24 +0000 (01:20 +0200)]
Fix case where an empty explain plan is generated.

6 years agoFix parsing of autodetected default format with a prefix in command line.
Gilles Darold [Thu, 30 Aug 2018 21:40:29 +0000 (23:40 +0200)]
Fix parsing of autodetected default format with a prefix in command line.

6 years agoRemove dependency of git command.
Gilles Darold [Thu, 30 Aug 2018 09:43:27 +0000 (11:43 +0200)]
Remove dependency of git command.

6 years agoUpdate documentation about options changes and remove of the [%l-1] part of the manda...
Gilles Darold [Thu, 30 Aug 2018 09:40:10 +0000 (11:40 +0200)]
Update documentation about options changes and remove of the [%l-1] part of the mandatory prefix.

6 years agoList of changes in this commit:
Gilles Darold [Thu, 30 Aug 2018 09:11:13 +0000 (11:11 +0200)]
List of changes in this commit:

  - Fix parsing of vacuum / analyze system usage for PostgreSQL 10.
    Thanks to Achilleas Mantzios for the patch.
  - Fix Temporary File Activity table.
  - Remove dependency to git during install.
  - Add support to auto_explain json output format. Thanks to dmius
    for the report.
  - Fix auto_explain parser and queries that was counted twice.
    Thanks to zam6ak for the report.
  - Add support to %q placeholder in log_line_prefix.
  - Fix checkpoint regex to match PostgreSQL 10 log messages. Thanks
    to Edmund Horner for the patch.
  - Update description of -f | --format option by adding information
    about jsonlog format.
  - Fix wrong long name for option -J that should be --Jobs intead
    of --job_per_file. Thanks to Chad Trabant for the report.
  - Add jsonlog input format. Some users are using the jsonlog format
    of Michael Paquier extension, with -f jsonlog pgbadger will be
    able to parse the log.
  - Fix query normalisation to not duplicate with bind queries.
    Normalisation of values are now tranformed into a single ? and no
    more 0 for numbers, two single quote for string. Thanks to vadv
    for the report.
  - Fix log level count. Thanks to Jean-Christophe Arnu for the report.
  - Make pgbadger more compliant with B::Lint bare sub name.
  - Made perlcritic happy.
  - Add --prettify-json command line option to prettify JSON output.
    Default output is all in single line.
  - Fix Events distribution report.
  - Fix bug with --prefix when log_line_prefix contain multiple %%.
    Thanks to svb007 for the report.
  - Add --log-timezone  +/-XX  command line option to set the number
    of hours from GMT of the timezone that must be used to adjust
    date/time read from log file before beeing parsed. Using this
    option make more difficult log search with a date/time because the
    time will not be the same in the log. Note that you might still
    need to adjust the graph timezone using -Z when the client has not
    the same timezone. Thanks to xdexter for the feature request.
  - Apply timezone to bar chart in pgBouncer reports.
  - Apply timezone to bar chart in Top queries reports.
  - Apply timezone to bar chart in Most frequent errors/events report.
  - Remove INDEXES from the keyword list and add BUFFERS to this list.
  - Fix normalization of query using cursors.

6 years agoRemove Dockerfile and documentation about docker run. pgBadger comes as
Gilles Darold [Tue, 28 Aug 2018 20:44:26 +0000 (22:44 +0200)]
Remove Dockerfile and documentation about docker run. pgBadger comes as
a single Perl script without any dependence and it can be used on any
plateform. It is a non sens to use docker to run pgbadger, if you don't
want to install anything, just copy the file pgbadger where you want and
execute it.

6 years agoThe badger is back to home, modify all links to new URLs
Gilles Darold [Tue, 28 Aug 2018 14:51:00 +0000 (16:51 +0200)]
The badger is back to home, modify all links to new URLs
   - Web site: http://pgbadger.darold.net
   - Source code: https://github.com/darold/pgbadger
Change copyright year and name.

6 years agoThe badger is back to home, modify all links to new URLs
Gilles Darold [Tue, 28 Aug 2018 14:46:58 +0000 (16:46 +0200)]
The badger is back to home, modify all links to new URLs
  - Web site: http://pgbadger.darold.net
  - Source code: https://github.com/darold/pgbadger
Change copyright year and name.

6 years agoMerge pull request #423 from pgiraud/tfa_grid
Gilles Darold [Mon, 25 Jun 2018 21:12:40 +0000 (23:12 +0200)]
Merge pull request #423 from pgiraud/tfa_grid

Fix broken grid when no temp files activity

6 years agoFix broken grid when no temp files activity
Pierre GIRAUD [Thu, 21 Jun 2018 14:24:57 +0000 (16:24 +0200)]
Fix broken grid when no temp files activity

Fixes #422

6 years agoMerge pull request #419 from julmon/fix_374_bis
Gilles Darold [Wed, 13 Jun 2018 14:05:22 +0000 (16:05 +0200)]
Merge pull request #419 from julmon/fix_374_bis

Add doc warning about log_MDS vs log_D + log_S

6 years agoAdd doc warning about log_MDS vs log_D + log_S
Julien Tachoires [Wed, 13 Jun 2018 13:32:02 +0000 (15:32 +0200)]
Add doc warning about log_MDS vs log_D + log_S

6 years agoMerge pull request #416 from julmon/fix_375
Gilles Darold [Tue, 12 Jun 2018 16:35:52 +0000 (18:35 +0200)]
Merge pull request #416 from julmon/fix_375

g modifier usage when unescaping log_line_prefix

6 years agog modifier usage when unescaping log_line_prefix
Julien Tachoires [Tue, 12 Jun 2018 16:15:01 +0000 (18:15 +0200)]
g modifier usage when unescaping log_line_prefix

6 years agoMerge pull request #414 from julmon/fix_352
Gilles Darold [Tue, 12 Jun 2018 12:00:49 +0000 (14:00 +0200)]
Merge pull request #414 from julmon/fix_352

Apply timezone offset to bar charts

6 years agoMerge pull request #415 from julmon/fix_358
Gilles Darold [Tue, 12 Jun 2018 12:00:26 +0000 (14:00 +0200)]
Merge pull request #415 from julmon/fix_358

Delete current temp file info if we meet an error for the same PID

6 years agoDelete current temp file info if we meet an error for the same PID
Julien Tachoires [Tue, 12 Jun 2018 07:46:23 +0000 (09:46 +0200)]
Delete current temp file info if we meet an error for the same PID

6 years agoApply timezone offset to bar charts
Julien Tachoires [Sat, 9 Jun 2018 14:16:01 +0000 (16:16 +0200)]
Apply timezone offset to bar charts

6 years agoMerge pull request #399 from julmon/tz_global
Julien Tachoires [Thu, 7 Jun 2018 09:54:21 +0000 (11:54 +0200)]
Merge pull request #399 from julmon/tz_global

Apply timezone offset at parsing time

6 years agoUpdate README
Julien Tachoires [Mon, 19 Mar 2018 08:03:40 +0000 (09:03 +0100)]
Update README

6 years agoUpdate pod file
Julien Tachoires [Mon, 19 Mar 2018 08:01:40 +0000 (09:01 +0100)]
Update pod file

6 years agoApply timezone offset at parsing time
Julien Tachoires [Sun, 18 Mar 2018 08:24:00 +0000 (09:24 +0100)]
Apply timezone offset at parsing time

6 years agoMerge pull request #393 from credativ/appname
Étienne BERSAC [Wed, 25 Apr 2018 13:09:59 +0000 (15:09 +0200)]
Merge pull request #393 from credativ/appname

Consistently use app= in examples, and support appname=

6 years agoMerge pull request #396 from ejrh/checkpoint_complete_fix
Étienne BERSAC [Wed, 14 Mar 2018 09:41:56 +0000 (10:41 +0100)]
Merge pull request #396 from ejrh/checkpoint_complete_fix

Fix checkpoint regex to match PostgreSQL 10 log messages.

6 years agoFix checkpoint regex to match PostgreSQL 10 log messages.
ejrh [Wed, 14 Mar 2018 05:47:03 +0000 (18:47 +1300)]
Fix checkpoint regex to match PostgreSQL 10 log messages.

PostgreSQL 10 renamed 'transaction log' to 'WAL'.

6 years agoMerge pull request #395 from bersace/automatedbuild
Étienne BERSAC [Tue, 13 Mar 2018 18:37:45 +0000 (19:37 +0100)]
Merge pull request #395 from bersace/automatedbuild

Docker: automated build & updates

6 years agopod: Clean whitespaces
Étienne BERSAC [Tue, 13 Mar 2018 14:47:18 +0000 (15:47 +0100)]
pod: Clean whitespaces

6 years agodocker: Add openssh-client
Étienne BERSAC [Tue, 13 Mar 2018 14:46:24 +0000 (15:46 +0100)]
docker: Add openssh-client

6 years agodocker: Add zcat and bunzip2
Étienne BERSAC [Tue, 13 Mar 2018 14:44:13 +0000 (15:44 +0100)]
docker: Add zcat and bunzip2

6 years agoUpdate documentation to use automated build
Étienne BERSAC [Tue, 13 Mar 2018 14:37:14 +0000 (15:37 +0100)]
Update documentation to use automated build

6 years agoMerge pull request #394 from bdronneau/feat_docker
Étienne BERSAC [Tue, 13 Mar 2018 14:27:09 +0000 (15:27 +0100)]
Merge pull request #394 from bdronneau/feat_docker

Add Dockerfile

6 years agodocs: complete with a more concrete usage
bdronneau [Tue, 13 Mar 2018 12:23:22 +0000 (13:23 +0100)]
docs: complete with a more concrete usage

6 years agodocs(docker): add usage of docker image
bdronneau [Tue, 13 Mar 2018 10:02:11 +0000 (11:02 +0100)]
docs(docker): add usage of docker image

6 years agofeat(docker): init dockerfile
bdronneau [Tue, 13 Mar 2018 09:57:09 +0000 (10:57 +0100)]
feat(docker): init dockerfile

6 years agoConsistently use app= in examples, and support appname=
Christoph Berg [Tue, 27 Feb 2018 09:03:47 +0000 (10:03 +0100)]
Consistently use app= in examples, and support appname=

Some of the usage examples used appname= in the prefix, but the code
didn't recognize that token. Use app= in all examples, and add appname=
to the prefix parser.

6 years agoMerge pull request #392 from bersace/job-per-file
Étienne BERSAC [Thu, 15 Feb 2018 08:07:32 +0000 (09:07 +0100)]
Merge pull request #392 from bersace/job-per-file

Job per file long option not parsed

6 years agoIgnore blib files
Étienne BERSAC [Thu, 15 Feb 2018 08:04:48 +0000 (09:04 +0100)]
Ignore blib files

6 years agoFix --Jobs long option parsing
Étienne BERSAC [Thu, 15 Feb 2018 08:03:14 +0000 (09:03 +0100)]
Fix --Jobs long option parsing

6 years agoMerge pull request #387 from daamien/tests
damien clochard [Mon, 15 Jan 2018 16:48:24 +0000 (17:48 +0100)]
Merge pull request #387 from daamien/tests

[ci] Add consistency tests

6 years agoFIX : indent setup code
damien clochard [Mon, 15 Jan 2018 08:54:57 +0000 (09:54 +0100)]
FIX : indent setup code

6 years agoFIX : bad copy-pasta / add better comments
damien clochard [Mon, 15 Jan 2018 08:33:59 +0000 (09:33 +0100)]
FIX : bad copy-pasta  / add better comments

6 years ago[ci] Add consistency tests
damien clochard [Sun, 14 Jan 2018 21:03:23 +0000 (22:03 +0100)]
[ci] Add consistency tests

7 years agoMerge pull request #382 from Krysztophe/doc_stderr_not_a_default_anymore
Étienne BERSAC [Wed, 22 Nov 2017 14:25:02 +0000 (15:25 +0100)]
Merge pull request #382 from Krysztophe/doc_stderr_not_a_default_anymore

doc update : stderr is not a default for -f

7 years agoMerge pull request #383 from bersace/doc
Étienne BERSAC [Wed, 22 Nov 2017 14:24:34 +0000 (15:24 +0100)]
Merge pull request #383 from bersace/doc

Ease contribution to documentation

7 years agoTells to maintain DESCRIPTION in pod
Étienne BERSAC [Wed, 22 Nov 2017 13:57:44 +0000 (14:57 +0100)]
Tells to maintain DESCRIPTION in pod

7 years agoAlways update pod and README
Étienne BERSAC [Wed, 22 Nov 2017 13:57:44 +0000 (14:57 +0100)]
Always update pod and README

7 years agodoc update : stderr is not a default for -f
Christophe Courtois [Wed, 22 Nov 2017 11:04:48 +0000 (12:04 +0100)]
doc update : stderr is not a default for -f

7 years agoMerge pull request #370 from bersace/pid
Étienne BERSAC [Fri, 22 Sep 2017 08:25:05 +0000 (10:25 +0200)]
Merge pull request #370 from bersace/pid

Add --pid-file CLI switch

7 years agoAllow to customize only pid file
Étienne BERSAC [Thu, 21 Sep 2017 07:52:52 +0000 (09:52 +0200)]
Allow to customize only pid file

7 years agoRevert "Use an isolated tmpdir"
Étienne BERSAC [Thu, 21 Sep 2017 07:34:40 +0000 (09:34 +0200)]
Revert "Use an isolated tmpdir"

This reverts commit 692cc4a52ea19d4b52f0db53931f5c5594a640ab.

7 years agoMerge pull request #371 from bersace/help
Étienne BERSAC [Thu, 21 Sep 2017 10:24:21 +0000 (12:24 +0200)]
Merge pull request #371 from bersace/help

Update synopsis from --help in pod

7 years agoFix outdated README and .pod WRT --help
Étienne BERSAC [Thu, 21 Sep 2017 09:44:48 +0000 (11:44 +0200)]
Fix outdated README and .pod WRT --help

7 years agoUpdate synopsis from --help in pod
Étienne BERSAC [Thu, 21 Sep 2017 09:41:16 +0000 (11:41 +0200)]
Update synopsis from --help in pod

7 years agoMerge pull request #369 from bersace/tmp
Étienne BERSAC [Wed, 20 Sep 2017 13:56:36 +0000 (15:56 +0200)]
Merge pull request #369 from bersace/tmp

Use an isolated tmpdir

7 years agoUse an isolated tmpdir
Étienne BERSAC [Wed, 20 Sep 2017 09:36:19 +0000 (11:36 +0200)]
Use an isolated tmpdir

7 years agoMerge pull request #365 from bersace/exclude
Étienne BERSAC [Wed, 20 Sep 2017 07:36:14 +0000 (09:36 +0200)]
Merge pull request #365 from bersace/exclude

Regression test for binary to JSON

7 years agoAdd regression test from bin to JSON
Étienne BERSAC [Wed, 20 Sep 2017 07:34:48 +0000 (09:34 +0200)]
Add regression test from bin to JSON

7 years agoInstaller le client SSH seulement
Étienne BERSAC [Wed, 20 Sep 2017 07:34:48 +0000 (09:34 +0200)]
Installer le client SSH seulement

7 years agoRun test in verbose mode in CI
Étienne BERSAC [Wed, 20 Sep 2017 07:34:48 +0000 (09:34 +0200)]
Run test in verbose mode in CI

7 years agoClean out.html before testing generation
Étienne BERSAC [Wed, 20 Sep 2017 07:34:48 +0000 (09:34 +0200)]
Clean out.html before testing generation

7 years agoLint help test title
Étienne BERSAC [Wed, 20 Sep 2017 07:34:48 +0000 (09:34 +0200)]
Lint help test title

7 years agoAdd editor hint for test scripts
Étienne BERSAC [Wed, 20 Sep 2017 07:34:48 +0000 (09:34 +0200)]
Add editor hint for test scripts

7 years agoMerge pull request #366 from bersace/editorconfig
Étienne BERSAC [Wed, 20 Sep 2017 07:34:25 +0000 (09:34 +0200)]
Merge pull request #366 from bersace/editorconfig

Add editorconfig configuration

7 years agoAdd editorconfig configuration
Étienne BERSAC [Tue, 19 Sep 2017 14:42:22 +0000 (16:42 +0200)]
Add editorconfig configuration

7 years agoMerge pull request #368 from bersace/pod
Étienne BERSAC [Wed, 20 Sep 2017 07:29:40 +0000 (09:29 +0200)]
Merge pull request #368 from bersace/pod

Check README

7 years agoUpdate README and pod
Étienne BERSAC [Wed, 20 Sep 2017 07:08:34 +0000 (09:08 +0200)]
Update README and pod

7 years agoAdd a job to check README
Étienne BERSAC [Wed, 20 Sep 2017 07:03:19 +0000 (09:03 +0200)]
Add a job to check README

7 years agoClean trailing new line
Étienne BERSAC [Wed, 20 Sep 2017 06:54:23 +0000 (08:54 +0200)]
Clean trailing new line

7 years agoAdd README target
Étienne BERSAC [Wed, 20 Sep 2017 06:54:12 +0000 (08:54 +0200)]
Add README target

7 years agoIgnore Makefile.PL generated files
Étienne BERSAC [Wed, 20 Sep 2017 06:43:43 +0000 (08:43 +0200)]
Ignore Makefile.PL generated files

7 years agoDrop vi temp files from gitignore
Étienne BERSAC [Wed, 20 Sep 2017 06:42:20 +0000 (08:42 +0200)]
Drop vi temp files from gitignore

Please use you very own global gitignore if you use vi.

7 years agoMerge pull request #364 from bersace/tap
Étienne BERSAC [Fri, 8 Sep 2017 08:15:15 +0000 (10:15 +0200)]
Merge pull request #364 from bersace/tap

Check pod syntax

7 years agoMerge pull request #357 from wesleybowman/master
Étienne BERSAC [Fri, 8 Sep 2017 08:13:52 +0000 (10:13 +0200)]
Merge pull request #357 from wesleybowman/master

Add --include-time option

7 years agoAdd --include-time option
Wesley Bowman [Tue, 22 Aug 2017 06:28:42 +0000 (08:28 +0200)]
Add --include-time option

This adds the ability to choose times that you want to see, instead of
excluding all the times you do not want to see. This is handy when
wanting to view only one or two days from a week's worth of logs
(simplifies down from multiple --exlucde-time options to one
--include-time)

Update the documentation & remove double negative

7 years agoCheck pod syntax
Étienne BERSAC [Fri, 8 Sep 2017 07:30:07 +0000 (09:30 +0200)]
Check pod syntax

7 years agoMerge pull request #363 from bersace/tap
Étienne BERSAC [Fri, 8 Sep 2017 07:28:31 +0000 (09:28 +0200)]
Merge pull request #363 from bersace/tap

Add regular test suite

7 years agoAdd HACKING to document tests
Étienne BERSAC [Thu, 7 Sep 2017 14:32:49 +0000 (16:32 +0200)]
Add HACKING to document tests

7 years agoAdd light log tests
Étienne BERSAC [Thu, 7 Sep 2017 14:26:27 +0000 (16:26 +0200)]
Add light log tests

7 years agoMove to prove to run tests
Étienne BERSAC [Thu, 7 Sep 2017 14:20:35 +0000 (16:20 +0200)]
Move to prove to run tests

7 years agoMerge pull request #362 from bersace/ci
Étienne BERSAC [Thu, 7 Sep 2017 11:52:52 +0000 (13:52 +0200)]
Merge pull request #362 from bersace/ci

Add CircleCI job

7 years agoMerge pull request #361 from bersace/drop-bar
Étienne BERSAC [Thu, 7 Sep 2017 08:13:41 +0000 (10:13 +0200)]
Merge pull request #361 from bersace/drop-bar

Drop --bar-graph option

7 years agoMerge pull request #360 from bersace/tidy
Étienne BERSAC [Wed, 6 Sep 2017 16:00:10 +0000 (18:00 +0200)]
Merge pull request #360 from bersace/tidy

Drop misleading .perltidyrc

7 years agoAdd CircleCI job
Étienne BERSAC [Wed, 6 Sep 2017 14:49:10 +0000 (16:49 +0200)]
Add CircleCI job

7 years agoDrop --bar-graph option
Étienne BERSAC [Wed, 6 Sep 2017 13:49:36 +0000 (15:49 +0200)]
Drop --bar-graph option

7 years agoDrop misleading .perltidyrc
Étienne BERSAC [Wed, 6 Sep 2017 13:32:56 +0000 (15:32 +0200)]
Drop misleading .perltidyrc

This file date from 2012 and pgbadger code is far from compliant. perltidy
unified diff is 10k lines. Let's drop this.

7 years agoMerge pull request #355 from jpargudo/master
Gilles Darold [Fri, 11 Aug 2017 15:27:55 +0000 (17:27 +0200)]
Merge pull request #355 from jpargudo/master

https://github.com/dalibo/pgbadger/issues/353

7 years agohttps://github.com/dalibo/pgbadger/issues/353
Jean-Paul Argudo [Fri, 11 Aug 2017 11:31:24 +0000 (13:31 +0200)]
https://github.com/dalibo/pgbadger/issues/353

7 years agoUpdate Changelog and version to 9.2 v9.2
Gilles Darold [Fri, 28 Jul 2017 11:45:06 +0000 (13:45 +0200)]
Update Changelog and version to 9.2