Polling pg_stat_activity vs pg_stat_statements for Idle-in-Transaction Alerting: Which Minimizes Noise?
Detecting Idle‑in‑Transaction Sessions with Minimal Noise The goal is to raise an alert when a PostgreSQL session remains idle inside a transaction long enough to risk lock contention, while avoiding repeated notifications for the same session. Two documented techniques exist: periodic polling of pg_stat_activity filtered by state = 'idle in transaction' and