NODES

Lists details about the nodes in the database.

Lists details about the nodes in the database.

Column Name Data Type Description
NODE_NAME VARCHAR(128) The name of the node.
NODE_ID INTEGER Catalog-assigned integer value that uniquely identifies the node.
NODE_STATE VARCHAR(128)

The node's current state, one of the following:

  • UP

  • DOWN

  • READY

  • UNSAFE

  • SHUTDOWN

  • SHUTDOWN_ERROR

  • RECOVERING

  • RECOVER_ERROR

  • RECOVERED

  • INITIALIZING

  • STANDBY

  • NEEDS_CATCHUP

IS_PRIMARY BOOLEAN Whether the node is a primary or secondary node. Primary nodes are the only ones Vertica considers when determining the K-Safety of an Eon Mode database. The node inherits this property from the subcluster that contains it.
IS_READONLY BOOLEAN Whether the node is in read-only mode or not. This column is TRUE if the Eon Mode database is read-only due to the loss of quorum or primary shard coverage. See Database Read-Only Mode.
NODE_ADDRESS VARCHAR(80) The host address of the node.
NODE_ADDRESS_FAMILY VARCHAR(10) The IP Version of the node_address. For example, ipv4.
EXPORT_ADDRESS VARCHAR(8192) The IP address of the node (on the public network) used for import/export operations and native load-balancing.
EXPORT_ADDRESS_FAMILY VARCHAR(10) The IP Version of the export_address. For example, ipv4.
CATALOG_PATH VARCHAR(8192) The absolute path to the catalog on the node.
NODE_TYPE VARCHAR(9) The type of the node. For more information on the types of nodes, refer to Setting node type.
IS_EPHEMERAL BOOLEAN (Deprecated) True if this node has been marked as ephemeral. (in preparation for removing it from the cluster).
STANDING_IN_FOR VARCHAR(128) The name of the node that this node is currently replacing.
SUBCLUSTER_NAME VARCHAR(128) In an Eon Mode database, the name of the subcluster that contains the node. Nodes belong to exactly one subcluster.
LAST_MSG_FROM_NODE_AT TIMESTAMPTZ The date and time the last message was received from this node.
NODE_DOWN_SINCE TIMESTAMPTZ The amount of time that the replaced node has been unavailable.
BUILD_INFO VARCHAR(128) The version of the Vertica server binary the node is running.

Example

=> SELECT NODE_NAME, NODE_STATE, IS_PRIMARY, IS_READONLY, NODE_TYPE,
          SUBCLUSTER_NAME FROM NODES ORDER BY NODE_NAME ASC;
      NODE_NAME       | NODE_STATE | IS_PRIMARY | IS_READONLY | NODE_TYPE |  SUBCLUSTER_NAME
----------------------+------------+------------+-------------+-----------+--------------------
 v_verticadb_node0001 | UP         | t          | f           | PERMANENT | default_subcluster
 v_verticadb_node0002 | UP         | t          | f           | PERMANENT | default_subcluster
 v_verticadb_node0003 | UP         | t          | f           | PERMANENT | default_subcluster
 v_verticadb_node0004 | UP         | f          | f           | PERMANENT | analytics
 v_verticadb_node0005 | UP         | f          | f           | PERMANENT | analytics
 v_verticadb_node0006 | UP         | f          | f           | PERMANENT | analytics
(6 rows)