explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2na4

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

Limit (cost=0.56..3.58 rows=1 width=1,113) (actual time=8.433..8.434 rows=0 loops=1)

  • Buffers: shared hit=3 read=4
  • I/O Timings: read=8.373
2. 8.432 8.432 ↓ 0.0 0 1

Index Scan using index_vulnerability_occurrences_on_unique_keys on public.vulnerability_occurrences (cost=0.56..3.58 rows=1 width=1,113) (actual time=8.432..8.432 rows=0 loops=1)

  • Index Cond: ((vulnerability_occurrences.project_id = 278,964) AND (vulnerability_occurrences.primary_identifier_id = 1) AND (vulnerability_occurrences.location_fingerprint = '\x6c6f636174696f6e5f66696e6765727072696e74'::bytea) AND (vulnerability_occurrences.scanner_id = 1))
  • Buffers: shared hit=3 read=4
  • I/O Timings: read=8.373