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.
Greengage DB’s distributed transaction manager ensures that the segments stay in sync.
| Column | Type | References | Description |
|---|---|---|---|
segment_id |
smallint |
gp_segment_configuration.content |
The content ID of the segment.
The master is always |
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 (only |
local_transaction |
xid |
— |
The local transaction ID |