[Redshift] 列ごとの容量確認

gistfile1.txt

-- refer: http://dev.classmethod.jp/cloud/aws/amazon-redshift-tutorial-tuning-table-design/
-- システム生成の列を除外する為にWHERE句にcol < 6がある
select col, max(blocknum)
from stv_blocklist b, stv_tbl_perm p
where (b.tbl=p.id) and name ='<table name>'
and col < 6
group by name, col
order by col;