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

PGXC_CLASS

PGXC_CLASS records replicated or distributed information for each table.

Table 1 PGXC_CLASS columns

Name

Type

Description

pcrelid

oid

OID of the table.

pclocatortype

"char"

Locator type.
  • H: Hash
  • G: Range
  • L: List
  • M: Modulo
  • N: Round Robin
  • R: Replication
  • U: MurmurHash

pchashalgorithm

smallint

Distributed tuple using the hash algorithm.

  • 1: default hash algorithm.
  • 2: MURMURHASH algorithm.

pchashbuckets

smallint

Value of a harsh container.

pgroup

name

Name of the node.

redistributed

"char"

Indicates that a table has been redistributed.

redis_order

integer

Redistribution sequence. Tables whose values are 0 will not be redistributed in this round of redistribution.

pcattnum

int2vector

Column number used as a distributed key.

nodeoids

oidvector_extend

List of distributed table node OIDs.

options

text

Extension status information. This is a reserved column in the system.

diskey

text

Character string of the distribution key expression in the brackets of the DISTRIBUTE BY clause in the SQL table creation statement. Currently, only MURMURHASH distribution is supported.

diskeyexprs

pg_node_tree

Character string information obtained by serializing diskey by using the pack_node_to_string() function.