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

**Table 1** GLOBAL_AIO_SLOT_USAGE_STATUS columns
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.