explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7G7O

Settings
# exclusive inclusive rows x rows loops node
1. 69.081 282.838 ↓ 0.0 0 1

Update on vulnerabilities (cost=50,985.83..72,099.88 rows=7,661 width=295) (actual time=282.838..282.838 rows=0 loops=1)

2. 116.666 213.757 ↑ 4.5 1,705 1

Index Scan using index_vulnerabilities_on_project_id on vulnerabilities (cost=50,985.83..72,099.88 rows=7,661 width=295) (actual time=105.308..213.757 rows=1,705 loops=1)

  • Index Cond: (project_id = 3,870,115)
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 13,721
3.          

SubPlan (for Index Scan)

4. 11.956 97.091 ↓ 182.9 13,721 1

Nested Loop (cost=1.43..50,985.22 rows=75 width=8) (actual time=0.061..97.091 rows=13,721 loops=1)

5. 8.031 57.693 ↑ 1.0 13,721 1

Nested Loop (cost=1.00..44,251.51 rows=14,023 width=8) (actual time=0.046..57.693 rows=13,721 loops=1)

6. 8.499 8.499 ↑ 1.0 13,721 1

Index Scan using index_vulnerability_occurrence_pipelines_on_pipeline_id on vulnerability_occurrence_pipelines vop (cost=0.57..1,037.22 rows=14,023 width=8) (actual time=0.023..8.499 rows=13,721 loops=1)

  • Index Cond: (pipeline_id = 178,011,736)
7. 41.163 41.163 ↑ 1.0 1 13,721

Index Scan using vulnerability_occurrences_pkey on vulnerability_occurrences vo (cost=0.43..3.08 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=13,721)

  • Index Cond: (id = vop.occurrence_id)
8. 27.442 27.442 ↑ 1.0 1 13,721

Index Scan using vulnerabilities_pkey on vulnerabilities vulnerabilities_1 (cost=0.43..0.48 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=13,721)

  • Index Cond: (id = vo.vulnerability_id)
  • Filter: (project_id = 3,870,115)
Planning time : 2.213 ms
Execution time : 283.144 ms