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.

Integrate your Data Warehouse today

Turn your data warehouse into a data platform that powers all company decision making and operational systems.

7-day trial • No credit card required

Woman Woman

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.

We'll handle your ETL pipeline.

How Helps 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.

Enjoying This Article?

Receive great content weekly with the Newsletter!

Woman Woman