Find and Kill Queries

Find and Kill Queries.sql

with queries as (
    select pid,
           age(clock_timestamp(), query_start),
           usename,
           state,
           -- get rid of newlines, runs of spaces
           regexp_replace(query, e'[\\n\\r ]+', ' ', 'g' ) as query
    from pg_stat_activity
    where query not like 'select pid,%' -- don't kill the query-killing query…
      and state != 'idle'               -- idle connections are innocent.
      and usename != 'rdsadmin'         -- can't kill these, don't try.
    order by age desc
)
select
    *
    -- , pg_terminate_backend(pid) -- uncomment to kill
from queries
where query like '%'               -- edit as necessary to match your query
-- and age > interval '5 minutes'  -- edit as necessary to match your query