explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S54Z

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

Hash Join (cost=11.57..2,917.23 rows=53,527 width=4) (actual rows= loops=)

  • Output: fact_addons.addon_id
  • Inner Unique: true
  • Hash Cond: (fact_addons.product_id = p.product_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on scv.fact_addons (cost=0.00..2,740.05 rows=53,527 width=8) (actual rows= loops=)

  • Output: fact_addons.addon_id, fact_addons.product_id, fact_addons.amount, fact_addons.quantity
3. 0.000 0.000 ↓ 0.0

Hash (cost=5.85..5.85 rows=109 width=4) (actual rows= loops=)

  • Output: p.product_id
4. 0.000 0.000 ↓ 0.0

Seq Scan on scv.dim_products p (cost=0.00..5.85 rows=109 width=4) (actual rows= loops=)