Wiki / Configuration Parameters

Sets the time interval between optional checks that the client is still connected, while running queries. The check is performed by polling the socket, and allows long running queries to be aborted sooner if the kernel reports that the connection is closed. This option relies on kernel events exposed by Linux, macOS, illumos and the BSD family of operating systems, and is not currently available on other systems. If the value is specified without units, it is taken as milliseconds. The default value is 0, which disables connection checks. Without connection checks, the server will detect the loss of the connection only at the next interaction with the socket, when it waits for, receives or sends data. For the kernel itself to detect lost TCP connections reliably and within a known timeframe in all scenarios including network failure, it may also be necessary to adjust the TCP keepalive settings of the operating system, or the tcp_keepalives_idle, tcp_keepalives_interval and tcp_keepalives_count settings of PostgreSQL.

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

boot val

0

category

Connections and Authentication / TCP Settings

context

user

documented

true

enumvals

Unknown

extra desc

0 disables connection checks.

lang

en

max val

2147483647

metadata version

18

min val

0

name

client_connection_check_interval

short desc

Sets the time interval between checks for disconnection while running queries.

source

pg-settings-source-snapshot

unit

ms

vartype

integer