GLOBAL_FILE_IOSTAT
Displays the data file I/O statistics of all nodes in the database.
Name |
Type |
Description |
---|---|---|
node_name |
name |
Node name. |
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 (unit: μs). |
writetim |
bigint |
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). |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.