Determine catalog size
Moderator: NorbertKrupa
Determine catalog size
Anyone know how to determine the size of a database catalog?
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Determine catalog size
I'm assuming you understand the differences between catalog, database, and raw sizes:
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)
Checkout vertica.tips for more Vertica resources.