↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / System Catalogs

pg_statio_sys_sequences

Same as pg_statio_all_sequences, except that only system sequences are shown. (Presently, no system sequences are defined, so this view is always empty.)

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

columns not enumerated
false
derived from
pg_statio_all_sequences
kind
statistics
lang
en
measured attributes
false
metadata release
Unknown
runtime columns
relid, schemaname, relname, blks_read, blks_hit
runtime verified
false
source
english-manual

Definition PG 18

Same as pg_statio_all_sequences, except that only system sequences are shown. (Presently, no system sequences are defined, so this view is always empty.)

Catalog columns

ColumnTypeNullabilityDescription
relidoidNullableOID of a sequence
schemanamenameNullableName of the schema this sequence is in
relnamenameNullableName of this sequence
blks_readbigintNullableNumber of disk blocks read from this sequence
blks_hitbigintNullableNumber of buffer hits in this sequence

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:9f499f9dbdc4c256303d06101b5055d2163440720c483f0d34327dd5f9c065e4

Text language: en · catalog-bilingual-repair:9f499f9dbdc4c256303d06101b5055d2163440720c483f0d34327dd5f9c065e4