[check_postgres] check_postgres: script told me to send you the output.

[Mark Enzinas]

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