explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ebq8

Settings
# exclusive inclusive rows x rows loops node
1. 32.483 375,985.076 ↑ 1.0 1 1

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

  • Buffers: shared hit=968,139 read=237,918 dirtied=4,573
  • I/O Timings: read=233,957.594
2. 611.735 375,952.593 ↓ 2.8 31,706 1

Nested Loop (cost=0.99..1,046,228.73 rows=11,411 width=4) (actual time=303,090.310..375,952.593 rows=31,706 loops=1)

  • Buffers: shared hit=968,139 read=237,918 dirtied=4,573
  • I/O Timings: read=233,957.594
3. 753.658 753.658 ↓ 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=1.492..753.658 rows=239,200 loops=1)

  • Heap Fetches: 6,911
  • Buffers: shared hit=5,026 read=675 dirtied=116
  • I/O Timings: read=203.705
4. 374,587.200 374,587.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.565..1.566 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=963,113 read=237,243 dirtied=4,457
  • I/O Timings: read=233,753.889