explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y4LZ : Optimization for: Optimization for: plan #jRiO; plan #WAXhu

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.016 0.049 ↓ 1.0 35 1

Hash Join (cost=4.79..9.69 rows=34 width=48) (actual time=0.035..0.049 rows=35 loops=1)

  • Hash Cond: (design_management_designs_versions.design_id = design_management_designs.id)
  • Buffers: shared hit=2
2. 0.015 0.015 ↓ 1.0 35 1

Seq Scan on design_management_designs_versions (cost=0.00..4.44 rows=34 width=8) (actual time=0.008..0.015 rows=35 loops=1)

  • Filter: (event <> 2)
  • Buffers: shared hit=1
3. 0.009 0.018 ↑ 1.0 35 1

Hash (cost=4.35..4.35 rows=35 width=48) (actual time=0.018..0.018 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
4. 0.009 0.009 ↑ 1.0 35 1

Seq Scan on design_management_designs (cost=0.00..4.35 rows=35 width=48) (actual time=0.005..0.009 rows=35 loops=1)

  • Buffers: shared hit=1
Planning time : 0.186 ms
Execution time : 0.074 ms