explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3vjr

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

Hash Anti Join (cost=7.19..13.85 rows=12 width=766) (actual rows= loops=)

  • Hash Cond: (vulnerability_occurrences.project_fingerprint = decode((vulnerability_feedback.project_fingerprint)::text, 'escape'::text))
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..6.58 rows=25 width=798) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on projects (cost=0.00..2.24 rows=2 width=766) (actual rows= loops=)

  • Filter: (namespace_id = 2)
4. 0.000 0.000 ↓ 0.0

Index Scan using index_vulnerability_occurrences_on_unique_keys on vulnerability_occurrences (cost=0.14..2.16 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (project_id = projects.id)
5. 0.000 0.000 ↓ 0.0

Hash (cost=7.02..7.02 rows=2 width=98) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using vulnerability_feedback_unique_idx on vulnerability_feedback (cost=0.15..7.02 rows=2 width=98) (actual rows= loops=)

  • Index Cond: (feedback_type = 0)