Glossary: PostgreSQL Beyond the Basics
Idle in transaction
Also written: idle in transaction
A session that ran BEGIN and then stopped sending commands. It does no work but holds its locks and stops VACUUM from cleaning up.
Where the book teaches it
Related terms
pg_stat_activitypg_cancel_backend(), pg_terminate_backend()idle_in_transaction_session_timeout