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.
Column | Type | Description |
|---|---|---|
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 |
node_name | Name | Name of the node connected |
in_use | boolean | Whether the connection is in use. The options are:
|
fdsock | Bigint | Peer socket |
remote_pid | Bigint | Peer thread ID |
session_params | Text | GUC session parameter delivered by the connection |
Example¶
View information about the connection pool pooler:
select database,user_name,node_name,in_use,count(*) from pg_pooler_status group by 1, 2, 3 ,4 order by 5 desc limit 50;
database | user_name | node_name | in_use | count
----------+-----------+--------------+--------+-------
mydbdemo | user3 | cn_5001 | f | 2
mydbdemo | user3 | dn_6005_6006 | t | 2
mydbdemo | user3 | dn_6001_6002 | t | 2
mydbdemo | user3 | dn_6003_6004 | f | 2
mydbdemo | user3 | dn_6003_6004 | t | 2
mydbdemo | user3 | dn_6005_6006 | f | 2
mydbdemo | user3 | dn_6001_6002 | f | 2
mydbdemo | user3 | cn_5002 | f | 2
gaussdb | user3 | dn_6003_6004 | f | 1
mydbdemo | user3 | cn_5001 | t | 1
music | user2 | dn_6003_6004 | f | 1
music | user2 | dn_6005_6006 | f | 1
gaussdb | user1 | dn_6005_6006 | f | 1
(13 rows)