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.

column type references description
segmentid smallint gp_segment configuration.content The content id if the segment. The master is always -1 (no content).
dbid smallint gpsegment configuration.dbid The unique id of the segment instance.
transaction xid The local transaction ID.
status text The status of the local transaction (Committed or Aborted).

Parent topic: System Catalogs Definitions