Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (8.1.3.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PGXC_COMM_CLIENT_INFO
Updated on 2023-04-14 GMT+08:00
View PDF
Share

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

Table 1 PGXC_COMM_CLIENT_INFO columns

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.
Parent topic: System Views