Updated on 2024-03-14 GMT+08:00

PGXC_GROUP

PGXC_GROUP records node group information. In DWS 3.0, each node group in a logical cluster is called a VW. At the storage KV layer, each VW corresponds to a vgroup.

Table 1 PGXC_GROUP columns

Column

Type

Description

group_name

name

Specifies the name of a node group.

in_redistribution

"char"

Whether redistribution is required.

  • n indicates that the Node Group is not redistributed.
  • y indicates the source Node Group in redistribution.
  • t indicates the destination Node Group in redistribution.

group_members

oidvector_extend

DN node OID list of in a node group

group_buckets

text

Distributed data bucket group

is_installation

boolean

Indicates whether the node group is an installation node group.

group_acl

aclitem[]

Access permissions

group_kind

"char"

Node group type.

  • i indicates the installation node group, which contains all DNs.
  • n indicates a common non-logical cluster node group.
  • v indicates a logical cluster node group.
  • e indicates the elastic cluster node group.
  • r indicates a replication table node group, which can only be used to create replication tables and can contain one or more logical cluster node groups.

group_ckpt_csn

xid

CSN of the last incremental extraction performed on a 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 when the last incremental extraction is performed on a node group.

apply_kv_duration

integer

Duration of incremental scanning in the last incremental extraction of a node group, in seconds.

ckpt_duration

integer

Checkpoint duration in the last incremental extraction of a node group, in seconds.

group_flags

integer

Node group flag. Currently, only the first flag is valid. Other flags are not used in the current version.

  • Flag 1: If the value is 1, the node group is a read-only logical cluster. If the value is 0, the node group is a read-write logical cluster.