Grenoble, France - July 26th, 2020
pgBadger is a PostgreSQL performance analyzer, built for speed with
fully detailed reports based on your PostgreSQL log files.
pgBadger 11.3 was released today, this is a maintenance release that
fixes issues reported by users during last four months. There is also
some new useful features:
* Add autodetection of UTC timestamp to avoid applying timezone
for graphs.
* Add support to GCP CloudSQL json log format.
* Add new option --dump-all-queries to use pgBadger to dump all
queries to a text file, no report is generated just the full list
of statements found in the PostgreSQL log. Bind parameters are
inserted into the queries at their respective position.
* Add new option -Q | --query-numbering used to add numbering of
queries to the output when using options --dump-all-queries or
--normalized-only.
* Add new command line option --tempdir to set the directory where
temporary files will be written. Can be useful on system that do
not allow writing to /tmp.
* Add command line option --ssh-port used to set the ssh port if not
default to 22. The URI notation also adds support to ssh port
specification by using the form:
ssh://192.168.1.100:2222//var/log/postgresql-11.log
For the complete list of changes, please checkout the release note
on https://github.com/darold/pgbadger/blob/master/ChangeLog
===== Links & Credits =====
I would like to thank all users who submitted patches and users
who reported bugs and feature requests, they are all cited
the ChangeLog file.
pgBadger is an open project. Any contribution to build a better tool
is welcome. You just have to send your ideas, features requests or
patches using the GitHub tools or directly to pgbadger@darold.net.
Links :
* Download: https://github.com/darold/pgbadger/releases/
* Support: use GitHub report tool at
https://github.com/darold/pgbadger/issues
or contact pgbadger@darold.net.
For a complete list of commercial support near of your place take a look
at the PostgreSQL Professional Services page, they all do great job and
most of them can help you.
(http://www.postgresql.org/support/professional_support)
--------------
**About pgBadger** :
pgBagder is a new generation log analyzer for PostgreSQL, created by
Gilles Darold (also author of ora2pg, the powerful migration tool).
pgBadger is a fast and easy tool to analyze your SQL traffic and create
HTML5 reports with dynamics graphs. pgBadger is the perfect tool to
understand the behavior of your PostgreSQL servers and identify which
SQL queries need to be optimized.
Docs, Download & Demo at http://pgbadger.darold.net/
--
Gilles Darold