pgBadger Files

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. Thanks to JosefMachytkaNetApp for the feature request.

     --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
  

  • 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.