PGXC_GROUP
PGXC_GROUP records information about node groups. The PGXC_GROUP system catalog has specific meanings only in distributed scenarios. openGauss can only query the table definition.
Table 1 PGXC_GROUP columns
| Name | Type | Description | 
|---|
| oid | oid | Row identifier (hidden attribute, which must be specified) | 
| group_name | name | Node group name | 
| in_redistribution | "char" | Whether redistribution is required. The value must be one of the following: 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 | Whether to install a sub-cluster t (true): yesf (false): no
 | 
| group_acl | aclitem[] | Access permission | 
| group_kind | "char" | Node group type. The value must be one of the following: i: installation node groupn: node group in a common non-logical clusterv: node group in a logical clustere: 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. | 
openGauss 2025-10-31 07:42:18