explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iZEj

Settings
# exclusive inclusive rows x rows loops node
1. 3.906 73,895.683 ↑ 44,177.0 1,783 1

Unique (cost=86,161,347.31..88,888,995.53 rows=78,767,640 width=201) (actual time=73,886.450..73,895.683 rows=1,783 loops=1)

2. 96.822 73,891.777 ↑ 9,269.4 23,541 1

Sort (cost=86,161,347.31..86,706,876.95 rows=218,211,858 width=201) (actual time=73,886.450..73,891.777 rows=23,541 loops=1)

  • Sort Key: vbc.project_id, vbc.release_id, vbc.channel_release_id, vbrw.vuln_id
  • Sort Method: quicksort Memory: 7022kB
3. 72,358.358 73,794.955 ↑ 9,269.4 23,541 1

Nested Loop (cost=22,701.47..12,678,942.61 rows=218,211,858 width=201) (actual time=249.158..73,794.955 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
  • Hash Cond: (vbrw.version_bom_component_id = vbc.id)
4. 549.272 1,220.654 ↑ 1.0 508,191 1

Hash Join (cost=4,127.40..106,259.58 rows=508,868 width=62) (actual time=22.321..1,220.654 rows=508,191 loops=1)

  • Hash Cond: (vbrw.vuln_id = vs.vuln_id)
5. 649.191 649.191 ↑ 1.0 3,488,223 1

Seq Scan on version_bom_risk_warning vbrw (cost=0.00..83,733.18 rows=3,549,418 width=30) (actual time=0.019..649.191 rows=3,488,223 loops=1)

6. 4.133 22.191 ↑ 1.0 13,929 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1163kB
7. 18.058 18.058 ↑ 1.0 13,929 1

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

8. 102.720 215.721 ↓ 1.0 307,288 1

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

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

  • Filter: (ignored IS FALSE)
  • Rows Removed by Filter: 5281
10. 0.222 0.222 ↑ 1.0 873 1

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