explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OjaP

Settings
# exclusive inclusive rows x rows loops node
1. 17.650 23.488 ↑ 1.0 53,527 1

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

  • Output: fact_addons.addon_id
  • Inner Unique: true
  • Hash Cond: (fact_addons.product_id = dim_products.product_id)
2. 5.786 5.786 ↑ 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.352..5.786 rows=53,527 loops=1)

  • Output: fact_addons.addon_id, fact_addons.product_id, fact_addons.amount, fact_addons.quantity
3. 0.018 0.052 ↑ 1.0 109 1

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

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

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

  • Output: dim_products.product_id
Planning time : 0.297 ms