Help Center> GaussDB> Distributed_2.x> Schemas> DBE_PERF Schema> File> SUMMARY_FILE_IOSTAT

Updated on 2023-10-23 GMT+08:00

View PDF

SUMMARY_FILE_IOSTAT

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 identifier
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)