PGXC_POOLER_STATUS

PGXC_POOLER_STATUS displays the pooler cache connection status of each CN in the current cluster. This view can be queried only on CNs to display the connection cache information of the pooler module on all CNs. The PGXC_POOLER_STATUS view is supported only by clusters of version 8.2.1.300 or later.

**Table 1** PGXC_POOLER_STATUS columns
Column	Type	Description
coorname	text	Name of the CN node.
database	text	Database name.
user_name	text	Username.
tid	bigint	ID of the thread used for the connection to the CN.
node_oid	bigint	OID of the node connected to.
node_name	name	Name of the node connected to.
in_use	boolean	Whether the connection is currently in use. The options are: t (true): The connection is in use. f (false): The connection is not in use.
fdsock	bigint	Peer socket.
remote_pid	bigint	Peer thread ID.
session_params	text	GUC session parameters issued by this connection.