Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Schemas/ DBE_PERF Schema/ Utility/ GLOBAL_AIO_SLOT_USAGE_STATUS

Updated on 2024-06-03 GMT+08:00

View PDF

GLOBAL_AIO_SLOT_USAGE_STATUS

GLOBAL_AIO_SLOT_USAGE_STATUS displays statistics about asynchronous I/O commit slots in all database instances, as described in Table 1.

**Table 1** GLOBAL_AIO_SLOT_USAGE_STATUS columns
Name	Type	Description
node_name	text	Instance name.
slot_id	int4	Slot ID.
slot_type	char	Slot type. The value can be r (read) or w (write).
status	bool	Slot usage status.
buffer_id	int8	Buffer ID corresponding to the slot.
relfilenode_blocknum	text	Position of the physical page where the buffer corresponding to the slot is located.
lsn	int8	LSN corresponding to the page.
submitted_time	int8	Time when a page is committed asynchronously.
elapsed_time	int8	Waiting time of the page.

Parent topic: Utility

Previous topic: GLOBAL_ADIO_COMPLETER_STATUS

Next topic: Lock

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.