bwicklund

-- Show all running querys
SELECT user, pid, application_name, query, age(clock_timestamp(), query_start), state
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- kill running query
SELECT pg_cancel_backend(procpid);

-- kill idle query