pg_statio_all_sequences — PostgreSQL statistics view

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_statio_all_sequences statistics view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

• relid oid
  OID of a sequence
• schemaname name
  Name of the schema this sequence is in
• relname name
  Name of this sequence
• blks_read bigint
  Number of disk blocks read from this sequence
• blks_hit bigint
  Number of buffer hits in this sequence
• stats_reset timestamp with time zone
  Time at which these statistics were last reset

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

• PostgreSQL system catalog & view index
• Built-in function reference

Reference: PostgreSQL documentation — pg_statio_all_sequences.