explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lnwj

Settings
# exclusive inclusive rows x rows loops node
1. 6.001 20,725.288 ↑ 1.0 1 1

Aggregate (cost=345,284.34..345,284.35 rows=1 width=8) (actual time=20,725.287..20,725.288 rows=1 loops=1)

2. 671.818 20,719.287 ↓ 1.7 9,467 1

HashAggregate (cost=345,156.54..345,213.34 rows=5,680 width=14) (actual time=20,712.100..20,719.287 rows=9,467 loops=1)

  • Group Key: vr.vuln_id
3. 1,118.169 20,047.469 ↓ 2.7 809,919 1

Hash Join (cost=282,661.58..344,405.47 rows=300,426 width=14) (actual time=16,471.248..20,047.469 rows=809,919 loops=1)

  • Hash Cond: (vr.consumer_release_id = cr.id)
4. 17,633.756 18,924.633 ↓ 2.7 809,919 1

Hash Semi Join (cost=281,834.15..339,447.19 rows=300,426 width=30) (actual time=16,466.568..18,924.633 rows=809,919 loops=1)

  • Hash Cond: (vr.vuln_id = version_bom_risk_warning.vuln_id)
5. 0.000 1,290.877 ↓ 1.0 825,178 1

Seq Scan on vuln_remediation vr (cost=0.00..52,162.87 rows=803,022 width=30) (actual time=0.986..1,290.877 rows=825,178 loops=1)

  • Filter: ((vuln_source = ANY ('{NVD,BDSA}'::text[])) AND (status = ANY ('{NEW,NEEDS_REVIEW,REMEDIATION_REQUIRED}'::text[])))
  • Rows Removed by Filter: 116,810ctual time=16,465.561..16465.562 rows=10,741 loops=1)807.59 rows=2,125 width=14) (a--More--
  • Buckets: 16,384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 617kB
6. 8,406.373 16,456.989 ↓ 5.1 10,742 1

HashAggregate (cost=281,765.09..281,786.34 rows=2,125 width=14) (actual time=16,447.504..16,456.989 rows=10,742 loops=1)

  • Group Key: version_bom_risk_warning.vuln_id
7. 8,050.616 8,050.616 ↑ 1.0 11,219,500 1

Seq Scan on version_bom_risk_warning (cost=0.00..253,227.47 rows=11,415,047 width=14) (actual time=0.723..8,050.616 rows=11,219,500 loops=1)

8. 1.696 4.667 ↑ 1.0 2,019 1

Hash (cost=802.19..802.19 rows=2,019 width=16) (actual time=4.667..4.667 rows=2,019 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 111kB
9. 2.971 2.971 ↑ 1.0 2,019 1

Seq Scan on central_release cr (cost=0.00..802.19 rows=2,019 width=16) (actual time=0.008..2.971 rows=2,019 loops=1)

Planning time : 2.770 ms
Execution time : 20,725.728 ms