Session timeout

You can place a limit on the amount of time an SQL database session is allowed to be idle before the system ends it. You can impose timeouts on both individual users and groups. In addition, users can set their own timeouts.

Tx-Idle sessions are those that are left idle, with the work not committed, such as a BEGIN transaction.

If you want to apply the session timeout only to the Tx-Idle sessions, set the session timeout_tx_only parameter in /nz/data/postgresql.conf to true.

If you do not set this parameter, Tx-Idle sessions follow the parameter that was defined in the session timeout syntax.