Postgres Pro
Downloads
Home   >   mailing lists

Long running transaction in pg_activity_log - Mailing list pgsql-performance

From Sachchida Ojha
Subject Long running transaction in pg_activity_log
Date
Msg-id E099DB9EF394534CBA0F62ED03CF3BBF0607772D@EXVS01.IceMAIL.com
Whole thread Raw
Responses Re: Long running transaction in pg_activity_log  ("Sachchida Ojha" <sojha@secure-elements.com>)
Re: Long running transaction in pg_activity_log  (Tobias Brox <tobias@nordicbet.com>)
List pgsql-performance
Tree view

I see some long running transaction in my pg_activity_log table. My app becomes almost unusable. My question is
How can I query the database to see what sql these transactions are running.

16385;"em_db";20893;16386;"em_user";"<IDLE> in transaction";f;"2007-08-22 20:38:06.527792+00";"2007-08-22 20:37:33.937193+00";"127.0.0.1";52466

16385;"em_db";15110;16386;"em_user";"<IDLE> in transaction";f;"2007-08-22 20:05:08.580643+00";"2007-08-22 19:39:11.670572+00";"127.0.0.1";50961

16385;"em_db";15113;16386;"em_user";"<IDLE> in transaction";f;"2007-08-22 20:06:01.53394+00";"2007-08-22 19:39:11.704564+00";"127.0.0.1";50964

Thanks
Regards
Sachi

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Fast tsearch2, trigram matching on short phrases
Next
From: "Sachchida Ojha"
Date:
Subject: Re: Long running transaction in pg_activity_log