explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3kNN

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 4,331.331 ↑ 1.0 1 1

Aggregate (cost=23,305.14..23,305.15 rows=1 width=8) (actual time=4,331.331..4,331.331 rows=1 loops=1)

  • Buffers: shared hit=8742 read=3055 dirtied=49
  • I/O Timings: read=4230.152
2. 13.320 4,331.241 ↓ 5.2 26 1

Nested Loop (cost=0.99..23,305.12 rows=5 width=4) (actual time=4,034.156..4,331.241 rows=26 loops=1)

  • Buffers: shared hit=8742 read=3055 dirtied=49
  • I/O Timings: read=4230.152
3. 4,289.271 4,289.271 ↑ 1.9 2,865 1

Index Scan using index_notes_on_author_id_and_created_at on public.notes (cost=0.57..12,624.18 rows=5,544 width=8) (actual time=13.059..4,289.271 rows=2,865 loops=1)

  • Index Cond: ((notes.author_id >= 100000) AND (notes.author_id <= 101250) AND (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))
  • Buffers: shared hit=140 read=3054 dirtied=49
  • I/O Timings: read=4229.997
4. 28.650 28.650 ↓ 0.0 0 2,865

Index Only Scan using index_suggestions_on_note_id_and_relative_order on public.suggestions (cost=0.42..1.92 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=2,865)

  • Index Cond: (suggestions.note_id = notes.id)
  • Heap Fetches: 0
  • Buffers: shared hit=8602 read=1
  • I/O Timings: read=0.155