explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n8q4

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

GroupAggregate (cost=282,775.00..283,443.46 rows=11 width=12) (actual rows= loops=)

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

Sort (cost=282,775.00..282,997.78 rows=89,114 width=10) (actual rows= loops=)

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

Gather (cost=90,144.95..275,448.33 rows=89,114 width=10) (actual rows= loops=)

  • Workers Planned: 2
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=89,144.95..265,536.93 rows=37,131 width=10) (actual rows= loops=)

  • Hash Cond: (op.idgroup = o.idgroup)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=394.68..171,758.10 rows=259,798 width=4) (actual rows= loops=)

  • Hash Cond: (op.asin = (p.asin)::text)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on fr_bt_order_product op (cost=0.00..110,591.60 rows=4,813,960 width=15) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=388.14..388.14 rows=523 width=11) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on fr_dim_product p (cost=0.00..388.14 rows=523 width=11) (actual rows= loops=)

  • Filter: ((vendorcountry)::text = 'China'::text)
9. 0.000 0.000 ↓ 0.0

Hash (cost=82,865.88..82,865.88 rows=338,511 width=14) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=46.79..82,865.88 rows=338,511 width=14) (actual rows= loops=)

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

Seq Scan on fr_fact_order o (cost=0.00..52,926.10 rows=2,368,510 width=14) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=42.81..42.81 rows=318 width=8) (actual rows= loops=)

  • -> Seq Scan on fr_dim_date d (cost=0.00..42.81 rows=318 width=8)" Filter: (year = 2,019)