gp_transaction_log

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.

Table 1. pg_catalog.gp_transaction_log
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 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).