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