NODE_RESOURCES
Provides a snapshot of the node.
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. |
| NODE_IDENTIFIER | VARCHAR | A unique identifier for the 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. |
| DBCLERK | BOOLEAN | Whether this node is the DB clerk. The DB clerk is responsible for coordinating some administrative tasks in the database. |