Update vulnerability_count column in report ingestion (!162415) · Merge requests · GitLab.org / GitLab

What does this MR do and why?

In this MR, I update the vulnerability_count column in the project_statistics table during the report ingestion.
This is a part of this issue

There is only one additional query introduced by this change which updates a row on the project_statistics table by using its primary key.

Here is the query and its execution plan

UPDATE "project_statistics" SET vulnerability_count = vulnerability_count + 10 WHERE "project_statistics"."id" = 17312

Edited Aug 21, 2024 by Mehmet Emin INAC