From c09e7840ed82db6274116ce9b83fbdbc72f940c8 Mon Sep 17 00:00:00 2001
From: Sebastian Webber <swebber@outlook.com>
Date: Fri, 13 Mar 2015 10:11:08 -0300
Subject: [PATCH] adjusting check_txn_idle filter by state_change column

---
 check_postgres.pl | 1 +
 1 file changed, 1 insertion(+)

diff --git a/check_postgres.pl b/check_postgres.pl
index 017bed16a..d42b5abf1 100644
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -8019,6 +8019,7 @@ sub check_txn_idle {
     $SQL3 =~ s/current_query NOT LIKE '<IDLE>%'/(state NOT LIKE 'idle%' OR state IS NULL)/; # query_time
     $SQL3 =~ s/current_query/query/g;
     $SQL3 =~ s/'' AS state/state AS state/;
+    $SQL3 =~ s/query_start/state_change/g;
 
     my $info = run_command($SQL, { emptyok => 1 , version => [ "<8.3 $SQL2", ">9.1 $SQL3" ] } );
 
-- 
2.30.2