---

SELECT
    a.pid,
    a.state,
    clock_timestamp() - a.query_start AS duration,
    a.wait_event_type,
    a.wait_event,
    pg_blocking_pids(a.pid) AS blocking_pids,
    a.query
FROM pg_stat_activity a
WHERE a.datname = current_database()
  AND a.pid <> pg_backend_pid()
  AND a.state = 'active'
ORDER BY a.query_start;