SELECT /*+ label(compressed_table_size)*/
anchor_table_schema,
SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
FROM v_monitor.projection_storage
GROUP BY anchor_table_schema
ORDER BY SUM(used_bytes) DESC;
Output:
A_uat 83.9939151955768
B_test 0.3224210254848
anchor_table_schema,
SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
FROM v_monitor.projection_storage
GROUP BY anchor_table_schema
ORDER BY SUM(used_bytes) DESC;
Output:
A_uat 83.9939151955768
B_test 0.3224210254848
No comments:
Post a Comment