Updated on 2023-10-23 GMT+08:00

GLOBAL_COMM_CLIENT_INFO

GLOBAL_COMM_CLIENT_INFO queries information about active client connections of global nodes in a cluster. By default, only the system administrator has the permission to access this system view.

Table 1 GLOBAL_COMM_CLIENT_INFO columns

Name

Type

Description

node_name

text

Current node name.

app

text

app

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

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.