---

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