check_pgactivity

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.

2020-11-24 - Version 2.5

Changelog:

• add: new oldest_xmin service
• add: new extensions_versions service
• add: new checksum_errors service
• add: support for v13 and other improvements on replication_slots
• add: v13 compatibility for service wal_files
• add: various documentation details and examples
• add: support service replication_slots on standby
• add: accept single b or o as size unit
• add: json and json_strict output formats
• add: size and/or delta thresholds for database_size service
• add: thresholds are now optional for service database_size
• add: support for v12 and v13 archive_folder
• regression: threshold repslot becomes spilled in service replication_slots
• regression: in services latest_vacuum and latest_analyze: a critical alert is now raised on tables that were never analyzed/vacuumed or whose maintenance date was lost due to a crash
• fix: avoid alerts for lack of maintenance on inactive db
• fix: forbid rare cases of division by zero in wal_files
• fix: do not alert on missing file in temp_files for v10+
• fix: detect lack of maintenance in last_vacuum and last_analyze for never maintained tables
• fix: backend count for v10+
• fix: replace NaN with "U" for strict outputs
• fix: do not count walsenders as part of max_connections
• fix: broken archiver service with v10+
• fix: perl warning when archiver is not active