SYSTEM VIEW · System view

pg_sequences

The view pg_sequences provides access to useful information about each sequence in the database.

First seen PG 10Last seen PG 19Columns 11

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_sequences

COLUMN	TYPE	DESCRIPTION
`schemaname`	`name`	Name of schema containing sequenceReferences:`pg_namespace.nspname`
`sequencename`	`name`	Name of sequenceReferences:`pg_class.relname`
`sequenceowner`	`name`	Name of sequence's ownerReferences:`pg_authid.rolname`
`data_type`	`regtype`	Data type of the sequenceReferences:`pg_type.oid`
`start_value`	`bigint`Documented as:`int8`	Start value of the sequence
`min_value`	`bigint`Documented as:`int8`	Minimum value of the sequence
`max_value`	`bigint`Documented as:`int8`	Maximum value of the sequence
`increment_by`	`bigint`Documented as:`int8`	Increment value of the sequence
`cycle`	`boolean`Documented as:`bool`	Whether the sequence cycles
`cache_size`	`bigint`Documented as:`int8`	Cache size of the sequence
`last_value`	`bigint`Documented as:`int8`	The last sequence value written to disk. If caching is used, this value can be greater than the last value handed out from the sequence.

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6
`schemaname`	–	–	–	–	–	–	–
`sequencename`	–	–	–	–	–	–	–
`sequenceowner`	–	–	–	–	–	–	–
`data_type`	–	–	–	–	–	–	–
`start_value`	–	–	–	–	–	–	–
`min_value`	–	–	–	–	–	–	–
`max_value`	–	–	–	–	–	–	–
`increment_by`	–	–	–	–	–	–	–
`cycle`	–	–	–	–	–	–	–
`cache_size`	–	–	–	–	–	–	–
`last_value`	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 15 ← 14

1 column description updates

PostgreSQL 10 ← 9.6Catalog added

+ schemaname+ sequencename+ sequenceowner+ data_type+ start_value+ min_value+ max_value+ increment_by+ cycle+ cache_size+ last_value

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.