Its fairly straight forward to monitor a postgresql table’s activity with the wonderful script check_postgres.pl created by Greg Sabino Mullane. This script is useful for so many things I will surely be writing about other ways to use this script with Nagios and Cacti. Download Script: Download the check_postgres.pl script here.
NAME SYNOPSIS DESCRIPTION Output Modes Nagios output MRTG output Simple output DATABASE CONNECTION OPTIONS OTHER OPTIONS ACTIONS autovac_freeze backends bloat connection custom_query database_size disk_space fsm_pages fsm_relations index_size table_size relation_size last_vacuum last_autovacuum last_analyze last_autoanalyze listener locks logfile query_runtime query_time sequence replicate_row txn_time txn_idle rebuild_symlinks rebuild_symlinks_force settings_checksum timesync txn_wraparound wal_files version BASIC FILTERING USER NAME FILTERING TEST…