postgresql statement problem

[liam saffioti <liam.saffiotti@xxxxxxxxx>]

Hello Team,

I am using PG 14.5, and I have a problem with connection. A connection works more than 2 hours even though it's limited to two hours. How is this possible?  The detail is below:

(DWH user is not a superuser, it is a standard user that has select only privilege.)

show statement_timeout ;
 statement_timeout
-------------------
 2h

show max_standby_archive_delay ;
 max_standby_archive_delay
---------------------------
 2h

show max_standby_streaming_delay ;
 max_standby_streaming_delay
-----------------------------
 2h

SELECT usename, state,wait_event, backend_xmin,xact_start,query_start,state_change,now() FROM pg_stat_activity WHERE backend_xmin IS NOT NULL ORDER BY age(backend_xmin) DESC;
 usename     |        state        | client_addr  | wait_event  | backend_xmin |          xact_start           |          query_start          |         state_change    | now              
--------+-----------------+---------------------+--------------+-------------+--------------+-------------------------------+-------------------------------+-------------------------------+-------------------------------
DWH   | idle in transaction  | ClientRead  |  47730267 | 2022-08-25 21:03:02.961309+03 | 2022-08-25 21:05:32.27796+03  | 2022-08-25 21:05:32.285729+03 | 2022-08-25 23:22:24.830829
DWH   | active               | ClientWrite |  47730267 | 2022-08-25 21:03:56.984189+03 | 2022-08-25 21:03:57.062329+03 | 2022-08-25 21:03:57.062329+03 | 2022-08-25 23:22:24.830829