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.
SANDBOX VARCHAR(128) In an Eon Mode database, the name, if any, of the sandbox to which the node belongs. NULL if the node is not a member of an active sandbox.
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)