PGXC_RUNNING_XACTS
PGXC_RUNNING_XACTS displays information about running transactions on each node in the cluster. The content is the same as that displayed in PG_RUNNING_XACTS.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        handle  | 
      
        Integer  | 
      
        Handle corresponding to the transaction in GTM  | 
     
| 
        gxid  | 
      
        Xid  | 
      
        Transaction ID  | 
     
| 
        state  | 
      
        tinyint  | 
      
        Transaction status (3: prepared or 0: starting)  | 
     
| 
        node  | 
      
        Text  | 
      
        Node name  | 
     
| 
        xmin  | 
      
        Xid  | 
      
        Minimum transaction ID xmin on the node  | 
     
| 
        vacuum  | 
      
        boolean  | 
      
        Whether the current transaction is lazy vacuum  | 
     
| 
        timeline  | 
      
        Bigint  | 
      
        Number of database restarts  | 
     
| 
        prepare_xid  | 
      
        Xid  | 
      
        Transaction ID in prepared state. If the status is not prepared, the value is 0.  | 
     
| 
        pid  | 
      
        Bigint  | 
      
        Thread ID corresponding to the transaction  | 
     
| 
        next_xid  | 
      
        Xid  | 
      
        Transaction ID sent from a CN to a DN  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.