PoWA, a performance tool for PostgreSQL, has launched version 5.0.2. This version facilitates the collection and aggregation of metrics from various PostgreSQL instances, offering real-time charts and graphs for effective monitoring and optimization of servers. It additionally recommends enhancements for better performance. The update features bug fixes and ensures compatibility with PostgreSQL 18.
powa-archivist 5.0.2 is out!
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)
