---

select
    pid,
    state,
    clock_timestamp() - query_start as duration,
    wait_event_type,
    wait_event,
    pg_blocking_pids(pid) as blocking_pids,
    left(query, 600) as query_text
from pg_stat_activity
where datname = current_database()
  and pid <> pg_backend_pid()
  and state <> 'idle'
order by query_start;