Script to List Setting CPU Scaling for Performance

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.