Updated on 2025-07-15 GMT+08:00

SUMMARY_FILE_IOSTAT

Records statistics about data file I/Os in the cluster to reflect performance issues such as exceptions in I/O operations.

Table 1 SUMMARY_FILE_IOSTAT columns

Name

Type

Description

filenum

oid

File ID.

dbid

oid

Database ID.

spcid

oid

Tablespace ID.

phyrds

numeric

Number of times of reading physical files.

phywrts

numeric

Number of times of writing into physical files.

phyblkrd

numeric

Number of times of reading physical file blocks.

phyblkwrt

numeric

Number of times of writing into physical file blocks.

readtim

numeric

Total duration of reading (unit: μs).

writetim

numeric

Total duration of writing (unit: μs).

avgiotim

bigint

Average duration of reading and writing (unit: μs).

lstiotim

bigint

Duration of the last file reading (unit: μs).

miniotim

bigint

Minimum duration of reading and writing (unit: μs).

maxiowtm

bigint

Maximum duration of reading and writing (unit: μs).