explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5nsg

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 1.143 ↓ 0.0 0 1

ModifyTable on public.vulnerability_issue_links (cost=0.14..3.16 rows=1 width=48) (actual time=1.143..1.143 rows=0 loops=1)

  • Buffers: shared hit=3 read=1
  • I/O Timings: read=1.041
2. 1.119 1.119 ↓ 0.0 0 1

Index Scan using index_vulnerability_issue_links_on_issue_id on public.vulnerability_issue_links (cost=0.14..3.16 rows=1 width=48) (actual time=1.119..1.119 rows=0 loops=1)

  • Index Cond: (vulnerability_issue_links.issue_id = 999,222,999)
  • Buffers: shared hit=3 read=1
  • I/O Timings: read=1.041