Does long running query cause replication delay in PostgreSQL which is in 'idle in transaction' state?
0
votes
1
answer
384
views
In my system I found same query called more than 30 times '**idle in transaction**' state. Is there any way to to identify the reason of 'idle in transaction'? Should I terminate those query manually using pg_terminate_backend() or set **idle_in_transaction_session_timeout to 5min** in case of high TPS DB.
I think there is no meaning to ideal any query more than 24hr. But there I found it is more than 7 days.
Query below:
> SELECT current_setting('transaction_isolation');
> Query Output: read committed
How to debug in those type of issue to identify actual cause of 'idle in transaction'?
Asked by Sheikh Wasiu Al Hasib
(283 rep)
Apr 17, 2024, 09:37 AM
Last activity: May 2, 2025, 08:02 PM
Last activity: May 2, 2025, 08:02 PM