---

SELECT
    a.pid,
    a.leader_pid,
    a.query_start,
    clock_timestamp() - a.query_start AS duration,
    a.state,
    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.query ILIKE '%latest_death_info%'
ORDER BY a.query_start DESC;