posted Jan 19, 2014, 6:35 PM by Sachchida Ojha
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.