explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 39NO

Settings
# exclusive inclusive rows x rows loops node
1. 42.943 407,221.160 ↑ 1.0 1 1

Aggregate (cost=1,046,257.26..1,046,257.27 rows=1 width=4) (actual time=407,221.159..407,221.160 rows=1 loops=1)

  • Buffers: shared hit=1022636 read=183352 dirtied=3942
  • I/O Timings: read=194609.694
2. 896.253 407,178.217 ↓ 2.8 31,706 1

Nested Loop (cost=0.99..1,046,228.73 rows=11,411 width=4) (actual time=325,518.088..407,178.217 rows=31,706 loops=1)

  • Buffers: shared hit=1022636 read=183352 dirtied=3942
  • I/O Timings: read=194609.694
3. 598.764 598.764 ↓ 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.053..598.764 rows=239,200 loops=1)

  • Heap Fetches: 6845
  • Buffers: shared hit=5223 read=412
  • I/O Timings: read=60.817
4. 405,683.200 405,683.200 ↓ 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.695..1.696 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=1017413 read=182940 dirtied=3942
  • I/O Timings: read=194548.877