Skip to content
← Catalog atlas / pg_statio_all_tables

STATISTICS VIEW · Statistics view

pg_statio_all_tables

PostgreSQL documentation ↗Source definition ↗

The pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specific table. The pg_statio_user_tables and pg_statio_sys_tables views contain the same information, but filtered to only show user and system tables respectively.

First seen PG 9.0Last seen PG 19Columns 11
9.09.19.29.39.49.59.610111213141516171819β3

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

Columns PostgreSQL 18

pg_statio_all_tables
COLUMNTYPEDESCRIPTION
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
COLUMN9.09.19.29.39.49.59.610111213141516171819
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 13 ← 12

Catalog description updated

PostgreSQL 12 ← 11

Catalog description updated

PostgreSQL 10 ← 9.6

Catalog description updated

PostgreSQL 9.6 ← 9.5

Catalog description updated

PostgreSQL 9.5 ← 9.4

Catalog description updated

PostgreSQL 9.4 ← 9.3

2 column description updatesCatalog description updated

PostgreSQL 9.2 ← 9.1

Catalog description updated

Compare any two versions

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