Wiki / Configuration Parameters

Terminate any session that has been idle (that is, waiting for a client query) within an open transaction for longer than the specified amount of time. If this value is specified without units, it is taken as milliseconds. A value of zero (the default) disables the timeout. This option can be used to ensure that idle sessions do not hold locks for an unreasonable amount of time. Even when no significant locks are held, an open transaction prevents vacuuming away recently-dead tuples that may be visible only to this transaction; so remaining idle for a long time can contribute to table bloat. See Section 24.1 for more details.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

0

category

Client Connection Defaults / Statement Behavior

context

user

documented

true

enumvals

Unknown

extra desc

0 disables the timeout.

lang

en

max val

2147483647

metadata version

18

min val

0

name

idle_in_transaction_session_timeout

short desc

Sets the maximum allowed idle time between queries, when in a transaction.

source

pg-settings-source-snapshot

unit

ms

vartype

integer