explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jRiO

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.022 0.132 ↓ 1.0 35 1

Hash Join (cost=6.29..11.11 rows=34 width=48) (actual time=0.119..0.132 rows=35 loops=1)

  • Hash Cond: (design_management_designs.id = most_recent_design_versions.design_id)
  • Buffers: shared hit=2
2. 0.011 0.011 ↑ 1.0 35 1

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

  • Buffers: shared hit=1
3. 0.033 0.099 ↓ 1.0 35 1

Hash (cost=5.86..5.86 rows=34 width=8) (actual time=0.099..0.099 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
4. 0.012 0.066 ↓ 1.0 35 1

Subquery Scan on most_recent_design_versions (cost=5.25..5.86 rows=34 width=8) (actual time=0.051..0.066 rows=35 loops=1)

  • Filter: (most_recent_design_versions.event <> 2)
  • Buffers: shared hit=1
5. 0.006 0.054 ↑ 1.0 35 1

Unique (cost=5.25..5.42 rows=35 width=18) (actual time=0.046..0.054 rows=35 loops=1)

  • Buffers: shared hit=1
6. 0.011 0.048 ↑ 1.0 35 1

Sort (cost=5.25..5.34 rows=35 width=18) (actual time=0.046..0.048 rows=35 loops=1)

  • Sort Key: design_management_designs_versions.design_id, design_management_designs_versions.version_id DESC
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=1
7. 0.037 0.037 ↑ 1.0 35 1

Seq Scan on design_management_designs_versions (cost=0.00..4.35 rows=35 width=18) (actual time=0.033..0.037 rows=35 loops=1)

  • Buffers: shared hit=1
Planning time : 0.129 ms
Execution time : 0.157 ms