Help Center/ GaussDB/ Centralized_2.x/ Schemas/ WDR Snapshot Schema/ WDRs/ Cache IO Stats

Updated on 2023-10-23 GMT+08:00

View PDF

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

**Table 1** Columns in the User table IO activity table
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

**Table 2** Columns in the User index IO activity table
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.