SUMMARY_FILE_IOSTAT
Records statistics about data file I/Os in the cluster to reflect performance issues such as exceptions in I/O operations.
| Name | Type | Description |
|---|---|---|
| filenum | oid | File ID. |
| dbid | oid | Database ID. |
| spcid | oid | Tablespace ID. |
| phyrds | numeric | Number of times of reading physical files. |
| phywrts | numeric | Number of times of writing into physical files. |
| phyblkrd | numeric | Number of times of reading physical file blocks. |
| phyblkwrt | numeric | Number of times of writing into physical file blocks. |
| readtim | numeric | Total duration of reading (unit: μs). |
| writetim | numeric | 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.
