Help Center/ GaussDB/ 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.