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 -1 (no content).
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 (Committed or Aborted).

Parent topic: System Catalogs Definitions

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