September 26, 2024: PostgreSQL 17 Released!

PoWA 5 is out!

Posted on 2024-11-10 by PoWA
Related Open Source

Taipei, Taiwan - November 10th, 2024

The PoWA team is proud to announce the release of PoWA 5.0.0.

PoWA 5 is out

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.

What's new

The version 5 is a new major version. It comes with a brand new version of powa-web, the dedicated UI, with an improved looks and user experience. This new version also allows you to dynamically perform actions, such as performing a metrics snapshots on a specific server or refreshing the catalog copies.

It also brings a lot of new datasources, for general and performance monitoring such as:

  • replication and replication slots stat views
  • background writer and checkpointer stat views
  • new IO stat view (pg16+)
  • SLRU and WAL stat views
  • and a lot more

And introduce snapshot of per-database metrics, such as:

  • historical copies of various catalogs
  • tables and indexes statistics
  • user function statistics

Credits

Thank to the users who reported bugs or submitted patches, they are all cited in the CHANGELOG files of powa-archivist and powa-web projects.

PoWA is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches following the documentation at powa.readthedocs.io/en/latest/contributing.html.

Links

For powa-archivist, the core extension:

For powa-web, the dedicated UI: