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.

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.