Monday, January 9, 2017

Query space utilization in Vertica

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

No comments:

Post a Comment