Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ Utility/ GLOBAL_POOLER_STATUS

Updated on 2024-06-03 GMT+08:00

View PDF

GLOBAL_POOLER_STATUS

GLOBAL_POOLER_STATUS is used to query the cache connection status of the pooler modules on all CNs, as described in Table 1.

**Table 1** GLOBAL_POOLER_STATUS columns
Name	Type	Description
source_node_name	name	Source node name.
database	text	Database name.
user_name	text	Username.
tid	bigint	In non-thread pool logic, this parameter indicates the ID of the thread connected to the CN. In thread pool logic, this parameter indicates the ID of the session connected to the CN.
node_oid	bigint	OID of the node connected.
node_name	name	Name of the node connected.
in_use	boolean	Specifies whether the connection is currently used. t (true): The connection is in use. f (false): The connection is not in use.
local_host	text	Local IP address.
local_port	bigint	Local port number.
remote_host	text	IP address of the connected node.
node_port	integer	Port number of the node connected.
fdsock	bigint	Port file descriptor.
remote_pid	bigint	Thread ID of the remote node connected.
session_params	text	Session parameter.
used_count	bigint	Number of reuse times of a connection.
idx	bigint	Logical connection ID of the connected instance node.
streamid	bigint	Stream ID corresponding to each logical connection.