How to measure the Size of your HP Vertica Database Catalog

This script will show you what is the size of you Database Catalog. Use this information to set your General Resource Pool accordingly by keeping in mind that the Vertica Catalog is not loaded in the General Pool allocated Memory and is loaded into the memory that is outside the  General Pool allocated Memory threshold.

SELECT node_name
       ,max(ts) AS ts
       ,max(catalog_size_in_MB) AS catlog_size_in_MB
FROM (
       SELECT node_name,trunc((dc_allocation_pool_statistics_by_second."time")::TIMESTAMP, 'SS'::VARCHAR(2)) AS ts ,sum((dc_allocation_pool_statistics_by_second.total_memory_max_value - dc_allocation_pool_statistics_by_second.free_memory_min_value)) / (1024 * 1024) AS catalog_size_in_MB
       FROM dc_allocation_pool_statistics_by_second
       GROUP BY 1,trunc((dc_allocation_pool_statistics_by_second."time")::TIMESTAMP, 'SS'::VARCHAR(2))
       ) foo
GROUP BY 1
ORDER BY 1;