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
    segment_idsmallintgp_segment_configuration.contentThe content id of the segment. The master is always -1 (no content).
    dbidsmallintgp_segment_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