Getting your Node Hardware Specs:

[Deleted User] · June 2018

Jim Knicely wrote this tip.

At some point in the future, you might not remember the number of CPU sockets/processor cores and the amount of memory on each node of your Vertica cluster. Instead of having to issue several Linux commands on each node, Vertica provides the V_CATALOG.HOST_RESOURCES system table, which provides a snapshot of the nodes in your Vertica cluster! This table is useful for regularly polling the node with automated tools or scripts.

Example:

dbadmin=> SELECT host_name, processor_count, processor_core_count, processor_description, ROUND(total_memory_bytes / 1024^3, 2) total_memory_gbytes FROM V_MONITOR.HOST_RESOURCES;
   host_name   | processor_count | processor_core_count |          processor_description           | total_memory_gbytes
---------------+-----------------+----------------------+------------------------------------------+---------------------
 192.168.2.200 |               1 |                    1 | Intel(R) Core(TM) i5-4300U CPU @ 1.90GHz |                2.78
 192.168.2.201 |               1 |                    1 | Intel(R) Core(TM) i5-4300U CPU @ 1.90GHz |                2.78
 192.168.2.202 |               1 |                    2 | Intel(R) Core(TM) i5-4300U CPU @ 1.90GHz |                2.78
(3 rows)

Have Fun!