PostgresQL

PostgresQL

Postgres Query Monitoring Wizard

http://www.nagios.com/products/nagiosxi

The version of each Monitoring wizard could be different in different minor versions of Nagios XI. Make sure you download the correct version! Installing a…

PostgresQL

Postgres Server Monitoring Wizard

http://www.nagios.com/products/nagiosxi

The version of each Monitoring wizard could be different in different minor versions of Nagios XI. Make sure you download the correct version! Installing a…

PostgresQL

check_slony

https://github.com/kakikubo/check_slony

PostgresQL

check_psql_query

Running query on Pg server and checking response thresholds.

PostgresQL

PostgreSQL cache hit ratio (bash + psql)

http://www.ropardo.de/

The plugin is rather simple. It just queries a predefined view (SQL included) and checks whether the hit ratios are above a given limit. If…

PostgresQL

pg_db_size

http://www.phonax.com/download/pg_db_size.shtml

It creates a view in the database the first time it's run. All consecutive times it will return the size. You can set the size…

PostgresQL

pg_db_cache_hits

http://www.phonax.com/download/pg_db_cache_hits.shtml

A PostgreSQL plugin that checks the database's cache hits percentage, the closer to 100% the better, lower than 80% provides extra unwanted and costly read()…

PostgresQL

check_postgres

http://bucardo.org/

Connects to one or more Postgres databases and checks for a variety of things. An action is either given on the command line, or inferred…

PostgresQL

check_pgsql_waiting_queries

http://pgfoundry.org/projects/nagiosplugins/

check_pgqueries.pl - Whines if any queries are in the "waiting" state. The script that runs on each DB server does "ps auxww | grep postgres…

PostgresQL

check_pgsql_queries

http://pgfoundry.org/projects/nagiosplugins/

If you have query logging enabled this summarizes the types of queries running (SELECT ,INSERT ,DELETE ,UPDATE ,ALTER ,CREATE ,TRUNCATE, VACUUM, COPY) and warns if…