joshwiens · January 6, 2017 22:06
diff --git a/PG Timeout SQL b/PG Timeout SQL
 SELECT pg_terminate_backend(pid)
    FROM pg_stat_activity
    WHERE datname = 'regress'
      AND pid <> pg_backend_pid()
      AND state = 'idle'
      AND state_change < current_timestamp - INTERVAL '1' MINUTE;
	SELECT pg_terminate_backend(pid)
	FROM pg_stat_activity
	WHERE datname = 'regress'
	AND pid <> pg_backend_pid()
	AND state = 'idle'
	AND state_change < current_timestamp - INTERVAL '1' MINUTE;