pgBadger v11.6 released

From: Gilles Darold via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pgBadger v11.6 released
Date: 2021-09-06 16:54:43
Message-ID: 163094728352.695.8880019555901949591@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Libreville, Gabon - September 4th, 2021

## pgBadger

pgBadger is a PostgreSQL performance analyzer, built for speed with
fully detailed reports based on your PostgreSQL log files.

pgBadger 11.6 was released today, this release of pgBadger adds support
for PostgreSQL 14 new log information, fixes some issues reported by
users since past seven months and adds some improvements:

* Add detection of Query Id in log_line_prefix, new in PG14.
* Add advanced regression tests with db exclusion and the explode
feature.
* Improve speed of reports generation when `--explode` is used by using multi-process.
* Add `--iso-week-number` in incremental mode, calendar's weeks start
on a Monday and respect the ISO 8601 week number, range 01 to 53,
where week 1 is the first week that has at least 4 days in the new
year.
* Add command line option `--keep-comments` to not remove comments from
normalized queries. It can be useful if you want to distinguish
between same normalized queries.
* Skip INFO lines introduced in PostgreSQL log file by third parties
software.
* Add compatibility with PostgresPro log file including rows number
and size in bytes following the statement duration.
* Parse times with T's to allow using the timestamps from journalctl.
* Improve Windows port.

Backward compatibility:

* Expect that `--iso-week-number` will be the default in next major
release and that `--start-monday` option will be removed as the week
will always start a Monday. The possibility to have week reports
start a Sunday (current default) will be removed to simplify the
code.

For the complete list of changes, fixes and acknowledgements, please
checkout the [release note](https://github.com/darold/pgbadger/releases/tag/v11.6)

## Links & Credits

### 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(at)darold(dot)net(dot)

### Links

* Download: [http://pgbadger.darold.net/](http://pgbadger.darold.net/)
* Support: use GitHub report tool at [https://github.com/darold/pgbadger/issues](https://github.com/darold/pgbadger/issues)
* Contact: pgbadger(at)darold(dot)net

For commercial support contact pgbadger(at)darold(dot)net or see the full list of
PostgreSQL companies near of your place at [PostgreSQL Professional Services](http://www.postgresql.org/support/professional_support)
page, they all do great job and most of them can help you.

--------------

## 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/](http://pgbadger.darold.net/)

Browse pgsql-announce by date

  From Date Subject
Next Message Red Hat via PostgreSQL Announce 2021-09-07 14:13:11 pgagroal 1.3.0
Previous Message PWN via PostgreSQL Announce 2021-09-06 16:54:32 PostgreSQL Weekly News - September 5, 2021