PGXC_COMM_CLIENT_INFO
PGXC_COMM_CLIENT_INFO stores the client connection information of all nodes. (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.