explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E3Y6

Settings
# exclusive inclusive rows x rows loops node
1. 166.394 33,809.686 ↑ 1.3 35,115 1

Merge Join (cost=38.14..11,140.93 rows=45,486 width=1,249) (actual time=4.655..33,809.686 rows=35,115 loops=1)

  • Merge Cond: (issues.id = design_management_designs.id)
  • Buffers: shared hit=29,689 read=20,731 dirtied=338
  • I/O Timings: read=33,013.061
2. 33,140.903 33,140.903 ↑ 1,701.3 35,695 1

Index Scan using issues_pkey on public.issues (cost=0.56..13,581,347.02 rows=60,727,866 width=1,249) (actual time=3.459..33,140.903 rows=35,695 loops=1)

  • Buffers: shared hit=5,776 read=20,244 dirtied=99
  • I/O Timings: read=32,737.955
3. 502.389 502.389 ↓ 1.0 45,580 1

Index Only Scan using design_management_designs_pkey on public.design_management_designs (cost=0.29..1,884.06 rows=45,486 width=8) (actual time=1.175..502.389 rows=45,580 loops=1)

  • Heap Fetches: 25,956
  • Buffers: shared hit=23,913 read=487 dirtied=239
  • I/O Timings: read=275.106