The PoWA team is pleased to announce the release of the version 5.0.2 of powa-archivist, the core extension of the PoWA project.
PoWA (PostgreSQL Workload Analyzer) is a performance tool, compatible with all supported PostgreSQL versions. It allows to collect and aggregate metrics gathered from multiple PostgreSQL instances using various extensions covering all parts of PostgreSQL and provides real-time charts and graphs to help monitor and tune your servers. It also suggest optimizations, like global or per-query index suggestions, to easily improve performances.
Performance
Smooth out the coalesces and purges (Marc Cousin and Julien Rouhaud)
Bugfixes
Fix DROP EXTENSION issues when powa is installed (Julien Rouhaud, thanks to Michael Vitale for the report)
Fix aggregation of pg_stat_user_functions datasource (Marc Cousin)
Fix pg_stat_replication compatibility on pg12 and below (Julien Rouhaud)
Fix powa_delete_and_purge_server to also purge *_src_tmp tables (Julien Rouhaud, thanks to github user jw1u1 for the report)
Misc
Fix compatibility with pg18 (Georgy Shelkovy)
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 github.com/powa-team/powa-archivist.
