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

PGXC_GROUP

PGXC_GROUP records information about storage node groups.

Table 1 PGXC_GROUP columns

Name

Type

Description

oid

oid

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

group_name

name

Name of a node group.

in_redistribution

"char"

Specifies whether redistribution is required. Valid value:
  • n: The node group is not redistributed.
  • y: The source node group is in redistribution.
  • t: The destination node group is in redistribution.

group_members

oidvector_extend

Node OID list of the node group.

group_buckets

text

Distributed data bucket group.

is_installation

Boolean

Specifies whether to install a sub-cluster.

  • t (true): yes
  • f (false): no

group_acl

aclitem[]

Access permission.

group_kind

"char"

Node group type. The options are as follows:
  • i: installation node group
  • n: node group in a common cluster
  • e: elastic cluster

group_parent

oid

For a child node group, this field indicates the OID of the parent node group. For a parent node group, this field is left blank.

Parent topic:System Catalogs