# pgBadger 13.x Release Notes

> Complete upstream release notes for the pgBadger 13.x series

---

LLMS index: [llms.txt](/llms.txt)

---

These entries preserve the complete upstream change record for pgBadger 13.x, newest first.

> Source: [upstream `ChangeLog`](https://github.com/darold/pgbadger/blob/a1ad95a035a0c2d246fe632eb1c361d4bde0ddae/ChangeLog) at commit [`a1ad95a`](https://github.com/darold/pgbadger/commit/a1ad95a035a0c2d246fe632eb1c361d4bde0ddae).

## v13.2 · 2025-12-29 {#v13-2}

This is a maintenance release of pgBadger that fixes issues and applied patches
reported by users since last release.

  - Fix normalization that was not handling properly balanced single-quoted
    strings along with escaped quotes inside. Thanks to Bertrand Bourgier for
    the report.
  - Fix placeholder requirements in the doc.
  - Fix case where no error sample log entries was reported. Thanks to john doe
    for the report.
  - Fix possible precedence problem between ! and %s. Thanks to Luca Santarelli
    and Philipp Trulson for the report.
  - Update pgFormatter code to v5.9
  - Add github CI action for testing on commit push.
  - Fix parsing of %r placeholder in log_line_prefix. Thanks to nike7o0 for the
    report.
  - Fix uninitialized value warning. Thanks to Ales Zeleny for the report.
  - Enhance docs of ssh-options for postgres log parsing with examples. Thanks
    to Ulrich Konrad for the patch.
  - Add command --ssh-sudo to run commands over ssh as sudo. Thanks to Andrew
    Jackson for the patch.
  - Fix possible precedence problem between ! and string eq. Thanks to Adrien
    Nayrat for the report.
  - Fix parsing of pgbouncer stats. Thanks to mrgtt for the report.

## v13.1 · 2025-03-16 {#v13-1}

This is a maintenance release of pgBadger that fixes issues reported by
users since last release and adds some new features:

  - Add new report about vacuum throughput with a graph about vacuum per
    table that consume the more CPU. The table output reports I/O timing
    read and write per table as well as the CPU time elapsed on the table.
    Thanks to Ales Zeleny for the feature request.
    This patch also adds frozen pages and tuples to the Vacuums per Table
    report.
  - Add --no-fork option for debugging purpose to not fork processes at all.
    Thanks to Ales Zeleny for the feature request.
  - Add millisecond to the raw csv output. Thanks to Henrietta Dombrovskaya
    for the feature request.
  - Add log filename to sample reports when multiple file are processed.
    Thanks to Adrien Nayrat for the feature request.

Here is the complete list of changes and acknowledgments:

  - Fix bind parameters parsing. Thanks to Thomas Kotzian for the patch
  - Apply query filter on multi-lines queries. Thanks to Benjamin Jacobs
    for the patch
  - Update test result for log filename storage changes
  - Fix ERROR vs LOG message level in json output. Thanks to Philippe Viegas
    for the report.
  - Remove import of tmpdir not exported method from File::Temp. Thanks to
    kmoradha for the report.

## v13.0 · 2024-12-08 {#v13-0}

This is a major release of pgBadger that fixes issues reported by
users since last release and adds some new features:

  * Add two new option to be able to redefined inbound of query and session
    histogram.
       --histogram-query VAL   : use custom inbound for query times histogram.
                                 Default inbound in milliseconds:
                             0,1,5,10,25,50,100,500,1000,10000
       --histogram-session VAL : use custom inbound for session times histogram.
                                 Default inbound in milliseconds:
                             0,500,1000,30000,60000,600000,1800000,3600000,28800000
    Thanks to JosefMachytkaNetApp for the feature request.
  * Add support of auto_explain plan for csv and json log formats. Thanks
    to zxwsbg and to Alexander Rumyantsev for the report.
  * Add three LOG message that was not reported as events: unexpected EOF,
    incomplete startup packet and detected deadlock while waiting for. Thanks
    to dottle for the report.

Backward compatibility issues:

  - Change the way LOG level events reported in the Events reports are
    stored. Some of them was still reported and counted as errors instead
    as LOG level entries. The fix is to stored and report them as EVENTLOG
    to differentiate them from queries. This change introduce a backward
    compatibility break when pgbadger is used in incremental mode. You will
    just have the double behavior during the week of the upgrade.
    Thanks to Matti Linnanvuori for the report.

Bug fixes:

  - Fix non reported queries generating the most cancellation due to statement_timeout.
  - Update regression tests
  - Fix formatting of explain plan when extracted from csv log format.
  - Fix jsonlog missing autovacuum data reports:
    Average Autovacuum Duration, Tuples removed per table
    and vacuums by hour in autovacuum activity report.
    Thanks to Ales Zeleny for the patch.
  - Fix orphan line not associated to the time consuming bind queries.
    Thanks to Henrietta Dombrovskaya for the report.
    Fix use of uninitialized value in pattern match. Thanks to Junior Dias
    for the patch.
  - Apply option --csv-separator to raw export to CSV. Default separator
    is semicolon (;). Thanks to Henrietta Dombrovskaya for the feature
    request.
  - Raw csv output: do not add double quote to parameters and application
    name if they are empty.
  - Add double quotes when queries have a semi colon in raw csv output.
    Thanks to Henrietta Dombrovskaya for the report.