COMM_CLIENT_INFO
COMM_CLIENT_INFO displays information about active client connections of a single node (You can query this view on a DN to view the information about the connection between the CN and DN). By default, only users with the SYSADMIN permission can access this view.
| Name | Type | Description |
|---|---|---|
| node_name | text | Name of the current DN, for example, dn_6001_6002_6003. |
| app | text | Query a view on a DN. The app displays the client connected to the current DN, such as the coordinator (CN), GTM, or DN. |
| 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 | socket fd 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 | Displayed if the connection is a logical connection. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
