STATISTICS VIEW · Statistics view

pg_statio_sys_tables

PostgreSQL documentation ↗Source definition ↗

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

First seen PG 9.0Last seen PG 19Columns 11

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_statio_sys_tables

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

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18
`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`
`stats_reset`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 19 ← 18

+ stats_reset

PostgreSQL 9.4 ← 9.3

2 column description updates

PostgreSQL 9.2 ← 9.1

Catalog description updated

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.