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.
| Name | 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:
1 | 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; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
