explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fnia

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

Index Scan using index_vulnerability_scanners_on_project_id_and_external_id on public.vulnerability_scanners (cost=0.29..5.10 rows=1 width=54) (actual time=2.118..2.118 rows=0 loops=1)

  • Index Cond: ((vulnerability_scanners.project_id = 278,964) AND ((vulnerability_scanners.external_id)::text = ANY ('{external_id_1,external_id_2}'::text[])))
  • Buffers: shared hit=5 read=2
  • I/O Timings: read=1.969