{"blog_title":"ablog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20250522%2F1747867217\" title=\"Amazon Redshift \u3067\u30ce\u30fc\u30c9\u30fb\u30b9\u30e9\u30a4\u30b9\u3054\u3068\u306e\u30d6\u30ed\u30c3\u30af\u6570\u3092\u78ba\u8a8d\u3059\u308b - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","image_url":null,"published":"2025-05-22 07:40:17","author_name":"yohei-a","author_url":"https://blog.hatena.ne.jp/yohei-a/","width":"100%","title":"Amazon Redshift \u3067\u30ce\u30fc\u30c9\u30fb\u30b9\u30e9\u30a4\u30b9\u3054\u3068\u306e\u30d6\u30ed\u30c3\u30af\u6570\u3092\u78ba\u8a8d\u3059\u308b","description":"Amazon Redshift \u3067\u30ce\u30fc\u30c9\u30fb\u30b9\u30e9\u30a4\u30b9\u3054\u3068\u306e\u30d6\u30ed\u30c3\u30af\u6570\u3092\u78ba\u8a8d\u3059\u308b\u3002 select b.node, a.slice, sum(blocknum) from svv_diskusage a, stv_slices b where a.slice = b.slice group by b.node, a.slice order by b.node, a.slice, sum(blocknum) desc; node|slice|sum 0|0|2821012504 0|1|2885748816 0|2|2830922313 0|3|2967025944 1|4|5211643368 1|\u2026","type":"rich","categories":[],"height":"190","url":"https://yohei-a.hatenablog.jp/entry/20250522/1747867217","blog_url":"https://yohei-a.hatenablog.jp/","provider_name":"Hatena Blog","provider_url":"https://hatena.blog"}