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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot