gp_transaction_log

Post date: Jan 20, 2014 2:35:55 AM

gpadmin=# \d gp_transaction_log

View "pg_catalog.gp_transaction_log"

Column | Type | Modifiers

-------------+----------+-----------

segment_id | smallint |

dbid | smallint |

transaction | xid |

status | text |

View definition:

SELECT l.segment_id, l.dbid, l.transaction, l.status

FROM gp_transaction_log() l(segment_id smallint, dbid smallint, transaction xid, status text);

The gp_transaction_log view contains status information about transactions local to a particular segment. This view allows you to see the status of local transactions.