explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gWQh

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

Index Scan using index_vulnerability_identifiers_on_project_id_and_fingerprint on public.vulnerability_identifiers (cost=0.42..5.38 rows=1 width=149) (actual time=2.195..2.195 rows=0 loops=1)

  • Index Cond: ((vulnerability_identifiers.project_id = 278,964) AND (vulnerability_identifiers.fingerprint = ANY ('{"\\x66696e6765727072696e745f31","\\x66696e6765727072696e745f32"}'::bytea[])))
  • Buffers: shared hit=6 read=3
  • I/O Timings: read=2.112