Determine catalog size
Posted: Tue Sep 02, 2014 6:09 pm
Anyone know how to determine the size of a database catalog?
User 2 User Support
http://www.vertica-forums.com/
Code: Select all
dbadmin=> select node_name, storage_path, disk_space_used_mb, disk_space_free_mb from disk_storage where storage_usage = 'CATALOG';
node_name | storage_path | disk_space_used_mb | disk_space_free_mb
------------------+------------------------------------------------------+--------------------+--------------------
v_vmart_node0001 | /home/dbadmin/VMart/v_vmart_node0001_catalog/Catalog | 2860 | 14786
v_vmart_node0002 | /home/dbadmin/VMart/v_vmart_node0002_catalog/Catalog | 3571 | 14075
v_vmart_node0003 | /home/dbadmin/VMart/v_vmart_node0003_catalog/Catalog | 2784 | 14862
(3 rows)