Updated on 2024-05-07 GMT+08:00

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

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

Table 2 Columns in the User index IO activity table

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