Skip site navigation (1) Skip section navigation (2)

Long running transaction in pg_activity_log

From: "Sachchida Ojha" <sojha(at)secure-elements(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Long running transaction in pg_activity_log
Date: 2007-08-22 20:40:09
Message-ID: E099DB9EF394534CBA0F62ED03CF3BBF0607772D@EXVS01.IceMAIL.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Oleg BartunovDate: 2007-08-22 20:43:07
Subject: Re: Fast tsearch2, trigram matching on short phrases
Previous:From: Carlo StonebanksDate: 2007-08-22 20:31:08
Subject: Re: Fast tsearch2, trigram matching on short phrases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group