Find the largest table in Vertica database

Find top tables in Vertica database.

SELECT t.table_name AS table_name, 
   SUM(ps.wos_row_count + ps.ros_row_count) AS row_count,
   SUM(ps.wos_used_bytes + ps.ros_used_bytes) AS byte_count
   FROM tables t
   JOIN projections p ON t.table_id = p.anchor_table_id
   JOIN projection_storage ps on p.projection_name = ps.projection_name
   WHERE (ps.wos_used_bytes + ps.ros_used_bytes) > 500000
   GROUP BY t.table_name
   ORDER BY byte_count DESC;  

Find total storage used by vertica cluster.

select  total_used_bytes, total_row_count from v_monitor.system;