Help Center > > Developer Guide> System Catalogs and System Views> System Views> PV_FILE_STAT

PV_FILE_STAT

Updated at: Dec 30, 2020 GMT+08:00

By collecting statistics about the data file I/Os, PV_FILE_STAT displays the I/O performance of the data to detect the performance problems, such as abnormal I/O operations.

Table 1 PV_FILE_STAT columns

Name

Type

Description

filenum

oid

File ID

dbid

oid

Database ID

spcid

oid

Tablespace ID

phyrds

bigint

Number of times of reading physical files

phywrts

bigint

Number of times of writing into physical files

phyblkrd

bigint

Number of times of reading physical file blocks

phyblkwrt

bigint

Number of times of writing into physical file blocks

readtim

bigint

Total duration of reading files. The unit is microsecond.

writetim

bigint

Total duration of writing files. The unit is microsecond.

avgiotim

bigint

Average duration of reading and writing files. The unit is microsecond.

lstiotim

bigint

Duration of the last file reading. The unit is microsecond.

miniotim

bigint

Minimum duration of reading and writing files. The unit is microsecond.

maxiowtm

bigint

Maximum duration of reading and writing files. The unit is microsecond.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel