PG_STATIO_ALL_TABLES

PG_STATIO_ALL_TABLES is used to query I/O statistics of each table (including TOAST tables) in the current database.

**Table 1** PG_STATIO_ALL_TABLES columns
Name	Type	Description
relid	oid	OID of a table.
schemaname	name	Name of the schema that this table is in.
relname	name	Table name.
heap_blks_read	bigint	Number of disk blocks read from this table.
heap_blks_hit	bigint	Number of cache hits in this table.
idx_blks_read	bigint	Number of disk blocks read from all indexes in this table.
idx_blks_hit	bigint	Number of cache hits of all indexes in this table.
toast_blks_read	bigint	Number of disk blocks read from TOAST tables (if any) in the table.
toast_blks_hit	bigint	Number of cache hits (if any) in the TOAST table of this table.
tidx_blks_read	bigint	Number of disk blocks read from the TOAST table indexes (if any) in the table.
tidx_blks_hit	bigint	Number of cache hits (if any) in the TOAST table indexes of this table.