Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

7.6 KiB

Raw Permalink Blame History

PG_POOLER_STATUS

PG_POOLER_STATUS displays the cache connection status in the pooler. PG_POOLER_STATUS can only query on the CN, and displays the connection cache information about the pooler module.

**Table 1** PG_POOLER_STATUS columns
Name	Type	Description
database	text	Database name
user_name	text	User name
tid	bigint	ID of a thread 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 in use t (true): indicates that the connection is in use. f (false): indicates that the connection is not in use.
fdsock	bigint	Peer socket.
remote_pid	bigint	Peer thread ID.
session_params	text	GUC session parameter delivered by the connection.

Parent topic: System Views

7.6 KiB Raw Permalink Blame History

PG_POOLER_STATUS

7.6 KiB

Raw Permalink Blame History