explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IspI

Settings
# exclusive inclusive rows x rows loops node
1. 1.723 12.527 ↓ 10,000.0 10,000 1

Merge Join (cost=18.01..460.34 rows=1 width=4) (actual time=5.155..12.527 rows=10,000 loops=1)

  • Filter: (epic_user_mentions.epic_id IS NULL)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=6480 read=5 dirtied=5
  • I/O Timings: read=3.611
2. 5.707 5.707 ↑ 1.1 10,000 1

Index Only Scan using epic_notes_mentions_temp_index on public.notes (cost=0.29..413.17 rows=11,432 width=4) (actual time=0.054..5.707 rows=10,000 loops=1)

  • Index Cond: ((notes.id >= 67972855) AND (notes.id < 268738059))
  • Heap Fetches: 54
  • Buffers: shared hit=6373
3. 0.114 5.097 ↑ 248.0 1 1

Sort (cost=17.73..18.35 rows=248 width=8) (actual time=5.097..5.097 rows=1 loops=1)

  • Sort Key: epic_user_mentions.note_id
  • Sort Method: quicksort Memory: 36kB
  • Buffers: shared hit=107 read=5 dirtied=5
  • I/O Timings: read=3.611
4. 4.983 4.983 ↓ 1.0 252 1

Index Only Scan using epic_user_mentions_on_epic_id_and_note_id_index on public.epic_user_mentions (cost=0.14..7.87 rows=248 width=8) (actual time=2.049..4.983 rows=252 loops=1)

  • Heap Fetches: 253
  • Buffers: shared hit=107 read=5 dirtied=5
  • I/O Timings: read=3.611