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
table column is the table name.
size column is the size of the table in MB.
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 include
unsorted 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 firstname.lastname@example.org.