explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Bew

Settings
# exclusive inclusive rows x rows loops node
1. 13.049 42,558.722 ↑ 1.0 1 1

Aggregate (cost=1,053,421.53..1,053,421.54 rows=1 width=4) (actual time=42,558.722..42,558.722 rows=1 loops=1)

  • Buffers: shared hit=832230 read=381472 dirtied=8107 written=10
  • I/O Timings: read=38479.982 write=1.473
2. 353.596 42,545.673 ↓ 2.8 31,744 1

Nested Loop (cost=0.99..1,053,392.88 rows=11,461 width=4) (actual time=33,558.745..42,545.673 rows=31,744 loops=1)

  • Buffers: shared hit=832230 read=381472 dirtied=8107 written=10
  • I/O Timings: read=38479.982 write=1.473
3. 460.325 460.325 ↓ 1.0 241,224 1

Index Only Scan using index_suggestions_on_note_id_and_relative_order on public.suggestions (cost=0.42..8,607.83 rows=241,129 width=4) (actual time=1.094..460.325 rows=241,224 loops=1)

  • Heap Fetches: 4130
  • Buffers: shared hit=2377 read=1014 dirtied=178
  • I/O Timings: read=301.883
4. 41,731.752 41,731.752 ↓ 0.0 0 241,224

Index Scan using notes_pkey on public.notes (cost=0.57..4.32 rows=1 width=8) (actual time=0.173..0.173 rows=0 loops=241,224)

  • 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=829853 read=380458 dirtied=7929 written=10
  • I/O Timings: read=38178.099 write=1.473