pg_statio_sys_tables

Same as pg_statio_all_tables, except that only system tables are shown.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

columns not enumerated: false
derived from: pg_statio_all_tables
kind: statistics
lang: en
measured attributes: false
metadata release: Unknown
runtime columns: relid, schemaname, relname, heap_blks_read, heap_blks_hit, idx_blks_read, idx_blks_hit, toast_blks_read, toast_blks_hit, tidx_blks_read, tidx_blks_hit
runtime verified: false
source: english-manual

Definition PG 18

Same as pg_statio_all_tables, except that only system tables are shown.

Column	Type	Nullability	Description
relid	oid	Nullable	OID of a table
schemaname	name	Nullable	Name of the schema that this table is in
relname	name	Nullable	Name of this table
heap_blks_read	bigint	Nullable	Number of disk blocks read from this table
heap_blks_hit	bigint	Nullable	Number of buffer hits in this table
idx_blks_read	bigint	Nullable	Number of disk blocks read from all indexes on this table
idx_blks_hit	bigint	Nullable	Number of buffer hits in all indexes on this table
toast_blks_read	bigint	Nullable	Number of disk blocks read from this table's TOAST table (if any)
toast_blks_hit	bigint	Nullable	Number of buffer hits in this table's TOAST table (if any)
tidx_blks_read	bigint	Nullable	Number of disk blocks read from this table's TOAST table indexes (if any)
tidx_blks_hit	bigint	Nullable	Number of buffer hits in this table's TOAST table indexes (if any)

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:5cbd52f0bfbde58f75948d85a7b5a3feac817e1396157236970a20ea4dea5138

Text language: en · catalog-bilingual-repair:5cbd52f0bfbde58f75948d85a7b5a3feac817e1396157236970a20ea4dea5138