Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> PG_POOLER_STATUS
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 | 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
|
| fdsock | bigint | Peer socket. |
| remote_pid | bigint | Peer thread ID. |
| session_params | text | GUC session parameter delivered by the connection. |
Parent topic: System Views
Last Article: PG_OS_THREADS
Next Article: PG_PREPARED_STATEMENTS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.