SUBCLUSTERS
This table lists all of the subclusters defined in the database.
This table lists all of the subclusters defined in the database. It contains an entry for each node in the database listing which subcluster it belongs to. Any subcluster that does not contain a node has a single entry in this table with empty NODE_NAME and NODE_OID columns. This table is only populated if the database is running in Eon Mode.
| 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. |
Examples
=> \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