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: (view raw or whole 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

select c.relname,l.transaction,,l.granted,l.mode from pg_class
c,pg_locks l where l.relation = c.oid order by, l.mode;




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-2015 The PostgreSQL Global Development Group