Updated on 2023-04-14 GMT+08:00

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.