explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4mZU

Settings
# exclusive inclusive rows x rows loops node
1. 31.755 278,342.186 ↑ 1.0 1 1

Aggregate (cost=1,046,257.26..1,046,257.27 rows=1 width=4) (actual time=278,342.186..278,342.186 rows=1 loops=1)

  • Buffers: shared hit=1065330 read=140544 dirtied=3470 written=2
  • I/O Timings: read=130988.321 write=0.312
2. 432.548 278,310.431 ↓ 2.8 31,706 1

Nested Loop (cost=0.99..1,046,228.73 rows=11,411 width=4) (actual time=205,447.548..278,310.431 rows=31,706 loops=1)

  • Buffers: shared hit=1065330 read=140544 dirtied=3470 written=2
  • I/O Timings: read=130988.321 write=0.312
3. 645.083 645.083 ↓ 1.0 239,200 1

Index Only Scan using index_suggestions_on_note_id_and_relative_order on public.suggestions (cost=0.42..10,456.09 rows=239,138 width=4) (actual time=0.038..645.083 rows=239,200 loops=1)

  • Heap Fetches: 6911
  • Buffers: shared hit=5357 read=344 dirtied=90
  • I/O Timings: read=235.168
4. 277,232.800 277,232.800 ↓ 0.0 0 239,200

Index Scan using notes_pkey on public.notes (cost=0.57..4.32 rows=1 width=8) (actual time=1.157..1.159 rows=0 loops=239,200)

  • Index Cond: (notes.id = suggestions.note_id)
  • Filter: ((notes.created_at >= '2020-02-10 18:14:49.508694+00'::timestamp with time zone) AND (notes.created_at <= '2020-03-09 18:14:49.508982+00'::timestamp with time zone))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1059973 read=140200 dirtied=3380 written=2
  • I/O Timings: read=130753.153 write=0.312