explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pelg

Settings
# exclusive inclusive rows x rows loops node
1. 0.166 3,840.505 ↑ 1.0 1 1

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

  • Buffers: shared hit=8626 read=3179 dirtied=49
  • I/O Timings: read=3758.543
2. 9.300 3,840.339 ↓ 5.2 26 1

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

  • Buffers: shared hit=8618 read=3179 dirtied=49
  • I/O Timings: read=3758.543
3. 3,805.254 3,805.254 ↑ 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=7.514..3,805.254 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=110 read=3084 dirtied=49
  • I/O Timings: read=3754.251
4. 25.785 25.785 ↓ 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.009..0.009 rows=0 loops=2,865)

  • Index Cond: (suggestions.note_id = notes.id)
  • Heap Fetches: 0
  • Buffers: shared hit=8508 read=95
  • I/O Timings: read=4.292