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.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.