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.)
Name | 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. |