# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.207 | 7,716.274 | ↑ 98.5 | 406 | 1 |
→
Sort (cost=476,967.17..477,067.17 rows=40,000 width=16) (actual time=7,716.222..7,716.274 rows=406 loops=1)
|
2. | 741.146 | 7,716.067 | ↑ 98.5 | 406 | 1 |
→
HashAggregate (cost=473,509.63..473,909.63 rows=40,000 width=16) (actual time=7,715.906..7,716.067 rows=406 loops=1)
|
3. | 2,927.463 | 6,974.921 | ↑ 1.7 | 2,661,592 | 1 |
→
HashAggregate (cost=347,505.65..393,325.28 rows=4,581,963 width=16) (actual time=6,005.922..6,974.921 rows=2,661,592 loops=1)
|
4. | 1,799.335 | 4,047.458 | ↑ 1.0 | 4,581,612 | 1 |
→
Hash Join (cost=204.49..313,140.93 rows=4,581,963 width=16) (actual time=2.514..4,047.458 rows=4,581,612 loops=1)
|
5. | 2,245.710 | 2,245.710 | ↑ 1.0 | 4,581,612 | 1 |
→
Seq Scan on mall_orders_cz_dwh (cost=0.00..249,934.45 rows=4,581,963 width=12) (actual time=0.059..2,245.710 rows=4,581,612 loops=1)
|
6. | 1.196 | 2.413 | ↑ 1.0 | 5,844 | 1 |
→
Hash (cost=131.44..131.44 rows=5,844 width=4) (actual time=2.413..2.413 rows=5,844 loops=1)
|
7. | 1.217 | 1.217 | ↑ 1.0 | 5,844 | 1 |
→
Seq Scan on dim_dates (cost=0.00..131.44 rows=5,844 width=4) (actual time=0.009..1.217 rows=5,844 loops=1) |