---

SELECT
    a.pid,
    a.leader_pid,
    a.usename,
    a.application_name,
    a.client_addr,
    a.query_start,
    clock_timestamp() - a.query_start AS duration,
    a.wait_event_type,
    a.wait_event,
    CAST(pg_blocking_pids(a.pid) AS text) 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'
  AND (
      a.query ILIKE '%dia_rops%'
      OR a.query ILIKE '%t_balance_c%'
      OR a.query ILIKE '%latest_death_info%'
      OR a.query ILIKE '%rops%'
  )
ORDER BY a.query_start DESC;