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
    segment_id smallint gp_segment_configuration.content The content id of the segment. The master is always -1 (no content).
    dbid smallint gp_segment_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