From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: Idle transactions
Date: Tue, 11 Sep 2007 16:13:44 +0200
Message-ID: <20070911141344.GD26986@easy2.in-chemnitz.de> (raw)
In-Reply-To: <fc61ha$o66$2@sea.gmane.org>
References: <fc5td9$o66$1@sea.gmane.org>
<20070911113928.GB26986@easy2.in-chemnitz.de>
<fc61ha$o66$2@sea.gmane.org>
On Tue, Sep 11, 2007 at 12:26:18PM +0000, Mateus Interciso wrote:
> Thanks for your reply.
> Is there any way on PostgreSQL that I can see the transaction that
> haven't been commited?
The following queries shows open transactions and locks held by the
transaction.
select c.relname,l.transaction,l.pid,l.granted,l.mode from pg_class
c,pg_locks l where l.relation = c.oid order by l.pid, l.mode;
HTH,
Tino.
--
www.spiritualdesign-chemnitz.de
www.lebensraum11.de
Tino Schwarze * Parkstraße 17h * 09120 Chemnitz
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-admin@postgresql.org
Cc: postgresql@tisc.de
Subject: Re: Idle transactions
In-Reply-To: <20070911141344.GD26986@easy2.in-chemnitz.de>
* 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