Script to List Raw space used vs Compressed space used in Vertica

SELECT ps.anchor_table_schema, ps.used_gb, ps.used_gb * la.ratio AS raw_gb
  FROM (SELECT anchor_table_schema, SUM(used_bytes) / (1024 ^ 3) AS used_gb
          FROM v_monitor.projection_storage
         GROUP BY anchor_table_schema
         ORDER BY SUM(used_bytes) DESC) ps CROSS
  JOIN (SELECT (SELECT database_size_bytes
                  FROM v_catalog.license_audits
                 ORDER BY audit_start_timestamp DESC LIMIT 1) /
               (SELECT SUM(used_bytes) FROM v_monitor.projection_storage) AS ratio) la
 ORDER BY ps.used_gb DESC;