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
[Sachchida Ojha - Wed at 04:40:09PM -0400]
> 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.
" in transaction" means that no sql query is running at
hida
Ojha
Sent: Wednesday, August 22, 2007 4:40 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] 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
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";" in
transaction";f;"2007-08-22 20:38:06.527792+00";"2007-08-22
20:37: