Script to List Disk use by Node in Vertica
The Script will create a reports on disk space utilization by host.
SELECT host_name,
cast((disk_space_free_mb / 1024) as decimal(4, 2)) AS disk_space_free_gb,
cast((disk_space_used_mb / 1024) as decimal(4, 2)) AS disk_space_used_gb,
cast((disk_space_total_mb / 1024) as decimal(4, 2)) AS disk_space_total_gb
FROM v_monitor.host_resources;
