The PoWA project has released powa-archivist 5.2.0, the core extension for the PostgreSQL Workload Analyzer. This performance tool collects and aggregates metrics from multiple PostgreSQL instances, offering real-time charts, query-level tuning suggestions, and index recommendations. The new version extends support to PostgreSQL 19, adding monitoring capabilities for recently introduced statistics.
Key changes in this release:
- Added support for PostgreSQL 19, now compatible with all supported PostgreSQL versions.
- Integrated new statistics views:
pg_stat_recoveryandpg_stat_lock. The former tracks recovery progress, while the latter provides lock-related metrics, enabling deeper insight into database contention and replication health.
For developers, this release means they can now monitor pg19 workloads using the same PoWA infrastructure. The new pg_stat_recovery view is critical for assessing standby server progress, and pg_stat_lock helps identify locking bottlenecks that can degrade performance. As always, the team encourages community contributions via the GitHub repository.
Source: https://www.postgresql.org/about/news/powa-archivist-520-is-out-3347/