posted Jan 19, 2014, 6:30 PM by Sachchida Ojha
gpadmin=# \d gp_distributed_xacts
View "pg_catalog.gp_distributed_xacts"
Column | Type | Modifiers
distributed_xid | xid |
distributed_id | text |
state | text |
gp_session_id | integer |
xmin_distributed_snapshot | xid |
View definition:
SELECT l.distributed_xid, l.distributed_id, l.state, l.gp_session_id, l.xmin_distributed_snapshot
FROM gp_distributed_xacts() l(distributed_xid xid, distributed_id text, state text, gp_session_id integer, xmin_distributed_snapshot xid);

The gp_distributed_xacts view contains information about Greenplum Database distributed transactions. A distributed transaction is a transaction that involves modifying data on the segment instances. Greenplum’s distributed transaction manager ensures that the segments stay in synch. This view allows you to see the currently active sessions and their associated distributed transactions.