explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xBMy

Settings
# exclusive inclusive rows x rows loops node
1. 1.887 41,873.097 ↑ 1.0 1 1

Aggregate (cost=178,715.08..178,715.09 rows=1 width=8) (actual time=41,873.097..41,873.097 rows=1 loops=1)

  • Buffers: shared hit=482,474 read=30,393 dirtied=1,301
  • I/O Timings: read=40,814.458
2. 116.257 41,871.210 ↑ 2.1 822 1

Nested Loop (cost=1.27..178,710.79 rows=1,716 width=4) (actual time=55.826..41,871.210 rows=822 loops=1)

  • Buffers: shared hit=482,474 read=30,393 dirtied=1,301
  • I/O Timings: read=40,814.458
3. 10,795.718 10,795.718 ↓ 1.4 110,965 1

Index Only Scan using notes_author_id_noteable_type_created_at_id_idx on public.notes (cost=0.70..9,873.12 rows=81,113 width=8) (actual time=4.024..10,795.718 rows=110,965 loops=1)

  • Index Cond: ((notes.author_id >= 2,503) AND (notes.author_id <= 3,753) AND (notes.noteable_type = 'Issue'::text))
  • Heap Fetches: 4,225
  • Buffers: shared hit=62,832 read=5,548 dirtied=1,292
  • I/O Timings: read=10,551.717
4. 30,959.235 30,959.235 ↓ 0.0 0 110,965

Index Only Scan using system_note_metadata_note_id_action_idx on public.system_note_metadata (cost=0.57..2.08 rows=1 width=4) (actual time=0.279..0.279 rows=0 loops=110,965)

  • Index Cond: ((system_note_metadata.note_id = notes.id) AND (system_note_metadata.action = 'title'::text))
  • Heap Fetches: 23
  • Buffers: shared hit=419,642 read=24,845 dirtied=9
  • I/O Timings: read=30,262.741