SUBCLUSTERS
| Column Name | Data Type | Description |
|---|---|---|
| SUBCLUSTER_OID |
INTEGER |
Unique identifier for the subcluster. |
| SUBCLUSTER_NAME | VARCHAR | The name of the subcluster. |
| NODE_OID | INTEGER | The catalog-assigned ID of the node. |
| NODE_NAME | VARCHAR | The name of the node. |
| PARENT_OID | INTEGER | The unique ID of the parent of the node (the database). |
| PARENT_NAME | VARCHAR | The name of the parent of the node (the database name). |
| IS_DEFAULT | BOOLEAN | Whether the subcluster is the default cluster. |
| IS_PRIMARY | BOOLEAN | Whether the subcluster is a primary subcluster. |
| CONTROL_SET_SIZE | INTEGER | The number of control nodes defined for this subcluster. This value is -1 when the large cluster feature is not enabled, or when every node in the subcluster must be a control node. See Large Cluster for more information. |
Example
=> \x Expanded display is on. dbadmin=> SELECT * FROM SUBCLUSTERS; -[ RECORD 1 ]----+--------------------- subcluster_oid | 45035996273704978 subcluster_name | default_subcluster node_oid | 45035996273704982 node_name | v_verticadb_node0001 parent_oid | 45035996273704976 parent_name | verticadb is_default | t is_primary | t control_set_size | -1 -[ RECORD 2 ]----+--------------------- subcluster_oid | 45035996273704978 subcluster_name | default_subcluster node_oid | 45035996273840970 node_name | v_verticadb_node0002 parent_oid | 45035996273704976 parent_name | verticadb is_default | t is_primary | t control_set_size | -1 -[ RECORD 3 ]----+--------------------- subcluster_oid | 45035996273704978 subcluster_name | default_subcluster node_oid | 45035996273840974 node_name | v_verticadb_node0003 parent_oid | 45035996273704976 parent_name | verticadb is_default | t is_primary | t control_set_size | -1
See Also