AWS Redshiftでテーブル名と容量の一覧を出力する - Qiita

select name, cnt from ( select tbl, count(*) as cnt from stv_blocklist where tbl in ( select id from stv_tbl_perm) group by tbl ) block_list inner join stv_tbl_perm on block_list.tbl=stv_tbl_perm.id group by tbl, stv_tbl_perm.name, block_list.cnt order by cnt;

[el-condor]

テーブル名と容量の一覧を取得するクエリ