[check_postgres] check_postgres_query_time

["Schöke, Karsten"]

Hi,

since update to version 2.15.4 i can't use check_postgres_query_time.

Here is my command:

#./check_postgres_query_time -H hostname

This is the output:

Could not parse psql output!
Please report these details to check_postgres at bucardo.org:
Version:      2.15.4
Action:       query_time
Calling line: 4378
Output:       SELECT
Command:      /usr/bin/psql -q -t -d template1 -U postgres -p 5432 -h hostname -o /tmp/6gKoKrYxQ1/check_postgres_psql.GIAHiqs.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

can you help me?

thx
Karsten

+------------------------------------------------------+
| Landesvermessung und Geobasisinformation Brandenburg |
| Geokompetenzzentrum                                  |
| Dezernat 13 Technologische Erneuerung                |
| Herr Karsten Schöke                                  |
| Robert-Havemann-Straße 4, 15236 Frankfurt (Oder)     |
+                                                      +
| Mail: Karsten.Schoeke at geobasis-bb.de                 |
| Tel.: (03 35) 55 82 - 553                            |
| Fax.: (03 35) 55 82 - 528                            |
| www.geobasis-bb.de                                   |
+------------------------------------------------------+