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

A unique numeric ID assigned by the Vertica catalog that 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
 
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. 
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.