Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> Utility> POOLER_STATUS
Updated on 2023-10-23 GMT+08:00
View PDF

POOLER_STATUS

POOLER_STATUS is used to query the cache connection status of the pooler module on the local CN.

Table 1 POOLER_STATUS columns

Name

Type

Description

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.

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
Parent topic: Utility