[Redshift] テーブル毎のディスクスペース確認

gistfile1.sql

SET SEARCH_PATH TO <schema name>;
SELECT
  stv_tbl_perm.name AS table
  ,COUNT(*) AS mb
FROM
  stv_blocklist,
  stv_tbl_perm
WHERE
  stv_blocklist.tbl = stv_tbl_perm.id
  AND stv_blocklist.slice = stv_tbl_perm.slice
  AND stv_tbl_perm.name IN ('<table name1>','<table name2>', .. '<table nameN>')
GROUP BY
  stv_tbl_perm.name
ORDER BY
  1 ASC;

-- 多分こっちでもOK
SELECT
  name
  ,COUNT(*)
FROM
  SVV_DISKUSAGE
WHERE
  name IN ('<table name1>','<table name2>', .. '<table nameN>')
GROUP BY
  name;