From: | liam saffioti <liam(dot)saffiotti(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | postgresql statement problem |
Date: | 2022-08-25 20:31:31 |
Message-ID: | CAGHjuab0DACgd0EE8nvAYs7j+EYGTA3a8MtejnjeTM7mO26vcQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2022-08-25 20:39:46 | Re: postgresql statement problem |
Previous Message | liam saffioti | 2022-08-25 05:22:31 | Re: temp files size and count |