explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cQdc

Settings
# exclusive inclusive rows x rows loops node
1. 44.852 436,013.309 ↑ 1.0 1 1

Aggregate (cost=1,042,133.84..1,042,133.85 rows=1 width=4) (actual time=436,013.309..436,013.309 rows=1 loops=1)

  • Buffers: shared hit=826119 read=376713 dirtied=24
  • I/O Timings: read=426578.768
2. 767.852 435,968.457 ↓ 2.8 31,706 1

Nested Loop (cost=0.99..1,042,105.30 rows=11,414 width=4) (actual time=357,119.459..435,968.457 rows=31,706 loops=1)

  • Buffers: shared hit=826119 read=376713 dirtied=24
  • I/O Timings: read=426578.768
3. 813.405 813.405 ↑ 1.0 239,200 1

Index Only Scan using aa_index_suggestions_on_note_id on public.suggestions (cost=0.42..6,077.30 rows=239,200 width=4) (actual time=1.383..813.405 rows=239,200 loops=1)

  • Heap Fetches: 6845
  • Buffers: shared hit=4570 read=906 dirtied=1
  • I/O Timings: read=314.938
4. 434,387.200 434,387.200 ↓ 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.815..1.816 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=821549 read=375807 dirtied=23
  • I/O Timings: read=426263.830