explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g8yt

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 3,308.492 ↑ 1.0 1 1

Aggregate (cost=16,902.72..16,902.73 rows=1 width=8) (actual time=3,308.491..3,308.492 rows=1 loops=1)

  • Buffers: shared hit=7185 read=2849 dirtied=111
  • I/O Timings: read=3203.266
2. 9.895 3,308.446 ↓ 1.5 6 1

Nested Loop (cost=0.99..16,902.71 rows=4 width=4) (actual time=1,335.311..3,308.446 rows=6 loops=1)

  • Buffers: shared hit=7185 read=2849 dirtied=111
  • I/O Timings: read=3203.266
3. 3,264.825 3,264.825 ↑ 1.7 2,409 1

Index Scan using index_notes_on_author_id_and_created_at on public.notes (cost=0.57..9,098.11 rows=3,979 width=8) (actual time=10.865..3,264.825 rows=2,409 loops=1)

  • Index Cond: ((notes.author_id >= 200000) AND (notes.author_id <= 201250) 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=49 read=2754 dirtied=111
  • I/O Timings: read=3198.672
4. 33.726 33.726 ↓ 0.0 0 2,409

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

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