explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GGVr

Settings
# exclusive inclusive rows x rows loops node
1. 3,183.078 7,422.397 ↑ 1.7 2,661,592 1

HashAggregate (cost=347,505.65..393,325.28 rows=4,581,963 width=16) (actual time=6,400.528..7,422.397 rows=2,661,592 loops=1)

  • Group Key: dim_dates.date_iso, dim_dates.date_iso, mall_orders_cz_dwh.order_id
2. 1,832.283 4,239.319 ↑ 1.0 4,581,612 1

Hash Join (cost=204.49..313,140.93 rows=4,581,963 width=16) (actual time=2.732..4,239.319 rows=4,581,612 loops=1)

  • Hash Cond: (mall_orders_cz_dwh.order_date = dim_dates.date_iso)
3. 2,404.380 2,404.380 ↑ 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.036..2,404.380 rows=4,581,612 loops=1)

  • Filter: ((order_date >= '2017-11-01'::date) AND (order_date <= '2018-12-11'::date))
4. 1.261 2.656 ↑ 1.0 5,844 1

Hash (cost=131.44..131.44 rows=5,844 width=4) (actual time=2.655..2.656 rows=5,844 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 270kB
5. 1.395 1.395 ↑ 1.0 5,844 1

Seq Scan on dim_dates (cost=0.00..131.44 rows=5,844 width=4) (actual time=0.010..1.395 rows=5,844 loops=1)