Skip to content

Add metrics for projects with applied scan result policies

What does this MR do and why?

This MR adds metrics to count The total number of projects with at least one scan result policy.

Queries

SELECT COUNT(DISTINCT "approval_project_rules"."project_id") FROM "approval_project_rules" WHERE "approval_project_rules"."report_type" = 4 AND "approval_project_rules"."project_id" BETWEEN 268964 AND 278964;

https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/12479/commands/44104

Time: 63.098 ms
  - planning: 1.235 ms
  - execution: 61.863 ms
    - I/O read: 61.192 ms
    - I/O write: 0.000 ms

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #375284 (closed)

Edited by Alan (Maciej) Paruszewski

Merge request reports

Loading