Re: long running transactions - Mailing list pgsql-performance

From Tobias Brox
Subject Re: long running transactions
Date
Msg-id 20061010163913.GA8097@oppetid.no
Whole thread Raw
In response to Re: long running transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: long running transactions  (Tobias Brox <tobias@nordicbet.com>)
List pgsql-performance
[Tom Lane - Tue at 12:23:40PM -0400]
> Look in pg_locks to see the lowest-numbered transaction ID --- each
> transaction will be holding exclusive lock on its own XID.  You can
> correlate that back to pg_stat_activity via the PID.

Thanks a lot for the quick reply - I've already identified one
long-running transaction.

(I'm not allowed to order by xid, and not allowed to cast it to
anything, how come?)


pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Simple join optimized badly?
Next
From: Tobias Brox
Date:
Subject: Re: long running transactions