Re: [GENERAL] How to find out PIDs of transactions older than the current?

2014-04-25 Thread Torsten Förtsch
On 25/04/14 13:26, Torsten Förtsch wrote: > I think I can find out the transaction ids of concurrent transactions > older than the current one by: > > select * from txid_snapshot_xip(txid_current_snapshot()) > union > select * from txid_snapshot_xmax(txid_current_snapshot()); > > Now, I wan

[GENERAL] How to find out PIDs of transactions older than the current?

2014-04-25 Thread Torsten Förtsch
Hi, I think I can find out the transaction ids of concurrent transactions older than the current one by: select * from txid_snapshot_xip(txid_current_snapshot()) union select * from txid_snapshot_xmax(txid_current_snapshot()); Now, I want to map these transaction ids to backend process ids