gp_distributed_log

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 if the segment. The master is always -1 (no content).
dbid small_int 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