Redshift Table Size: How to find the size of a table in Redshift

in Redshift
 • Updated on 

SVV_TABLE_INFO is a Redshift systems table that shows information about user-defined tables (not other system tables) in a Redshift database. The table is only visible to superusers.

To get the size of each table, run the following command on your Redshift cluster:

SELECT “table”, size, tbl_rows FROM SVV_TABLE_INFO

The table column is the table name. The size column is the size of the table in MB. The tbl_rows column is the total number of rows in the table, including rows that have been marked for deletion but not yet vacuumed.

Other valuable columns may includeunsorted which shows the percent of rows that are unsorted, as well as pct_used, which shows the available space that is used by the table. This information can help you optimize your Redshift cluster for better performance.

You may also be interested in learning how to query available disk space on your Redshift cluster.

# How FlyData Helps

FlyData Sync provides continuous, real-time database replication to Amazon Redshift. It offers a reliable, powerful way to simplify your data analytics pipeline in a single interface without manual scripting.

With a free 14-day trial, you can get your data synced in just minutes. For questions about how we can help accelerate your use-case and journey on Amazon Redshift, connect with us at support@flydata.com.

Worry-free replication from source to Redshift & Snowflake
Unlimited sync during trial
No credit-card required
World class support
Try FlyData for free
Amazon Partner Logo Certified AWS
Redshift partner
Get started. Try FlyData.
Quick setup. No credit card required. Unlimited sync during trial.
Fast and secure Enterprise-grade security and near real-time sync.
World-class support Proactive monitoring from technical experts, 24/7.
Straightforward pricing Pay for the rows you use, and nothing you don’t.