NODES

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
  • RECOVERY ERROR
  • RECOVERED
  • INITIALIZING
  • STAND BY
  • NEEDS CATCH UP
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.
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) The name of the subcluster that contains the node. Nodes belong to exactly one subcluster.
LAST_MSG_FROM_NODE_AT TIMESTAMPZ The date and time the last message was received from this node.
NODE_DOWN_SINCE TIMESTAMPZ The amount of time that the replaced node has been unavailable.