Help us understand the problem. What is going on with this article?

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

More than 5 years have passed since last update.

下記のSQLを管理者ユーザーで実行する。
単位はMB。

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;
lifull
日本最大級の不動産・住宅情報サイト「LIFULL HOME'S」を始め、人々の生活に寄り添う様々な情報サービス事業を展開しています。
https://lifull.com/
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away