From 39192c8506b69739e2f3a1c5fdf46ac5d495f1b1 Mon Sep 17 00:00:00 2001 From: Mika Eloranta Date: Wed, 30 Jan 2013 21:23:15 +0200 Subject: [PATCH] check_txn_idle: fix query_time --excludeuser query Parenthesis are required: "a OR b AND usename <> 'foo'" -> "(a OR b) AND usename <> 'foo'" Fixes at least "query_time --includeuser/--excludeuser". --- check_postgres.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/check_postgres.pl b/check_postgres.pl index 09886fe3f..70003e7dd 100755 --- a/check_postgres.pl +++ b/check_postgres.pl @@ -7534,7 +7534,7 @@ sub check_txn_idle { $SQL = q{SELECT datname, datid, procpid AS pid, usename, client_addr, xact_start, current_query AS current_query, '' AS state, }. q{CASE WHEN client_port < 0 THEN 0 ELSE client_port END AS client_port, }. qq{COALESCE(ROUND(EXTRACT(epoch FROM now()-$start)),0) AS seconds }. - qq{FROM pg_stat_activity WHERE $clause$USERWHERECLAUSE }. + qq{FROM pg_stat_activity WHERE ($clause)$USERWHERECLAUSE }. q{ORDER BY xact_start, query_start, procpid DESC}; ## Craft an alternate version for old servers that do not have the xact_start column: ($SQL2 = $SQL) =~ s/xact_start/query_start AS xact_start/; @@ -7544,7 +7544,7 @@ sub check_txn_idle { $SQL2 = $SQL = q{SELECT datname, datid, procpid AS pid, usename, client_addr, current_query AS current_query, '' AS state, }. q{CASE WHEN client_port < 0 THEN 0 ELSE client_port END AS client_port, }. qq{COALESCE(ROUND(EXTRACT(epoch FROM now()-$start)),0) AS seconds }. - qq{FROM pg_stat_activity WHERE $clause$USERWHERECLAUSE }. + qq{FROM pg_stat_activity WHERE ($clause)$USERWHERECLAUSE }. q{ORDER BY query_start, procpid DESC}; } -- 2.39.5