{"blog_url":"https://yohei-a.hatenablog.jp/","version":"1.0","provider_name":"Hatena Blog","published":"2026-01-07 09:19:10","categories":["AWS","Redshift"],"author_name":"yohei-a","url":"https://yohei-a.hatenablog.jp/entry/20260107/1767745150","title":"Redshift \u3067\u30e6\u30fc\u30b6\u30fc\u5225\u306e\u63a5\u7d9a\u6570\u3092\u8abf\u3079\u308b\u30af\u30a8\u30ea","width":"100%","type":"rich","image_url":null,"author_url":"https://blog.hatena.ne.jp/yohei-a/","description":"Redshift \u3067\u30e6\u30fc\u30b6\u30fc\u5225\u306e\u63a5\u7d9a\u6570\u3092\u8abf\u3079\u308b\u30af\u30a8\u30ea\u3002\u5206\u5358\u4f4d\u306e\u30e6\u30fc\u30b6\u30fc\u5225\u306e\u63a5\u7d9a\u6570\u3092\u96c6\u8a08\u3059\u308b\u3002 -- psql \u3067\u5b9f\u884c\u3059\u308b\u5834\u5408 \\o user_connection_count.csv \\pset format unaligned \\pset fieldsep '|' \\t off WITH RECURSIVE time_series(time_value) AS ( /* Recursive CTE \u3067\u904e\u53bb 7 \u65e5\u9593\u306e 1 \u5206\u3054\u3068\u306e\u6642\u9593\u3092\u751f\u6210 */ -- \u958b\u59cb\u6642\u70b9\uff087\u65e5\u524d\uff09 SELECT date_trunc('minute', dateadd(day, -7, GETDATE())) UNI\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20260107%2F1767745150\" title=\"Redshift \u3067\u30e6\u30fc\u30b6\u30fc\u5225\u306e\u63a5\u7d9a\u6570\u3092\u8abf\u3079\u308b\u30af\u30a8\u30ea - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"ablog","height":"190","provider_url":"https://hatena.blog"}