Set statement and idle-in-transaction timeouts

Set statement and idle-in-transaction timeouts | BeforeMerge Rules | BeforeMerge

Why this matters

A single runaway query or a transaction left open by a crashed client holds locks and a connection slot indefinitely, blocking other work. Bounded timeouts reclaim resources automatically.

-- Bad: no limits; one bad query stalls the instance
-- (defaults are 0 = unlimited)
 
-- Good: bound query and idle-transaction lifetimes
SET statement_timeout = '30s';
SET idle_in_transaction_session_timeout = '60s';

Why This Matters

Related Rules

Catch this automatically on every PR

Why this matters