PG14中的idle_session_timeout

$ SELECT * FROMpg_settings WHERE name = 'idle_session_timeout' \gx
-[ RECORD 1]---+-------------------------------------------------------------------------------
name            | idle_session_timeout
setting         | 0
unit            | ms
category        | Client Connection Defaults /Statement Behavior
short_desc      | Sets the maximum allowed idle TIMEBETWEEN queries, WHEN NOT IN a TRANSACTION.
extra_desc      | A VALUE OF 0 turns off the timeout.
context         | USER
vartype         | INTEGER
SOURCE          | DEFAULT
min_val         | 0
max_val         | 2147483647
enumvals        | [NULL]
boot_val        | 0
reset_val       | 0
sourcefile      | [NULL]
sourceline      | [NULL]
pending_restart | f

//设置该参数后：
$ SELECT pg_reload_conf();
 pg_reload_conf
----------------
 t
(1 ROW)

$ SELECT 1;
 ?COLUMN?
----------
        1
(1 ROW)

$ SELECT * FROMpg_settings WHERE name = 'idle_session_timeout' \gx
-[ RECORD 1 ]---+-------------------------------------------------------------------------------
name            | idle_session_timeout
setting         | 10000
unit            | ms
category        | Client Connection Defaults /Statement Behavior
short_desc      | Sets the maximum allowed idle TIMEBETWEEN queries, WHEN NOT IN a TRANSACTION.
extra_desc      | A VALUE OF 0 turns offthe timeout.
context         | USER
vartype         | INTEGER
SOURCE         | configuration file
min_val         | 0
max_val         | 2147483647
enumvals        | [NULL]
boot_val        | 0
reset_val       | 10000
sourcefile      | /home/pgdba/DATA/postgresql.auto.conf
sourceline      | 3
pending_restart | f

2021-01-1211:33:38.892 CET depesz@depesz 61973 [local] LOG:  duration: 2.827 ms  statement: select * from pg_settings wherename = 'idle_session_timeout'
2021-01-1211:33:48.892 CET depesz@depesz 61973 [local] FATAL:  terminating connection due to idle-sessiontimeout
2021-01-1211:33:48.892 CET depesz@depesz 61973 [local] LOG:  disconnection: session time: 0:01:59.743user=depesz database=depesz host=[local]

$ SELECT 1;
FATAL:  terminating connection due TO idle-SESSIONtimeout
server closed theconnection unexpectedly
        This probably means the server TERMINATEDabnormally
        BEFORE OR whileprocessing the request.
The connection TOthe server was lost. Attempting reset: Succeeded.

$ BEGIN;
BEGIN
 
*$ SELECT now();
              now              
-------------------------------
 2021-01-12 11:36:32.131091+01
(1 ROW)
 
...
 
*$ SELECT clock_timestamp(), now(), clock_timestamp() - now();
        clock_timestamp        |              now              |    ?COLUMN?     
-------------------------------+-------------------------------+-----------------
 2021-01-12 11:37:23.368718+01 | 2021-01-12 11:36:32.131091+01 | 00:00:51.237627
(1 ROW)