The script will list details about your host server CPUs. SELECT host_name, processor_count, processor_core_count, processor_description FROM v_monitor.host_resources ORDER BY host_name; All credits for this script to Vertica Kit.
SELECT host_name, processor_count, processor_core_count, processor_description FROM v_monitor.host_resources ORDER BY host_name;