Updated on 2025-08-25 GMT+08:00

PGXC_GROUP

PGXC_GROUP stores node group information. In the decoupled storage-compute 3.0 version, each logical cluster node group is referred to as a virtual warehouse (VW), while at the storage KV layer, each VW corresponds to a vgroup.

Table 1 PGXC_GROUP columns

Column

Type

Description

group_name

name

Name of the node group.

in_redistribution

"char"

Whether redistribution is required. Options:

  • n indicates that the NodeGroup is not redistributed.
  • y indicates the source NodeGroup in redistribution.
  • t indicates the destination NodeGroup in redistribution.
  • s indicates that the NodeGroup will skip redistribution.

group_members

oidvector_extend

List of node OIDs in the node group.

group_buckets

text

Collection of distributed data buckets.

is_installation

Boolean

Whether to install a sub-cluster.

group_acl

aclitem[]

Access permissions.

group_kind

"char"

Node group type. Options:

  • i indicates the installation node group, containing all DNs.
  • n indicates a regular non-logical cluster node group.
  • v indicates a logical cluster node group.
  • e indicates an elastic cluster node group.
  • r indicates a replicated table node group, exclusively for creating replicated tables, which may include one or multiple logical cluster node groups.

group_ckpt_csn

xid

CSN of the most recent incremental extraction executed by the node group.

vgroup_id

xid

ID of the vgroup corresponding to the node group.

vgroup_bucket_count

oid

Number of buckets in the vgroup corresponding to the node group.

group_ckpt_time

timestamp with time zone

Physical time of the most recent incremental extraction executed by the node group.

apply_kv_duration

integer

Duration of the incremental scan in the most recent incremental extraction executed by the node group (in seconds).

ckpt_duration

integer

Checkpoint duration in the most recent incremental extraction executed by the node group (in seconds).