check_pgactivity is a PostgreSQL plugin for Nagios. This plugin is written with a focus on a rich perfdata set. Every new features of PostgreSQL can be easily monitored with check_pgactivity.
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
Here are some useful links:
github repo: https://github.com/OPMDG/check_pgactivity
reporting issues: https://github.com/OPMDG/check_pgactivity/issues
latest release: https://github.com/OPMDG/check_pgactivity/releases/latest
contributors: https://github.com/OPMDG/check_pgactivity/blob/master/contributors
Thank you to all contributors of this release for feedbacks, bug reports, patches and patch reviews, etc.
