explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 89bo

Settings
# exclusive inclusive rows x rows loops node
1. 1.232 9.518 ↓ 0.0 0 1

ModifyTable on public.vulnerability_occurrences (cost=0.43..3.45 rows=1 width=6) (actual time=9.518..9.518 rows=0 loops=1)

  • Buffers: shared hit=3 read=4 dirtied=2
  • I/O Timings: read=9.313
2. 8.286 8.286 ↑ 1.0 1 1

Index Scan using vulnerability_occurrences_pkey on public.vulnerability_occurrences (cost=0.43..3.45 rows=1 width=6) (actual time=8.283..8.286 rows=1 loops=1)

  • Index Cond: (vulnerability_occurrences.id = 1)
  • Buffers: shared hit=1 read=3
  • I/O Timings: read=8.209