SELECT usename,application_name,client_addr,pid,now()-query_start durasi, state, query
FROM pg_stat_activity
where state = 'active'
order by 5 desc;
SELECT pg_terminate_backend(2103149);
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE pid IN (2100988,2102017,2102410,2102498,2102702,2102905);