Find the space used by a vertica table

 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,sum(ps.USED_BYTES) as sum_used_bytes

   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 t.table_name ='subscription'

   GROUP BY t.table_name

   ORDER BY byte_count DESC; 

used_bytes is same as wos_used_bytes+ ros_used_bytes
ros_count is number of ROS containers