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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot