Comments

• Adrian_Oprea_1

  May 2015

  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. 

   

  0
• dc

  May 2015

  Great, thanks

  0