Table Size

This post will show how to get the compressed size of Vertica tables from column_storage and projection_storage system tables in the v_monitor schema. To get an estimated raw or uncompressed data size, see my earlier post on License Utilization.


The following query aggregates the column_storage data to the table level. You can add column_name for more granularity. Note that empty tables will not appear in this table.


The following query is almost identical to the one above, except for the table name. The lowest level in this system table is the table name. Any empty tables will appear in your result.


Related Posts

  • December 23, 2013 Identifying Slow Queries In this post, I'll show how to identify slow running query requests in Vertica. The query_requests system table in the v_monitor schema […]
  • October 23, 2013 Disk Space Utilization This post will show how to query the host_resources, disk_storage and storage_usage system tables to determine compressed disk space […]
  • January 24, 2014 License Utilization It's important to remain compliant with license limits and not exceed space utilization in Vertica. Space utilization for licenses are […]
  • April 7, 2015 Quick tip: Check load balancing In an ideal environment, all clients connecting to the database will request a load balanced connection; as well as having load balancing […]
  • December 26, 2013 Importance of Using Stream Name with Copy When using a COPY bulk load in Vertica, it's important to properly identify the load using the optional STREAM NAME parameter. This […]
  • March 19, 2015 Quick tip: Clean out old projections Spring officially starts tomorrow and it's the perfect time to do some spring cleaning on old projections. This quick tip shows how to […]

About Norbert Krupa

Norbert is the founder of and a Solutions Architect at HP Vertica. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

Leave a Reply

%d bloggers like this: