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.