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.
