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.

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

Columns 5

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

Column	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
`relid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`schemaname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`relname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`blks_read`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`blks_hit`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`stats_reset`	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●

Version history 8

Definition snapshot: english-manuals:639017e954dbefc168e69d04534… · English manual source