GLOBAL_AIO_SLOT_USAGE_STATUS
GLOBAL_AIO_SLOT_USAGE_STATUS displays statistics about asynchronous I/O commit slots in all cluster instances, as described in Table 1. The view needs to be queried on a CN. An error is reported when the view is queried on a DN.
| Parameter | Type | Description |
|---|---|---|
| node_name | text | Instance name. |
| slot_id | integer | Slot ID. |
| slot_type | "char" | Slot type. The value can be r (read) or w (write). |
| status | boolean | Slot usage status. |
| buffer_id | bigint | Buffer ID corresponding to the slot. |
| relfilenode_blocknum | text | Position of the physical page where the buffer corresponding to the slot is located. |
| lsn | bigint | LSN corresponding to the page. |
| submitted_time | bigint | Time when a page is committed asynchronously. |
| elapsed_time | bigint | Waiting time of the page. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
