List 10 largest tables in Vertica database

Bart Gawrych - Dataedo Team Bart Gawrych 2019-10-31

Table of Contents:


    Query below allows to get names of ten largest tables in database.

    Query

    select schema_name as table_schema,
           anchor_table_name as table_name,
           round(sum(used_bytes)/(1024^2), 2) as used_mb
    from v_monitor.storage_containers sc
    join v_catalog.projections p
         on sc.projection_id = p.projection_id
    group by table_schema,
             table_name
    order by used_mb desc
    limit 10;
    

    Columns

    • table_schema - schema in which table reside
    • table_name - name of the table
    • used_mb - sum of all table's projections size (table size)

    Rows

    • One row represents one table in a database
    • Scope of rows: top 10 largest tables by size
    • Ordered by table used space descending

    Sample results

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept