Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ Appendix/ WDRs/ Cache IO Stats
Updated on 2024-06-03 GMT+08:00
View PDF
Share

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 in Table 1 and Table 2.

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 in 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.
Parent topic: WDRs