我的书签
添加书签
移除书签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 |
|---|---|---|---|
segmentid | smallint | gp_segment configuration.content | The content id if 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
