idle_in_transaction_session_timeout (integer) ​

This configuration parameter controls how long any transaction within any user session may remain idle before being disconnected. Any session will time out if it has an open transaction that has not run a statement for the specified length of time. The default is 10 minutes (600000 ms). Connections terminated due to idle_in_transaction_session_timeout will result in a sys.log_session state value of 25P03.

This parameter accepts settings with the following units: ms, s, min, h, and d.

Note: Running show idle_in_transaction_session_timeout as a superuser will always return unlimited (0), which is the superuser's setting.

See also: idle_session_timeout.