How to Check Table Sizes in Redshift

Last updated July 25, 2026 · By the SaturnSQL team

Query SVV_TABLE_INFO: the size column is the table's footprint in 1 MB blocks, tbl_rows is the row count, and pct_used shows how much of the cluster's disk the table consumes.

SELECT "schema", "table",
       size AS size_mb,
       tbl_rows,
       pct_used,
       unsorted,
       stats_off
FROM svv_table_info
ORDER BY size DESC
LIMIT 20;