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
pchashalgorithm	smallint	Distributed tuple using the hash algorithm.
pchashbuckets	smallint	Value of a harsh container.
pgroup	name	Node group name.
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.

Parent topic:System Catalogs

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.