explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MsZl : 22

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

Hash Join (cost=4,607.86..8,446.93 rows=461 width=10) (actual rows= loops=)

  • Hash Cond: ((sdo.salesorderid = salesorderdetail.salesorderid) AND (sdo.productid = ((avg(salesorderdetail.productid))::integer)))
2. 0.000 0.000 ↓ 0.0

Seq Scan on salesorderdetail sdo (cost=0.00..3,202.16 rows=121,316 width=14) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=4,308.19..4,308.19 rows=19,978 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,808.74..4,108.41 rows=19,978 width=8) (actual rows= loops=)

  • Group Key: salesorderdetail.salesorderid
5. 0.000 0.000 ↓ 0.0

Seq Scan on salesorderdetail (cost=0.00..3,202.16 rows=121,316 width=8) (actual rows= loops=)