Backend & systems·Transactions and isolation
someone opened a transaction, went off to call an HTTP API, and left locks and dead row versions pinned for eight seconds.
Idle in transaction
Also calledlong-running transaction, open transaction
A transaction that is open but not doing work, usually because network I/O happened between BEGIN and COMMIT. It holds locks, blocks vacuum or version cleanup, and pins the replication slot. Keeping transactions short and free of external calls is one of the highest-value rules in application database code.