---

SELECT
    a.pid,
    clock_timestamp() - a.query_start AS elapsed,
    a.state,
    a.wait_event_type,
    a.wait_event,
    pg_blocking_pids(a.pid) AS blocking_pids,
    LEFT(a.query, 300) AS query_text
FROM pg_stat_activity a
WHERE a.datname = current_database()
  AND a.pid <> pg_backend_pid()
  AND a.state <> 'idle'
  AND a.query ILIKE '%f_reconciliation_of_operations%'
ORDER BY a.query_start;