explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1krl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=52,813.74..52,814.01 rows=11 width=12) (actual rows= loops=)

  • Group Key: d.monthofyear
2. 0.000 0.000 ↓ 0.0

Sort (cost=52,813.74..52,813.79 rows=22 width=12) (actual rows= loops=)

  • Sort Key: d.monthofyear
3. 0.000 0.000 ↓ 0.0

Gather (cost=52,810.94..52,813.25 rows=22 width=12) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=51,810.94..51,811.05 rows=11 width=12) (actual rows= loops=)

  • Group Key: d.monthofyear
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=55.01..51,620.21 rows=38,145 width=4) (actual rows= loops=)

  • Hash Cond: (o.iddate = d.iddate)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on fr_fact_order o (cost=0.00..39,109.79 rows=986,879 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=53.94..53.94 rows=86 width=8) (actual rows= loops=)

  • -> Seq Scan on fr_dim_date d (cost=0.00..53.94 rows=86 width=8)" Filter: ((monthofyear >= 6) AND (monthofyear <= 8) AND (year = 2,018))