explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MHMp

Settings
# exclusive inclusive rows x rows loops node
1. 54,234.494 76,746.348 ↑ 9,270.4 23,541 1

Nested Loop (cost=22,701.47..12,680,239.21 rows=218,234,421 width=153) (actual time=452.543..76,746.348 rows=23,541 loops=1)

  • Join Filter: CASE WHEN ("*VALUES*".column1 IS NOT NULL) THEN (vbc.project_id = "*VALUES*".column1) WHEN ("*VALUES*".column2 IS NOT NULL) THEN (vbc.release_id = "*VALUES*".column2) WHEN ("*VALUES*".column3 IS NOT NULL) THEN (vbc.channel_release_id = "*VALUES*".column3) ELSE false END
  • Rows Removed by Join Filter: 413200533
2. 354.110 2,158.320 ↑ 1.1 473,338 1

Hash Join (cost=22,701.47..131,752.31 rows=499,964 width=102) (actual time=448.764..2,158.320 rows=473,338 loops=1)

  • Hash Cond: (vbrw.version_bom_component_id = vbc.id)
3. 676.701 1,429.631 ↑ 1.0 508,191 1

Hash Join (cost=4,127.40..106,270.16 rows=508,921 width=62) (actual time=70.274..1,429.631 rows=508,191 loops=1)

  • Hash Cond: (vbrw.vuln_id = vs.vuln_id)
4. 682.870 682.870 ↑ 1.0 3,488,669 1

Seq Scan on version_bom_risk_warning vbrw (cost=0.00..83,741.85 rows=3,549,785 width=30) (actual time=0.046..682.870 rows=3,488,669 loops=1)

5. 6.069 70.060 ↑ 1.0 13,929 1

Hash (cost=3,953.29..3,953.29 rows=13,929 width=45) (actual time=70.060..70.060 rows=13,929 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1162kB
6. 63.991 63.991 ↑ 1.0 13,929 1

Seq Scan on vuln_summary vs (cost=0.00..3,953.29 rows=13,929 width=45) (actual time=5.612..63.991 rows=13,929 loops=1)

7. 144.358 374.579 ↓ 1.0 307,288 1

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

  • Buckets: 524288 Batches: 1 Memory Usage: 30295kB
8. 230.221 230.221 ↓ 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=1.688..230.221 rows=307,288 loops=1)

  • Filter: (ignored IS FALSE)
  • Rows Removed by Filter: 5281
9. 20,353.284 20,353.534 ↑ 1.0 873 473,338

Materialize (cost=0.00..15.28 rows=873 width=48) (actual time=0.000..0.043 rows=873 loops=473,338)

10. 0.250 0.250 ↑ 1.0 873 1

Values Scan on "*VALUES*" (cost=0.00..10.91 rows=873 width=48) (actual time=0.011..0.250 rows=873 loops=1)

Planning time : 28.825 ms
Execution time : 76,753.739 ms