[check_postgres] check_postgres: script told me to send you the output.
Mark Enzinas
mark.enzinas at virgingaming.com
Tue May 31 01:46:29 UTC 2011
I can't seem to get this one to work. The output itself told me to "report these details" so here they are:
[01:42:30]$ ./check_postgres_query_time --dbhost=db-qa-01 --dbuser=check_postgres --dbpass=check_postgres
Could not parse psql output!
Please report these details to check_postgres at bucardo.org:
Version: 2.16.0
Action: query_time
Calling line: 4506
Output: SELECT
Command: /usr/bin/psql -q -t -d template1 -U check_postgres -p 5432 -h db-qa-01 -o /tmp/MiM7AeC2wt/check_postgres_psql.T5PdqrP.tmp -x -c BEGIN;SET statement_timeout=30000;COMMIT;
SELECT
xact_start,
SUBSTR(current_query,0,100) AS current_query,
client_addr,
client_port,
procpid,
COALESCE(ROUND(EXTRACT(epoch FROM now()-query_start)),0) AS qtime,
datname,
usename
FROM pg_stat_activity
WHERE current_query <> '<IDLE>'
ORDER BY xact_start, procpid DESC
More information about the Check_postgres
mailing list