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. 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 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 Integrate.io Helps
Integrate.io 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.