Cache IO Stats
The Cache IO Stats report consists of two tables, namely, User table IO activity and User index IO activity. Columns in the tables are described as follows:
User table IO activity
| Column | Description |
|---|---|
| Node Name | Node name. |
| DB Name | Database name |
| Schema Name | Schema name |
| Table Name | Table name |
| %Heap Blks Hit Ratio | Buffer pool hit ratio of the table |
| Heap Blks Read | Number of disk blocks read from the table |
| Heap Blks Hit | Number of cache hits in the table |
| Idx Blks Read | Number of disk blocks read from all indexes in the table |
| Idx Blks Hit | Number of cache hits of all indexes in the table |
| Toast Blks Read | Number of disk blocks read from the TOAST table (if any) in the table |
| Toast Blks Hit | Number of buffer hits in the TOAST table (if any) in the table |
| Tidx Blks Read | Number of disk blocks read from the TOAST table index (if any) in the table |
| Tidx Blks Hit | Number of buffer hits in the TOAST table index (if any) in the table |
User index IO activity
| Column | Description |
|---|---|
| Node Name | Node name. |
| DB Name | Database name |
| Schema Name | Schema name |
| Table Name | Table name |
| Index Name | Index name |
| %Idx Blks Hit Ratio | Index hit ratio |
| Idx Blks Read | Number of disk blocks read from all indexes |
| Idx Blks Hit | Number of cache hits of all indexes |
