Script to Find Vertica Schemas Size in mb

select node_name,
       TO_CHAR(sum(used_bytes) / 1024 ^ 2, '9999.99 MB') as "Size in Mb"
  from projection_storage
 where projection_schema in
       (select projection_schema from projection_storage)
 group by node_name
 order by "Size in Mb" desc;