rendered paste body GroupAggregate (cost=138944.80..162723.16 rows=731642 width=28)
-> Sort (cost=138944.80..140773.90 rows=731642 width=28)
Sort Key: t2.time2_id, f.region_id, f.dealer_id, f.product_id, f.contract_id, f.promotion_id
-> Nested Loop (cost=223.05..20660.02 rows=731642 width=28)
-> Merge Join (cost=223.05..263.18 rows=1 width=4)
Merge Cond: (("outer".bus_year = "inner".bus_year) AND ("outer".bus_semi = "inner".bus_semi) AND ("outer".bus_quarter = "inner".bus_quarter) AND ("outer".bus_month = "inner".bus_month))
-> Sort (cost=118.22..122.47 rows=1700 width=14)
Sort Key: t2.bus_year, t2.bus_semi, t2.bus_quarter, t2.bus_month
-> Seq Scan on dim_time2 t2 (cost=0.00..27.00 rows=1700 width=14)
-> Sort (cost=104.83..108.61 rows=1510 width=10)
Sort Key: t1.bus_year, t1.bus_semi, t1.bus_quarter, t1.bus_month
-> Seq Scan on dim_time t1 (cost=0.00..25.10 rows=1510 width=10)
-> Seq Scan on fact_sales f (cost=0.00..13080.42 rows=731642 width=24)
(13 rows)