Skip to content

Add metrics for projects with assigned security policy project

Alan (Maciej) Paruszewski requested to merge 375284-add-metrics-for-govern-security-policies-01 into master

What does this MR do and why?

This MR adds metrics to count The total number of projects with an assigned security policy project.

Queries

SELECT COUNT(DISTINCT "security_orchestration_policy_configurations"."project_id") FROM "security_orchestration_policy_configurations" WHERE "security_orchestration_policy_configurations"."project_id" BETWEEN 268964 AND 278964;

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

Time: 3.793 ms
  - planning: 0.580 ms
  - execution: 3.213 ms
    - I/O read: 3.022 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