Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Communications> GLOBAL_COMM_CLIENT_INFO
Updated on 2024-06-03 GMT+08:00
View PDF

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

Client that connects to the current DN, such as a CN, GTM, or DN.

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