postgresql statement problem

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

Responses

Browse pgsql-admin by date

  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