Add metrics for user merge request with assigned security policy project
What does this MR do and why?
This MR adds metrics to count total users creating MRs in projects with assigned Security Policy Project.
Queries
explain SELECT COUNT(DISTINCT "merge_requests"."author_id") FROM "merge_requests"
INNER JOIN security_orchestration_policy_configurations ON merge_requests.target_project_id = security_orchestration_policy_configurations.project_id
WHERE "merge_requests"."author_id" BETWEEN 5525431 AND 5535431;
Before index
Time: 3.815 min
- planning: 5.356 ms
- execution: 3.814 min
- I/O read: 3.767 min
- I/O write: 0.000 ms
https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/12552/commands/44303
After index
Time: 2.998 s
- planning: 1.188 ms
- execution: 2.997 s
- I/O read: 2.884 s
- I/O write: 0.000 ms
https://postgres.ai/console/gitlab/gitlab-production-tunnel-pg12/sessions/12552/commands/44339
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Related to #375284 (closed)
Edited by Alan (Maciej) Paruszewski