gp_distributed_xacts

Post date: Jan 20, 2014 2:30:49 AM

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.