explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HLCf

Settings
# exclusive inclusive rows x rows loops node
1. 4.903 819,893.167 ↑ 1.0 1 1

Aggregate (cost=1,326,443.99..1,326,444.00 rows=1 width=8) (actual time=819,893.167..819,893.167 rows=1 loops=1)

  • Buffers: shared hit=846,586 read=549,511 dirtied=8,591
  • I/O Timings: read=807,500.482
2. 766.123 819,888.264 ↑ 2.4 1,693 1

Nested Loop (cost=1.14..1,326,433.91 rows=4,030 width=4) (actual time=40,429.001..819,888.264 rows=1,693 loops=1)

  • Buffers: shared hit=846,577 read=549,511 dirtied=8,591
  • I/O Timings: read=807,500.482
3. 658,827.947 658,827.947 ↓ 1.1 204,718 1

Index Scan using index_notes_on_author_id_and_created_at_and_id on public.notes (cost=0.57..704,092.93 rows=186,122 width=8) (actual time=5.023..658,827.947 rows=204,718 loops=1)

  • Index Cond: ((notes.author_id >= 0) AND (notes.author_id <= 2,500))
  • Filter: ((notes.noteable_type)::text = 'Issue'::text)
  • Rows Removed by Filter: 304,895
  • Buffers: shared hit=74,041 read=421,128 dirtied=7,430
  • I/O Timings: read=650,870.122
4. 160,294.194 160,294.194 ↓ 0.0 0 204,718

Index Scan using index_system_note_metadata_on_note_id on public.system_note_metadata (cost=0.57..3.34 rows=1 width=4) (actual time=0.783..0.783 rows=0 loops=204,718)

  • Index Cond: (system_note_metadata.note_id = notes.id)
  • Filter: ((system_note_metadata.action)::text = 'title'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=772,536 read=128,383 dirtied=1,161
  • I/O Timings: read=156,630.360