explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WAXhu : Optimization for: plan #jRiO

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.037 1.017 ↓ 1.0 35 1

Hash Join (cost=4.93..10.95 rows=34 width=48) (actual time=0.984..1.017 rows=35 loops=1)

  • Hash Cond: (most_recent_design_versions.design_id = design_management_designs.id)
  • Buffers: shared hit=1 read=2
  • I/O Timings: read=0.799
2. 0.010 0.124 ↓ 1.0 35 1

Subquery Scan on most_recent_design_versions (cost=0.14..5.69 rows=34 width=8) (actual time=0.103..0.124 rows=35 loops=1)

  • Filter: (most_recent_design_versions.event <> 2)
  • Buffers: shared hit=1 read=1
  • I/O Timings: read=0.020
3. 0.007 0.114 ↑ 1.0 35 1

Unique (cost=0.14..5.25 rows=35 width=18) (actual time=0.098..0.114 rows=35 loops=1)

  • Buffers: shared hit=1 read=1
  • I/O Timings: read=0.020
4. 0.107 0.107 ↑ 1.0 35 1

Index Scan using design_management_designs_versions_uniqueness on design_management_designs_versions (cost=0.14..5.16 rows=35 width=18) (actual time=0.097..0.107 rows=35 loops=1)

  • Buffers: shared hit=1 read=1
  • I/O Timings: read=0.020
5. 0.016 0.856 ↑ 1.0 35 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared read=1
  • I/O Timings: read=0.779
6. 0.840 0.840 ↑ 1.0 35 1

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

  • Buffers: shared read=1
  • I/O Timings: read=0.779
Planning time : 1.084 ms
Execution time : 1.071 ms