PG_COMM_CLIENT_INFO
PG_COMM_CLIENT_INFO stores the client connection information of a single node. (You can query this view on a DN to view the information about the connection between the CN and DN.)
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        node_name  | 
      
        Text  | 
      
        Current node name.  | 
     
| 
        app  | 
      
        Text  | 
      
        Client application name  | 
     
| 
        tid  | 
      
        Bigint  | 
      
        Thread ID of the current thread.  | 
     
| 
        lwtid  | 
      
        Integer  | 
      
        Lightweight thread ID of the current thread.  | 
     
| 
        query_id  | 
      
        Bigint  | 
      
        Query ID. It is equivalent to debug_query_id.  | 
     
| 
        socket  | 
      
        Integer  | 
      
        It is displayed if the connection is a physical connection.  | 
     
| 
        remote_ip  | 
      
        Text  | 
      
        Peer node IP address.  | 
     
| 
        remote_port  | 
      
        Text  | 
      
        Peer node port.  | 
     
| 
        logic_id  | 
      
        Integer  | 
      
        If the connection is a logical connection, sid is displayed. If -1 is displayed, the current connection is a physical connection.  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.