check_pgactivity

2026-02-17 v2.9:

Changelog:

• add: compatibility with PostgreSQL 18 compatibility (Guillaume Lelarge)
• add: new service pgss_dealloc (Adrien Nayrat)
• add: new slru_hit_ratio service (Guillaume Lelarge)
• add: allow warnings from the settings service to expire (Benoît Lobréau)
• add: add github action to run tests across several Postgres versions (Adrien Nayrat)
• fix: ignore partition table in check_last_maintenance (Adrien Nayrat)
• fix: check if server is primary for last_maintenance (Guillaume Lelarge)
• fix: annoying race condition in archiver service (Jehan-Guillaume de Rorthais)
• fix: documentation for check_archiver service (Thomas Reiss)
• fix: filter out xact with no backend_xid or no backend_xmin for oldest_idlexact service (Frédéric Yhuel)
• fix: make archiver to not bail out when archiving is off (Thomas Reiss)
• fix: fix to_size buggy unit conversion (Jehan-Guillaume de Rorthais)

2025-10-14 - Version 2.8

Changelog:

• add: compatibility with PostgreSQL 16 and 17, basic v18 compatibility (Thomas Reiss)
• add: hugepages service (PG≥17) (Benoit Lobréau)
• fix: bgwriter service for PG17 (Christophe Courtois)
• change: minimum psql version is 8.4, or use "--old-psql" (Jehan-Guillaume de Rorthais)
• change: longest_query only looks at client backends and bgworkers, not autovacuum nor walsender workers (Thomas)
• fix: last_vacuum/analyze was never raising an alert if a threshold was changed on an inactive server (Christophe)

2023-09-25 - Version 2.7:

Changelog:

• add: compatibility with PostgreSQL 15 and 16, Jehan-Guillaume de Rorthais, Thomas Reiss
• change: stat_snapshot_age is compatible from PostgreSQL v9.5 to v14, Benoit Lobréau
• change: simplify session accounting in backends_status, Thomas Reiss
• fix: compatibility of backup_label_age with PostgreSQL 15 and after, Thomas Reiss
• fix: in pg_dump_backup, error explicitly if --path is a directory, Christophe Courtois
• fix: temp_files on PG10 was counting all DB files, Christophe Courtois, Benoit Lobréau
• fix: make check_archiver output oldest_ready_wal=0 when archive queue is empty, Thomas Reiss
• fix: make check_archiver work properly with PostgreSQL 10 without being superuser, Thomas Reiss
• fix: in backends_status, avoid "idle in transaction" false positive for PostgreSQL 9.2 and after, Thomas Reiss
• fix: issue with check_pgactivity missing lock file, Joern Ott, Julien Rouhaud, Jehan-Guillaume de Rorthais
• fix: in btree_bloat, adjust index tuple header size, Shangzi Xie, Jehan-Guillaume de Rorthais

Many thanks to all contributors of this release for feedbacks, bug reports, patches and patch reviews, etc