explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U94hS

Settings
# exclusive inclusive rows x rows loops node
1. 46.861 419,605.083 ↑ 1.0 1 1

Aggregate (cost=1,046,257.26..1,046,257.27 rows=1 width=4) (actual time=419,605.082..419,605.083 rows=1 loops=1)

  • Buffers: shared hit=1011048 read=194926 dirtied=3827
  • I/O Timings: read=209737.750
2. 738.416 419,558.222 ↓ 2.8 31,706 1

Nested Loop (cost=0.99..1,046,228.73 rows=11,411 width=4) (actual time=337,902.055..419,558.222 rows=31,706 loops=1)

  • Buffers: shared hit=1011048 read=194926 dirtied=3827
  • I/O Timings: read=209737.750
3. 698.206 698.206 ↓ 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.080..698.206 rows=239,200 loops=1)

  • Heap Fetches: 6845
  • Buffers: shared hit=5183 read=452
  • I/O Timings: read=120.006
4. 418,121.600 418,121.600 ↓ 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.746..1.748 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=1005865 read=194474 dirtied=3827
  • I/O Timings: read=209617.744