pg_statio_all_sequences
The pg_statio_all_sequences view will contain one row for each sequence in the current database, showing statistics about I/O on that specific sequence.
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, blks_read, blks_hit
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_statio_all_sequences view will contain one row for each sequence in the current database, showing statistics about I/O on that specific sequence.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| relid | oid | Nullable | OID of a sequence |
| schemaname | name | Nullable | Name of the schema this sequence is in |
| relname | name | Nullable | Name of this sequence |
| blks_read | bigint | Nullable | Number of disk blocks read from this sequence |
| blks_hit | bigint | Nullable | Number of buffer hits in this sequence |
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:34179042536dbe53aaaaa32107f88a060be954c4ab6f664d13d5135a1871cb4c
Text language: en · catalog-bilingual-repair:34179042536dbe53aaaaa32107f88a060be954c4ab6f664d13d5135a1871cb4c