Determine catalog size

Moderator: NorbertKrupa

Post Reply
Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

Determine catalog size

Post by Brett » Tue Sep 02, 2014 6:09 pm

Anyone know how to determine the size of a database catalog?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Determine catalog size

Post by NorbertKrupa » Tue Sep 02, 2014 7:00 pm

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.

Post Reply

Return to “New to Vertica Database Administration”