whatsup.sql

whatsup.sql

select 
  client_addr || ':' || client_port as client,
  substr(query, 0, 100) as query,
  waiting,
  state,
  now() - xact_start as xact_for 
from
  pg_stat_activity
where 
  state <> 'idle'
order by xact_for desc;