Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ Utility/ POOLER_STATUS
Updated on 2024-06-03 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, as described in Table 1.

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
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 node connected.

node_port

integer

Port number of the node connected.

fdsock

bigint

Port file descriptor.

remote_pid

bigint

If the peer site is not in the thread pool logic, the value is the thread ID of the peer site. If the peer site is in the thread pool logic, the value is the session ID of the peer site.

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