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. 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.
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
- kind
- statistics
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- 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
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.
Catalog columns
| 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) |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:2b1bb5ddf19a3a78c38e8eac860166554c484d56825f4da372a52c01ddb4fa7e
Text language: en · catalog-bilingual-repair:2b1bb5ddf19a3a78c38e8eac860166554c484d56825f4da372a52c01ddb4fa7e