gp_transaction_log

This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.

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).