Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ Utility/ GLOBAL_ADIO_COMPLETER_STATUS

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

View PDF

GLOBAL_ADIO_COMPLETER_STATUS

GLOBAL_ADIO_COMPLETER_STATUS displays statistics about the AIO Completer thread 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_ADIO_COMPLETER_STATUS columns
Parameter	Type	Description
node_name	text	Instance name.
tid	bigint	ID of the AIO Completer thread.
thread_type	text	AIO Completer thread type (read or write).
aio_submitted_num	bigint	Number of committed asynchronous I/O requests of the AIO Completer thread.
aio_completed_num	bigint	Number of completed asynchronous I/O requests of the AIO Completer thread.
aio_incompleted_num	bigint	Number of asynchronous I/O requests that are not completed of the AIO Completer thread.
slot_count_left	bigint	Indicates the number of idle slots.