Find and Kill Queries

Find and Kill Queries.sql

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

-- , pg_terminate_backend(pid) -- UNCOMMENT TO KILL

FROM pg_stat_activity
WHERE query LIKE '%'                -- Edit as necessary to match your query
  AND 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;