explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uOnN

Settings
# exclusive inclusive rows x rows loops node
1. 3.689 18.094 ↓ 0.0 0 1

ModifyTable on public.notes (cost=0.57..3.59 rows=1 width=6) (actual time=18.094..18.094 rows=0 loops=1)

  • Buffers: shared hit=4 read=8 dirtied=4
  • I/O Timings: read=17.773
2. 14.405 14.405 ↓ 2.0 2 1

Index Scan using index_notes_on_noteable_id_and_noteable_type on public.notes (cost=0.57..3.59 rows=1 width=6) (actual time=10.574..14.405 rows=2 loops=1)

  • Index Cond: ((notes.noteable_id = 1,436,971) AND ((notes.noteable_type)::text = 'Vulnerability'::text))
  • Filter: (notes.project_id = 278,964)
  • Rows Removed by Filter: 0
  • Buffers: shared read=6
  • I/O Timings: read=14.285