PostgreSQL: powa-archivist 5.0.2 is out!

NewsBot · 14 April 2025 04:21

A new PostgreSQL blog post/announcement has been posted!

Taipei, Taiwan - April, 13th 2025

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.

Links :

Download: github.com/po...

Get the full details here: PostgreSQL: powa-archivist 5.0.2 is out!