indexなし

GroupAggregate (cost=2499166.88..2553796.50 rows=40001 width=34) (actual time=131256.980..131463.148 rows=4788 loops=1)
-> Sort (cost=2499166.88..2510072.80 rows=4362370 width=34) (actual time=131256.874..131298.983 rows=23920 loops=1)
Sort Key: a.brandcode， a.marketcode， a.date
-> Merge Join (cost=1468150.09..1544804.86 rows=4362370 width=34) (actual time=130542.438..130772.830 rows=23920 loops=1)
Merge Cond: (("outer".marketcode = "inner".marketcode) AND ("outer".brandcode = "inner".brandcode))
-> Sort (cost=169198.08..169302.51 rows=41773 width=30) (actual time=363.333..366.063 rows=4788 loops=1)
Sort Key: a.marketcode， a.brandcode
-> Index Scan using stockprices_pk on stockprices a (cost=0.00..165396.55 rows=41773 width=30) (actual time=58.714..265.123 rows=4788 loops=1)
Index Cond: (date = ’2005-02-25’::date)
-> Sort (cost=1298952.01..1309395.05 rows=4177214 width=30) (actual time=130179.032..130229.218 rows=23927 loops=1)
Sort Key: b.marketcode， b.brandcode
-> Seq Scan on stockprices b (cost=182516.99..417241.50 rows=4177214 width=30) (actual time=129053.730..129325.792 rows=23927 loops=1)
Filter: (subplan)
SubPlan
-> Materialize (cost=182516.99..182517.00 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=8354427)
-> Limit (cost=182516.99..182516.99 rows=1 width=4) (actual time=63139.995..63139.997 rows=1 loops=1)
-> Sort (cost=182516.98..182517.48 rows=200 width=4) (actual time=63139.978..63139.981 rows=5 loops=1)
Sort Key: date
-> HashAggregate (cost=182509.34..182509.34 rows=200 width=4) (actual time=63120.574..63126.495 rows=1760 loops=1)
-> Seq Scan on stockprices (cost=0.00..161623.27 rows=8354427 width=4) (actual time=0.028..44834.175 rows=8354427 loops=1)
Total runtime: 131604.548 ms
(21 rows)