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

GS_SLICEGROUP

GS_SLICEGROUP records information about slice groups created in the current database.

Table 1 GS_SLICEGROUP columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

slicename

name

Name of a slice group or slice, which is distinguished by type.

type

"char"

Object type.

  • 't': slice group.
  • 's': slice.

strategy

"char"

Distribution policy.

  • 'r': range distribution.

bucketgroup

smallint

Bucket group to which the bucket allocated to a slice group belongs (value range: [1,4]).

bucketcnt

integer

Total number of buckets allocated to a slice group.

sgroupoid

oid

Slice group OID.

sindex

integer

Reserved column. A slice index is recorded when a single slice is distributed to multiple DNs.

nodeid

integer

Index of a DN to which a slice is distributed.

redis_nodeid

smallint

Reserved column. This column is used as the default value on a DN. On a CN, this column specifies the index of a DN to which the current slice's bucket is to be migrated during scaling.

bucket

smallint

Bucket to which a slice is distributed.

slicecnt

integer

Total number of slices in the current slice group. If the object is a slice, the default value -1 is used.

contained

boolean
Specifies whether the DN manages the bucket to which a slice is distributed.
  • t (true): yes.
  • f (false): no.

The default value is f on a CN.

specified

boolean
Specifies whether a DN is specified for a slice.
  • t (true): yes.
  • f (false): no.

sliceorder

integer

Position of a slice in a slice group.

boundaries

text[]

Value range of a slice.

bucketversion

integer

Records the version number of the information that changes during subsequent range bucket scale-out.

bucketcsn

xid

Maximum CSN of each bucket on the source node before redistribution, which is used to determine the visibility of the new node.

bucketxid

xid

next_xid set for bringing a new node online during scaling, which is used to check whether the value is within the threshold range.

distributetype

oidvector

OID of the range distribution key type specified by a slice group.
Parent topic: Other System Catalogs