pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (7+ messages)

Message-ID: <20070911141344.GD26986@easy2.in-chemnitz.de>
Permalink:  ../20070911141344.GD26986@easy2.in-chemnitz.de/
Also on:    postgresql.org/message-id/20070911141344.GD26986@easy2.in-chemnitz.de

 · 

reply

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