Skip site navigation (1) Skip section navigation (2)

Re: Idle transactions

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Idle transactions
Date: 2007-09-11 14:13:44
Message-ID: 20070911141344.GD26986@easy2.in-chemnitz.de (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: Brian StaszewskiDate: 2007-09-11 16:31:46
Subject: Re: Close open transactions soon to avoid wraparound problems
Previous:From: Mateus IntercisoDate: 2007-09-11 13:43:59
Subject: Re: Idle transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group