PG_POOLER_STATUS

PG_POOLER_STATUS queries the cache connection status in the pooler.

**Table 1** PG_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 connected instance node
fdsock	bigint	Peer socket
remote_pid	bigint	Peer thread ID
session_params	text	GUC session parameter delivered by the connection
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.