check_pgactivity

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

2022-07-08 - Version 2.6

Changelog:

• add: new session_stats service to gather miscellaneous session statistics, Frédéric Yhuel
• add: compatibility with PostgreSQL 14, Frédéric Yhuel
• change: service autovacuum does not show max_workers anymore for 8.2 and below, Jehan-Guillaume de Rorthais
• change: various messages and code cleanup, Julian Vanden Broeck, Jehan-Guillaume de Rorthais
• fix: last_vacuum and last_analyse to reports the correct oldest maintenance, Frédéric Yhuel, Jehan-Guillaume de Rorthais
• fix: service check_oldest_idlexact now use state_change instead of xact_start to calculate the idle time, Thomas Reiss
• fix: improve locking around the status file to avoid dead locks and status file truncation, Arnaud Aujou, Julien Rouhaud, Jehan-Guillaume de Rorthais
• fix: possible division by 0 in table_bloat service, Pavel Golub
• fix: threshold check and support interval for service check_stat_snapshot_age, Jehan-Guillaume de Rorthais
• fix: service check_archiver when a .history or .backup file is staled, Thomas Reiss
• fix: service sequences_exhausted now checks also sequences that are not owned by a table column, Thomas Reiss
• fix: service check_archiver when no WAL was ever archived, Thomas Reiss

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