Help Center> GaussDB> Distributed_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 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

**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
Idx Blks Hit	Number of cache hits of all indexes