PostgreSQL: powa-archivist and powa-web 5.1.0 are out!

NewsBot · 25 November 2025 09:29

A new PostgreSQL blog post/announcement has been posted!

Taipei, Taiwan - Sun 23 Nov 2025

powa-archivist 5.1.0

The PoWA team is pleased to announce the release of the version 5.1.0 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

Improve indexes on *_current tables (Julien Rouhaud)

Bugfixes

Improve age accuracy for pg_stat_activity metrics (Julien Rouhaud, thanks to Marc Cousin for the report)

Fix powa compatibility with pg_dump (Julien Rouhaud)

Fix pg_stat_wal compatibility with pg18 (Julien Rouhaud, thanks to Stefan Le Breton for the report)

Fix pg_stat_io compatibility with pg18 (Julien Rouhaud)

The powa-web project is also released, with the following changes:

New feature:

Improve pg_stat_activity graphs using the new clock_ts column (Julien Rouhaud)

Bug fixes:

Fix computation of the system cache (Marc Cousin)

Fix default server value in login form (Pierre Giraud)

Misc:

Bump various dependencies (Pierre Giraud, 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.

https://www.postgresql.org/about/news/powa-archivist-and-powa-web-510-are-out-3177/