explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GEps

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

Index Scan using index_vulnerability_occurrences_on_unique_keys on public.vulnerability_occurrences (cost=0.56..3.59 rows=1 width=1,122) (actual time=8.696..8.696 rows=0 loops=1)

  • Index Cond: ((vulnerability_occurrences.project_id = 224,302) AND (vulnerability_occurrences.primary_identifier_id = 6,309) AND (vulnerability_occurrences.location_fingerprint = '\x6c871440eb9f7618b9aef25e5246acddff6ed7a1'::bytea) AND (vulnerability_occurrences.scanner_id = 1,643))
  • Filter: ((vulnerability_occurrences.created_at > '2020-09-01 14:12:50.453892+00'::timestamp with time zone) AND (vulnerability_occurrences.report_type = 2))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=8.658