NODE_RESOURCES

Provides a snapshot of the node. This is useful for regularly polling the node with automated tools or scripts.

Column Name Data Type Description
NODE_NAME

VARCHAR

The node name for which information is listed.

HOST_NAME

VARCHAR

The hostname associated with a particular node.

PROCESS_SIZE_BYTES

INTEGER

The total size of the program.

PROCESS_RESIDENT_SET_SIZE_BYTES

INTEGER

The total number of bytes that the process has in memory.

PROCESS_SHARED_MEMORY_SIZE_BYTES

INTEGER

The amount of shared memory used.

PROCESS_TEXT_MEMORY_SIZE_BYTES

INTEGER

The total number of text bytes that the process has in physical memory. This does not include any shared libraries.

PROCESS_DATA_MEMORY_SIZE_BYTES

INTEGER

The amount of physical memory, in bytes, used for performing processes. This does not include the executable code.

PROCESS_LIBRARY_MEMORY_SIZE_BYTES

INTEGER

The total number of library bytes that the process has in physical memory.

PROCESS_DIRTY_MEMORY_SIZE_BYTES

INTEGER

The number of bytes that have been modified since they were last written to disk.

SPREAD_HOST
VARCHAR The node name of the spread host.
NODE_PORT
VARCHAR The port used for intra-cluster communication.
DATA_PORT
VARCHAR The port used by the Vertica client.