bmarkons

# disable sleep
sudo pmset -b sleep 0; sudo pmset -b disablesleep 1

# re-enable sleep
sudo pmset -b sleep 5; sudo pmset -b disablesleep 0

bmarkons

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
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