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.

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.
distributed_xid xid   The global transaction id.
distributed_id text   A system assigned ID for a distributed transaction.
status text   The status of the distributed transaction (Committed or Aborted).
local_transaction xid   The local transaction ID.

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon