Skip to content

Instantly share code, notes, and snippets.

@smalik

smalik/vertica_column_storage.sql

Created February 16, 2016 20:00
Show Gist options
  • Save smalik/c8579cface91a1a90a80 to your computer and use it in GitHub Desktop.
Save smalik/c8579cface91a1a90a80 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. smalik created this gist Feb 16, 2016.
    7 changes: 7 additions & 0 deletions vertica_column_storage.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    SELECT anchor_table_schema,
    anchor_table_name,
    SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
    FROM v_monitor.column_storage
    GROUP BY anchor_table_schema,
    anchor_table_name
    ORDER BY SUM(used_bytes) DESC;