check_postgres
check_postgres copied to clipboard
bucardo
Nagios check_postgres plugin for checking status of PostgreSQL databases
Hi, I have just setup check_postgres plugin in icinga and I came to output which I don't understand ``` check_postgres.pl --action hot_standby_delay --dbuser=icinga,icinga --dbhost=master,slave -w 5 -c 10 POSTGRES_HOT_STANDBY_DELAY OK:...
Hi, We tried the check_postgres for example for checking long running queries (--action query_time). However when we didn't have enough permissions it just outputted: POSTGRES_QUERY_TIME OK: DB "postgres" (host:127.0.0.1) longest...
Since `$maxr->{query}` may be an empty string, we need to guard against falling back to the old, undefined, column name and trigger a warning.
ID: 98 Version: 2.19.0 Date: 2012-01-19 05:46 EST Author: Martin von Oertzen ([email protected]) --- one part of the `--action=sequence` needs over 3 minutes with postgres 9.1.2: ``` SELECT nspname, seq.relname,...
ID: 115 Version: 2.19.0 Date: 2012-10-30 03:21 EDT Author: [email protected] --- I have multiple databases with the same schema including same sequences. I want to check their sequences with `--action=sequence`....
not sure if it is technically possible, but if I specify a certain DB with `--include`, it would be nice if `check_postgres` would report the % of connections based on...
...tabases, used for bloat check
check_txn_idle() introduced multiple '>' version ckecks to handle v10 postgres, but run_command() does not correctly implement such multiple '>' or '
This isn't an issue with the bloat calculation itself, but with the evaluation of the thresholds ``` POSTGRES_BLOAT WARNING: DB "mydb" (host:my.db.server) (db mydb) table public.instance rows:195969008 pages:13835076 shouldbe:13525027 (1.0X)...
Hi, we expecting wrong results with the query_time check on a postgres10 with logical replication. It will report a long running query, but w/o any statement. This behaviour is happening...
