CLUSTER_LAYOUT

Shows the relative position of the actual arrangement of the nodes participating in the cluster and the fault groups that affect them. Ephemeral nodes are not shown in the cluster layout ring because they hold no resident data.

Column Name Data Type Description 
CLUSTER_POSITION

INTEGER

Position of the node in the cluster ring, counting forward from 0.

Note: An output value of 0 has no special meaning other than there are no nodes in position before the node assigned 0.

 
NODE_ID
 INTEGER A unique numeric ID assigned by the Vertica catalog that identifies the node. 
NODE_NAME
 VARCHAR The name of the node in the cluster ring. Only permanent nodes participating in database activity appear in the cluster layout. Ephemeral nodes are not shown in the output. 
FAULT_GROUP_ID
 INTEGER

A unique numeric ID assigned by the Vertica catalog that identifies the fault group.

Note: This value matches the FAULT_GROUP.MEMBER_ID value, but only if this node is in a fault group; otherwise the value is NULL.

 
FAULT_GROUP_NAME
 VARCHAR The name of the fault group for the node. 
FAULT_GROUP_TIER
 INTEGER

The node's depth in the fault group tree hierarchy. For example is the node:

  • Is not in a fault group, output is null
  • Is in the top level fault group, output is 0
  • Is in a fault group's child, output is 1
  • Is a fault group's grandchild, output is 2

See Also

Large Cluster in the Administrator's Guide