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.

Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Kind: Statistics views
Columns in this snapshot: 5
Definition source: English manual
Metadata snapshot: 18.6

Columns 5

As listed in the PostgreSQL 18 manual.

Column	Type	Description / reference
`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

Column history across versions

relid

7.4 ?8.0 ?8.1 ?8.2 ?8.3 ?8.4 ?9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

schemaname

7.4 ?8.0 ?8.1 ?8.2 ?8.3 ?8.4 ?9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

relname

7.4 ?8.0 ?8.1 ?8.2 ?8.3 ?8.4 ?9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

blks_read

7.4 ?8.0 ?8.1 ?8.2 ?8.3 ?8.4 ?9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

blks_hit

7.4 ?8.0 ?8.1 ?8.2 ?8.3 ?8.4 ?9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

stats_reset

7.4 ?8.0 ?8.1 ?8.2 ?8.3 ?8.4 ?9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Version history 5

18 → 19 changed
12 → 13 reworded
9.1 → 9.2 reworded
8.4 → 9.0 columns not listed
8.0 → 8.1 reworded

Definition snapshot: english-manuals:74e764467614f09c1e778691cf1… · English manual source