The PoWA team has released pg_stat_kcache 2.3.2, an extension that provides detailed statistics on real filesystem reads/writes and CPU usage per query. This update brings PostgreSQL 19 compatibility and a critical installation fix for enterprise Linux distributions.
- PostgreSQL 19 support: Added by Georgy Shelkovy and Julien Rouhaud, ensuring
pg_stat_kcacheworks with the latest PostgreSQL major version. - Installation fix: Pierre Forstmann resolved an issue on RHEL/Rocky/Alma Linux systems, making
make installinpg_stat_kcachesource tree function correctly.
For developers using pg_stat_kcache, this release is essential for monitoring real I/O and CPU costs at the filesystem level—far more accurate than PostgreSQL's own pg_stat_statements. The extension exposes columns like reads, writes, user_time, system_time in pg_stat_kcache and pg_stat_kcache_detail, helping optimize query performance and resource usage. The PostgreSQL 19 compatibility ensures your monitoring stack stays current on upcoming versions of the database, while the installation fix removes a barrier for users on Red Hat–based distributions.
The PoWA (PostgreSQL Workload Analyzer) ecosystem continues to improve. Check the CHANGELOG.md and CONTRIBUTORS.md for full credits. Contributions via GitHub are welcome.
Source: https://www.postgresql.org/about/news/pg_stat_kcache-232-is-out-3328/