Project Categories PostgresQL

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…

PostgresQL

check_pgpool2.sh

Simple nagios plugin to get wait/idle pgpool processes. Useful to graph theme with tools like grafana.

PostgresQL

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…

PostgresQL

Postgresql 9.3 Streaming Replication Delay

Python script to check and graph the delay in seconds from your primary to your hot standby PostgreSQL 9.3 server.

PostgresQL

check_postgresql_unused_db

This plugin finds the number of unused databases, that is, the databases that have created or not been accessed or modified a certain time ago.

PostgresQL

check_pgsql_partitions.pl

Check_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…

PostgresQL

check_pgpool2

This plugin checks pgpool2 status. It uses pcp_node_info internally to find out node status.

PostgresQL

check_pgpool-II.pl

This plugin will check how many backends are connected with PgPool-II and will check if their status are "down"

PostgresQL

check_slony

This plugins will check Slony-I Cluster status(time lag and events). This program is rewriting of check_slony.pl with ruby.

PostgresQL

check_psql_query

Checking query result on postgresql.

PostgresQL

PostgreSQL cache hit ratio (bash + psql)

A simple plugin for monitoring PostgreSQL cache hit ratios for a whole PG-cluster