explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QQdC

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.060 ↓ 0.0 0 1

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

  • Buffers: shared hit=7 dirtied=1
2. 0.058 0.058 ↓ 0.0 0 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=0.058..0.058 rows=0 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 hit=7 dirtied=1