gp_transaction_log

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.

columntypereferencesdescription
segmentidsmallintgp_segment configuration.contentThe content id if the segment. The master is always -1 (no content).
dbidsmallintgpsegment configuration.dbidThe unique id of the segment instance.
transactionxid The local transaction ID.
statustext The status of the local transaction (Committed or Aborted).

Parent topic: System Catalogs Definitions