gp_transaction_log
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.
| 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 |
transaction |
xid |
— |
The local transaction ID |
status |
text |
— |
The status of the local transaction ( |