The gp_distributed_log view contains status information about distributed transactions and their associated local transactions. A distributed transaction is a transaction that involves modifying data on the segment instances. Greenplum’s distributed transaction manager ensures that the segments stay in synch. This view allows you to see the status of distributed 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.
    distributed_xidxid The global transaction id.
    distributed_idtext A system assigned ID for a distributed transaction.
    statustext The status of the distributed transaction (Committed or Aborted).
    local_transactionxid The local transaction ID.

    Parent topic: System Catalogs Definitions