explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bleo

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

HashAggregate (cost=67.48..77.72 rows=1,024 width=19) (actual rows= loops=)

  • Group Key: p.description
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=31.04..62.36 rows=1,024 width=15) (actual rows= loops=)

  • Hash Cond: (i.productid = p.id)
3. 0.000 0.000 ↓ 0.0

Seq Scan on invoice i (cost=0.00..17.24 rows=1,024 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=18.24..18.24 rows=1,024 width=15) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on product p (cost=0.00..18.24 rows=1,024 width=15) (actual rows= loops=)