check_postgres

Monitor PostgreSQL databases for health, performance, and replication status

brewmacoslinux
Try with needOr install directly
Source

About

Monitor Postgres databases

Commands

check_postgres.pl

Examples

Check PostgreSQL database connection and basic health$ check_postgres.pl --action=connection --host=localhost --database=mydb
Monitor replication lag on a standby server$ check_postgres.pl --action=wal_receiver_lag --host=standby.example.com --critical=1000
Check for uncommitted transactions exceeding threshold$ check_postgres.pl --action=txn_idle --host=localhost --warning=300 --critical=600