Cache IO Stats
Cache IO Stats contains two tables: User table and User index. The columns in the tables are described as follows.
User table IO activity ordered by heap blks hit ratio
Table 1 Columns in the User table IO activity ordered by heap blks hit ratio report
Column | Description |
---|
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 on the table. |
Idx Blks Hit | Number of cache hits 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 ordered by idx blks hit ratio
Table 2 Columns in the User index IO activity ordered by idx blks hit ratio report
Column | Description |
---|
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 on the table. |
Idx Blks Hit | Number of cache hits in the table. |
openGauss 2024-09-07 01:01:32