explain.depesz.com

PostgreSQL's explain analyze made readable

Result: btWZ : Optimization for: plan #BjUb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.012 0.188 ↑ 1.0 8 1

Sort (cost=11.54..11.56 rows=8 width=46) (actual time=0.187..0.188 rows=8 loops=1)

  • Sort Key: design_management_designs.relative_position, design_management_designs.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=8 read=2
  • I/O Timings: read=0.117
2. 0.176 0.176 ↑ 1.0 8 1

Index Scan using index_design_management_designs_on_issue_id_and_relative_positi on public.design_management_designs (cost=0.29..11.42 rows=8 width=46) (actual time=0.163..0.176 rows=8 loops=1)

  • Index Cond: (design_management_designs.issue_id = 24,679,718)
  • Buffers: shared hit=8 read=2
  • I/O Timings: read=0.117