{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkaigai.hatenablog.com%2Fentry%2F2017%2F08%2F20%2F004105\" title=\"GpuJoin + GpuPreAgg combined kernel - KaiGai\u306e\u4ffa\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","version":"1.0","author_url":"https://blog.hatena.ne.jp/kaigai/","width":"100%","provider_name":"Hatena Blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kaigai/20170820/20170820000010.png","blog_url":"https://kaigai.hatenablog.com/","categories":["PostgreSQL","GPU"],"published":"2017-08-20 00:41:05","author_name":"kaigai","description":"\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u306f\u3001t0\u3068t1\u306e2\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092JOIN\u3057\u3001\u305d\u306e\u7d50\u679c\u3092GROUP BY\u3057\u3066\u51fa\u529b\u3059\u308b\u3082\u306e\u3067\u3042\u308b\u3002 \u3057\u304b\u3057\u3001EXPLAIN ANALYZE\u306e\u51fa\u529b\u306b\u306f\u5947\u5999\u306a\u70b9\u304c\u3042\u308b\u3002 postgres=# explain analyze select cat,count(*),avg(ax) from t0 natural join t1 group by cat; QUERY PLAN -------------------------------------------------------------------------------- GroupAggregate (cost=955519.\u2026","blog_title":"KaiGai\u306e\u4ffa\u30e1\u30e2","type":"rich","title":"GpuJoin + GpuPreAgg combined kernel","height":"190","url":"https://kaigai.hatenablog.com/entry/2017/08/20/004105"}