Table sizes in Redshift

redshift_table_sizes.sql

-- Get table sizes in Gigabytes sorted by size descending
SELECT name AS "table", substring(datname, 1, 15) AS "database", ROUND((COUNT(*) / 1024.0),2) AS "GB"
FROM stv_blocklist
INNER JOIN (
  SELECT DISTINCT id, name, datname, db_id FROM stv_tbl_perm
  INNER JOIN pg_database
    ON stv_tbl_perm.db_id = pg_database.oid
) AS t
  ON t.id = stv_blocklist.tbl
GROUP BY name, datname
ORDER BY "GB" DESC
;