explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bMl4

Settings
# exclusive inclusive rows x rows loops node
1. 43.744 8,831.892 ↓ 5,581.5 11,163 1

Nested Loop (cost=18,574.90..24,121.51 rows=2 width=153) (actual time=590.046..8,831.892 rows=11,163 loops=1)

2. 122.084 8,348.469 ↓ 39,970.8 439,679 1

Nested Loop (cost=18,574.49..24,073.02 rows=11 width=70) (actual time=254.082..8,348.469 rows=439,679 loops=1)

3. 105.897 357.895 ↓ 37,469.0 37,469 1

Hash Join (cost=18,574.06..24,012.66 rows=1 width=56) (actual time=254.051..357.895 rows=37,469 loops=1)

  • Hash Cond: ("*VALUES*".column1 = vbc.project_id)
  • Join Filter: ((NOT (vbc.release_id IS DISTINCT FROM "*VALUES*".column2)) AND (NOT (vbc.channel_release_id IS DISTINCT FROM "*VALUES*".column3)))
  • Rows Removed by Join Filter: 165501
4. 2.519 2.519 ↑ 1.0 867 1

Values Scan on "*VALUES*" (cost=0.00..10.84 rows=867 width=48) (actual time=0.003..2.519 rows=867 loops=1)

5. 113.905 249.479 ↓ 1.0 307,288 1

Hash (cost=14,735.70..14,735.70 rows=307,069 width=56) (actual time=249.479..249.479 rows=307,288 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 30295kB
6. 135.574 135.574 ↓ 1.0 307,288 1

Seq Scan on version_bom_component vbc (cost=0.00..14,735.70 rows=307,069 width=56) (actual time=0.024..135.574 rows=307,288 loops=1)

  • Filter: (ignored IS FALSE)
  • Rows Removed by Filter: 5281
7. 7,868.490 7,868.490 ↑ 2.3 12 37,469

Index Scan using idx_version_bom_risk_warning_version_bom_component_id on version_bom_risk_warning vbrw (cost=0.43..60.08 rows=28 width=30) (actual time=0.080..0.210 rows=12 loops=37,469)

  • Index Cond: (version_bom_component_id = vbc.id)
8. 439.679 439.679 ↓ 0.0 0 439,679

Index Scan using vuln_summary_pkey on vuln_summary vs (cost=0.41..4.40 rows=1 width=45) (actual time=0.001..0.001 rows=0 loops=439,679)

  • Index Cond: (vuln_id = vbrw.vuln_id)
Planning time : 3.312 ms
Execution time : 8,838.479 ms