Updated on 2024-05-07 GMT+08:00

COMM_CLIENT_INFO

COMM_CLIENT_INFO displays information about active client connections of a single node (Query the display of the view on DNs and CNs connect information on DNs). By default, only the users with system administrator permission can access this view.

Table 1 COMM_CLIENT_INFO columns

Name

Type

Description

node_name

text

Name of the current DN, for example, dn_6001_6002_6003.

app

text

Query a view on a DN. The app displays the client connected to the current DN, such as the coordinator (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

socket fd 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

Displayed if the connection is a logical connection.