Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ MY_SEQUENCES
Updated on 2025-08-19 GMT+08:00
View PDF

MY_SEQUENCES

MY_SEQUENCES displays the sequence information about the current user. This view exists in both PG_CATALOG and SYS schemas. For details about the columns, see Table 1.

Table 1 MY_SEQUENCES columns

Name

Type

Description

sequence_owner

name

Owner of a sequence.

sequence_name

name

Name of a sequence.

min_value

int16

Minimum value of a sequence.

max_value

int16

Maximum value of a sequence.

increment_by

int16

Value by which the sequence is incremented.

cycle_flag

character(1)
Specifies whether a sequence is a cycle sequence. The options are as follows:
  • Y: It is a cycle sequence.
  • N: It is not a cycle sequence.

order_flag

character varying(1)

Specifies whether a sequence occurs in a request sequence. This parameter is not supported. Set it to NULL.

cache_size

int16

Size of the sequence disk cache.

last_number

int16

Last value of the sequence allocated in a batch from the GTM at a time.

scale_flag

character varying(1)

Specifies whether a sequence is a scalable sequence. This parameter is not supported. Set it to NULL.

extend_flag

character varying(1)

Specifies whether the value generated by a scalable sequence exceeds the maximum or minimum value of the sequence. Not supported. The value is NULL.

sharded_flag

character varying(1)

Specifies whether a sequence is a shard sequence. Not supported. The value is NULL.

session_flag

character varying(1)

Specifies whether a sequence has a private session. This is not supported. The value is NULL.

keep_value

character varying(1)

Specifies whether to retain the sequence value during replay after a failure. Not supported. The value is NULL.
Parent topic: Other System Views