explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BjUb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.107 0.366 ↑ 1.4 8 1

Sort (cost=15.17..15.20 rows=11 width=46) (actual time=0.365..0.366 rows=8 loops=1)

  • Sort Key: design_management_designs.relative_position, design_management_designs.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=23
2. 0.259 0.259 ↑ 1.4 8 1

Index Scan using index_design_management_designs_on_issue_id_and_filename on public.design_management_designs (cost=0.41..14.98 rows=11 width=46) (actual time=0.034..0.259 rows=8 loops=1)

  • Index Cond: (design_management_designs.issue_id = 24,679,718)
  • Buffers: shared hit=20