pg_statio_all_indexes
The pg_statio_all_indexes view will contain one row for each index in the current database, showing statistics about I/O on that specific index. The pg_statio_user_indexes and pg_statio_sys_indexes views contain the same information, but filtered to only show user and system indexes 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, indexrelid, schemaname, relname, indexrelname, idx_blks_read, idx_blks_hit
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_statio_all_indexes view will contain one row for each index in the current database, showing statistics about I/O on that specific index. The pg_statio_user_indexes and pg_statio_sys_indexes views contain the same information, but filtered to only show user and system indexes respectively.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| relid | oid | Nullable | OID of the table for this index |
| indexrelid | oid | Nullable | OID of this index |
| schemaname | name | Nullable | Name of the schema this index is in |
| relname | name | Nullable | Name of the table for this index |
| indexrelname | name | Nullable | Name of this index |
| idx_blks_read | bigint | Nullable | Number of disk blocks read from this index |
| idx_blks_hit | bigint | Nullable | Number of buffer hits in this index |
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:872b6c1c70959d3db4a06d5010ccdfc4beb761ee124748280e77e9058728251b
Text language: en · catalog-bilingual-repair:872b6c1c70959d3db4a06d5010ccdfc4beb761ee124748280e77e9058728251b