explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a5Hj

Settings
# exclusive inclusive rows x rows loops node
1. 17.133 22.740 ↑ 1.0 53,527 1

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

  • Output: fact_addons.addon_id
  • Inner Unique: true
  • Hash Cond: (fact_addons.product_id = p.product_id)
2. 5.557 5.557 ↑ 1.0 53,527 1

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

  • Output: fact_addons.addon_id, fact_addons.product_id, fact_addons.amount, fact_addons.quantity
3. 0.024 0.050 ↑ 1.0 109 1

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

  • Output: p.product_id
  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
4. 0.026 0.026 ↑ 1.0 109 1

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

  • Output: p.product_id
Planning time : 0.270 ms