The PoWA team is pleased to announce the release of the version 4.2.0 of powa-archivist, the core extension of the PoWA project, a PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers.
New feature
Add pg_stat_statements.toplevel field (Marc Cousin, Julien Rouhaud)
Bugfixes
Fix a possible long waiting time when the background worker is asleep and another session is waiting for a pending event, like a DROP DATABASE (Julien Rouhaud, thanks for github user anikin-aa for the report)
Fix pg_stat_kcache support when not all metrics are available (Julien Rouhaud)
Misc
Add compatibility with postgres 16 (Julien Rouhaud)
Immediately exit the bgworker in binary upgrade mode, which could lead to data corruption in the powa database (Julien Rouhaud)
Links & Credits
Thank to the users who reported bugs or submitted patches, they are all cited in the CHANGELOG file and the CONTRIBUTORS file.
powa-archivist 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 repository at https://github.com/powa-team/powa-archivist.