The PoWA team has released powa-archivist 5.3.0, the core extension of the PostgreSQL Workload Analyzer (PoWA). PoWA is a performance monitoring and tuning tool that aggregates metrics from PostgreSQL instances, providing real-time charts, graphs, and optimization suggestions such as global or per-query index recommendations. This release focuses on PostgreSQL 18 beta 2 compatibility and a critical fix for lock wait time data handling.
Key changes in this version:
- PostgreSQL 18 beta 2 compatibility: powa-archivist now works with the latest beta of PostgreSQL 18, ensuring that early adopters can use PoWA for performance analysis on new releases.
- Fix for
pg_stat_lock.wait_timedatatype change: Thewait_timefield inpg_stat_lockchanged its data type in PostgreSQL 18. This update adjusts the extension to correctly handle the new type, preventing errors or incorrect metric interpretation.
The fix was contributed by Julien Rouhaud, a core PoWA developer. Users who reported bugs or submitted patches are credited in the CHANGELOG and CONTRIBUTORS files.
For developers, this release is essential for anyone tracking PostgreSQL 18 development. The pg_stat_lock.wait_time change could lead to silent data corruption or runtime failures in older versions of powa-archivist when querying lock statistics. Upgrading ensures accurate monitoring and avoids potential crashes in production environments. Additionally, the beta compatibility means you can start performance testing with PostgreSQL 18 early, giving you a head start on tuning and index optimization.
powa-archivist remains open source, and contributions are welcome via the GitHub repository. Full documentation is available at powa.readthedocs.io.
Source: https://www.postgresql.org/about/news/powa-archivist-530-is-out-3366/