Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
New ListingsDirectory Tree
Category: PostgresQL
Nagios plugins for monitoring PostgresQL.
Submit Your Nagios Project!
Help build Nagios Exchange for yourself and the entire the Nagios Community by your Nagios project to the site. It's easy - just create an account, login, and add a new listing. Read the FAQ for instructions.Check postgres replication
Check Postgresql replication, tested on 9.2 and 9.6 it connects to master and standby and reports in case replication is walking behind. It reports how many bytes or MB the replication is behind From and idea of Jonny Morano, completely rewritten by ...
check_database_pgsql
leo.unstable.be/projects/nagios_plugins/This simple plugin checks if its possible to connect to the postgresql database (on localhost) and does a small query.
check_pgactivity
github.com/OPMDG/check_pgactivityChecks 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_pgpool-II.pl
This plugin will check how many backends are connected with PgPool-II and will check if their status are "down"
check_pgpool2
systemonix.blogspot.inThis plugin checks pgpool2 status. It uses pcp_node_info internally to find out node status.
check_pgpool2.sh
Simple nagios plugin to get wait/idle pgpool processes. Useful to graph theme with tools like grafana.
check_pgsql_connections
pgfoundry.org/projects/nagiosplugins/Watch the percentage and number of connections available on a PostgreSQL server.
check_pgsql_partitions.pl
25th-floor.comCheck_partitions is thought as an check if partitions are pre-generated (due to an explicit date). The plugin only handles partitions whose syntax are like table_name_prefix_YYYYMMDD | fooYYYYMM | 123blubbYYYY or just end with a date where there are n ...
check_pgsql_queries
pgfoundry.org/projects/nagiosplugins/Summarizes the types of queries (SELECT ,INSERT ,DELETE ,UPDATE ,ALTER ,CREATE ,TRUNCATE, VACUUM, COPY) running on a PostgreSQL server. This warns about long running queries.
check_pgsql_waiting_queries
pgfoundry.org/projects/nagiosplugins/Monitor if any queries are in a waiting or blocked state on a PostgreSQL server. This uses SNMP to check the status via the ps command.
check_pg_streaming_replication
gogs.zionetrix.net/bn8/check_pg_streaming_replicationNagios plugin to check Postgresql streamin replication status
check_postgres
bucardo.org/Check many things for a Postgres database, including connectivity, version, disk space used, table and index bloat, database size, relation size, locks, number of connections, transaction wraparound, and more.
check_postgresql_unused_db
www.rummandba.com/2013/06/nagios-script-to-find-unused-databThis plugin finds the number of unused databases, that is, the databases that have created or not been accessed or modified a certain time ago.
check_slony
github.com/kakikubo/check_slonyThis plugins will check Slony-I Cluster status(time lag and events). This program is rewriting of check_slony.pl with ruby.
pg_db_cache_hits
www.phonax.com/download/pg_db_cache_hits.shtmlA PostgreSQL plugin that checks the database's cache hits percentage.
pg_db_size
www.phonax.com/download/pg_db_size.shtmlThe pg_db_size plugin checks for the on disk size of any given PostgreSQL database.
Postgres Database Monitoring Wizard
www.nagios.com/products/nagiosxi
A Nagios XI wizard for monitoring various performance metrics of a Postgres database - including connection status, database size, table sizes, relation sizes, and remaining sequences.
Postgres Query Monitoring Wizard
www.nagios.com/products/nagiosxi
A Nagios XI wizard for monitoring Postgres SQL queries.
Postgres Server Monitoring Wizard
www.nagios.com/products/nagiosxi
A Nagios XI wizard for monitoring various performance metrics of a Postgres database server - including connection status, backend connections, and WAL files.
Postgresql 9.3 Streaming Replication Delay
github.com/Winnux76Python script to check and graph the delay in seconds from your primary to your hot standby PostgreSQL 9.3 server.
PostgreSQL cache hit ratio (bash + psql)
www.ropardo.de/A simple plugin for monitoring PostgreSQL cache hit ratios for a whole PG-cluster
