• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PV_FILE_STAT

PV_FILE_STAT

By collecting statistics about the data file I/O, PV_FILE_STAT indicates 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

ID of a database

spcid

oid

ID of a tablespace

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

writetim

bigint

Total duration of writing into files

avgiotim

bigint

Average duration of reading and writing into files

lstiotim

bigint

Duration of the last file reading

miniotim

bigint

Minimum duration of reading and writing into files

maxiowtm

bigint

Maximum duration of reading and writing into files