---

SELECT
    pid,
    leader_pid,
    backend_type,
    query_start,
    clock_timestamp() - query_start AS duration,
    wait_event_type,
    wait_event,
    array_to_string(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 = 'active'
  AND (
      query ILIKE '%ops_sharer%'
      OR query ILIKE '%report.dia_rops%'
      OR query ILIKE '%dev.unique_number%'
      OR query ILIKE '%report.dia_register%'
  )
ORDER BY query_start DESC;