andreyshuster/batch-kill-queries-by-condition.md

## batch-kill-queries-by-condition.md

      
    Raw
  

              batch-kill-queries-by-condition.md
            
          
    There is two commands to kill query
Soft kill: pg_cancel_backend(pid)
Hard kill pg_terminate_backend(pid)
SELECT
	pg_terminate_backend(pid)
FROM
	pg_stat_activity
WHERE
	pid <> pg_backend_pid()
	AND query LIKE '%<CONDITION>%'
	AND state = 'active'
	and(now() - pg_stat_activity.query_start) > interval '5 minutes';