GLOBAL_FILE_IOSTAT
Displays statistics about data file I/Os on all nodes.
|
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.