From: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
To: Sachchida Ojha <sojha@secure-elements.com>
To: pgsql-performance@postgresql.org
Subject: Re: Long running transaction in pg_activity_log
Date: Wed, 22 Aug 2007 21:58:40 +0000 (GMT)
Message-ID: <819574.20445.qm@web26304.mail.ukl.yahoo.com> (raw)
If I am not wrong, you must be asking about this:
select * from pg_stat_activity;
If you see <command string
not enabled> in the query column.
Turn on the stats_command_string option in postgresql.conf.
Regards,
Farhan
----- Original Message ----
From: Sachchida Ojha <sojha@secure-elements.com>
To: pgsql-performance@postgresql.org
Sent: Thursday, 23 August, 2007 1:40:09 AM
Subject: [PERFORM] Long running transaction in pg_activity_log
Long running transaction in pg_activity_log
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
___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: farhanhafeezmughal@yahoo.co.uk, sojha@secure-elements.com
Subject: Re: Long running transaction in pg_activity_log
In-Reply-To: <819574.20445.qm@web26304.mail.ukl.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox