Updated on 2023-10-23 GMT+08:00

PGXC_REDISTB

PGXC_REDISTB is created during scale-out for each database to record the redistribution status of user tables. It will be deleted after scale-out. Only users with the connect permission can view the information.

Table 1

Name

Type

Description

relname

name

Name of a user table.

nspname

name

Name of the tablespace that contains the table.

pcrelid

oid

OID of a table.

pclocatortype

character

Locator type.

H: hash

M: Modulo

N: Round Robin

R: Replicate

pchashalgorithm

smallint

Distributed tuple using the hash algorithm.

pchashbuckets

smallint

Value of a harsh container.

pgroup

name

Node group to which a table belongs.

redistributed

character

Catalog status.

i: Table is being redistributed.

y: Table redistribution is complete.

n: Table has not been redistributed.

d: The redistribution is complete, but the temporary table has not been deleted.

redis_order

interger

Table redistribution sequence. The default value is 1024. The value 0 indicates that the table is not redistributed. A smaller value indicates that the table is redistributed first.

pcattnum

int2vector

Column number used as a distribution key.

nodeoids

oidvector_extend

Node ID of the node group where the table is located.

internal_mask

integer

Whether reloption contains internal information. Values are as follows:

0X0: The internal mask is disabled.

0X8000: The internal mask is enabled.

0X01: The insert operation is not allowed in this table.

0X02: The delete operation is not allowed in this table.

0X04: The alter operation is not allowed in this table.

0X08: The select operation is not allowed in this table.

0X0100: The update operation is not allowed in this table.

table_size

bigint

Size of a table, in bytes.