Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1


Remember Me

Directory Tree


Current Version
Last Release Date
Compatible With
  • Nagios 3.x
  • Nagios 4.x
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
Checks many things in PostgreSQL and provides rich perfdatas : connectivity, database size, table and index bloat, streaming replication lag, database hit-ratio, etc. Written in Perl language, the code is very easy to extend to add new features.
check_pgactivity provides many services :

* archive_folder: check archives in given folder.
* archiver: check the archiver status and number of wal files ready to archive.
* autovacuum: check the autovacuum activity.
* backends: number of connections, compared to max_connections.
* backends_status: number of connections in relation to their status.
* backup_label_age: check age of backup_label file.
* bgwriter: check the bgwriter activity.
* btree_bloat: check B-tree index bloat.
* checksum_errors: check data checksums errors.
* commit_ratio: commit and rollback rate per second and commit ratio since last execution.
* configuration: check the most important settings.
* connection: perform a simple connection test.
* custom_query: perform the given user query.
* database_size: variation of database sizes.
* extensions_versions: check that installed extensions are up-to-date.
* hit_ratio: check hit ratio on databases.
* hot_standby_delta: check delta in bytes between a master and its hot standbys.
* invalid_indexes: check for invalid indexes.
* is_hot_standby: check if cluster is a hot standby.
* is_master: check if cluster is in production.
* is_replay_paused: check if the replication is paused.
* last_analyze: check the oldest analyze (from autovacuum or not) on the database.
* last_vacuum: check the oldest vacuum (from autovacuum or not) on the database.
* locks: check the number of locks on the hosts.
* longest_query: check the longest running query.
* max_freeze_age: check oldest database in transaction age.
* minor_version: check if the PostgreSQL minor version is the latest one.
* oldest_2pc: check the oldest two-phase commit transaction.
* oldest_idlexact: check the oldest idle transaction.
* oldest_xmin: check the xmin horizon from distinct sources of xmin retention.
* pg_dump_backup: check pg_dump backups age and retention policy.
* pga_version: check the version of this check_pgactivity script.
* pgdata_permission: check that the permission on PGDATA is 700.
* replication_slots: check delta in bytes of the replication slots.
* sequences_exhausted: check that auto-incremented colums aren't reaching their upper limit.
* settings: check if the configuration file changed.
* stat_snapshot_age: check stats collector's stats age.
* streaming_delta: check delta in bytes between a master and its standbys in streaming replication.
* table_bloat: check tables bloat.
* table_unlogged: check unlogged tables
* temp_files: check temp files generation.
* uptime: time since postmaster start or configurtion reload.
* wal_files: total number of WAL files.

Works with PostgreSQL from version 7.4 to 13. It just needs psql to connect to the database.
For PostgreSQL 10 and after, check_pgactivity supports monitoring with a non-privileged user.

Check for a check_pgactivity package availability in your Linux distribution before downloading here.

This program is open source, licensed under the PostgreSQL license. For license terms, see the LICENSE provided with the sources.

Please, file issues on github: