Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 872919F994D for ; Tue, 11 Sep 2007 11:13:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 40095-08 for ; Tue, 11 Sep 2007 11:13:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id B88F89F9767 for ; Tue, 11 Sep 2007 11:13:45 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 5BB53B1F7D for ; Tue, 11 Sep 2007 16:13:44 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ob9m1DOsBRC8 for ; Tue, 11 Sep 2007 16:13:44 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 43839B1F28; Tue, 11 Sep 2007 16:13:44 +0200 (CEST) Date: Tue, 11 Sep 2007 16:13:44 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Idle transactions Message-ID: <20070911141344.GD26986@easy2.in-chemnitz.de> References: <20070911113928.GB26986@easy2.in-chemnitz.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/64 X-Sequence-Number: 26825 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