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

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