Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> Utility> GLOBAL_POOLER_STATUS

Updated on 2023-10-23 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.

**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	Whether the connection is currently used. t (true): The connection is in use. f (false): The connection is not in use.
fdsock	bigint	Port file descriptor
remote_pid	bigint	Thread ID of the remote node connected
session_params	text	Session parameter