Vertica Database size

There are many ways you can monitor your database size.

1- Use Vertica Management Console

2- Query the system table

(dbadmin@:5433) [dbadmin] *>  select round((total_used_bytes/(1024^3)),3.3)||' Gb' as DB_Size  from system;
-[ RECORD 1 ]-----
DB_Size | 1.471 Gb

3- Query the projection_storage table 

(dbadmin@:5433) [dbadmin] *> select round(sum((ros_used_bytes+wos_used_bytes)/1024^3),3.3)||' Gb' as DB_Size from projection_storage;
-[ RECORD 1 ]-----
DB_Size | 1.471 Gb

4- Query the storage_containers table

(dbadmin@:5433) [dbadmin] *> select round(sum(used_bytes)/(1024^3),3.3) as GB from v_monitor.storage_containers group by node_name;
-[ RECORD 1 ]
GB | 1.471

Note: - this is not raw data, is stored data.

You can implement a crontab job that will run this query and send the result to an email. 

Great, thanks