Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ Schemas/ DBE_PERF Schema/ Utility/ GLOBAL_AIO_SLOT_USAGE_STATUS
Updated on 2024-06-03 GMT+08:00
View PDF
Share

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.
Parent topic: Utility