pg_statio_all_tables

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.

Kind: Statistics views
Columns in this snapshot: 11
Definition source: English manual

Columns 11

Column	Type	Description / reference
`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)

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`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`	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●

Version history 8

Definition snapshot: english-manuals:8ee0e69c8372f54a2c6ce491b6d… · English manual source