[check_postgres] query_time returning long queries that don't exist?
andrew at thepw.com
andrew at thepw.com
Thu Mar 12 17:12:12 UTC 2015
Hi,
Occasionally I get these Nagios alerts:
PG QUERY TIME;OK;HARD;2;POSTGRES_QUERY_TIME OK: DB "postgres" longest
query: 0s
PG QUERY TIME;CRITICAL;HARD;2;POSTGRES_QUERY_TIME CRITICAL: DB
"postgres" longest query: 117s PID:8775
PG QUERY TIME;CRITICAL;SOFT;1;POSTGRES_QUERY_TIME CRITICAL: DB
"postgres" longest query: 57s PID:8775
They are running this command on the database server itself:
check_postgres.pl --action=query_time --warning=25 --critical=30
The database is logging every query, but I don't have any queries at
that time that match these times or even close to it.
I yum installed check_postgres:
Installed Packages
Name : check_postgres
Arch : noarch
Version : 2.19.0
Release : 1.el6
Size : 533 k
Repo : installed
From repo : epel
Summary : PostgreSQL monitoring script
URL : http://bucardo.org/wiki/Check_postgres
License : BSD
and running postgres 8.4:
Installed Packages
Name : postgresql
Arch : x86_64
Version : 8.4.13
Release : 1.el6_3
Size : 14 M
Repo : installed
From repo : updates
Summary : PostgreSQL client programs
URL : http://www.postgresql.org/
License : PostgreSQL
What could be causing these?
Thanks for your help,
Andrew
More information about the Check_postgres
mailing list