Count pipelines that have security jobs counters fail on gitlab.com
Count pipelines that have security jobs counters fail at gitlab.com scale
Introduced in !37809 (merged)
See monitoring gitlab.com usage ping issue #237851 (comment 413307197)
721: "sast_pipeline": -1,
722: "dependency_scanning_pipeline": -1,
723: "container_scanning_pipeline": -1,
724: "dast_pipeline": -1,
725: "secret_detection_pipeline": -1,
726: "coverage_fuzzing_pipeline": -1,
SELECT Count(DISTINCT "ci_builds"."commit_id")
FROM "ci_builds"
INNER JOIN "security_scans"
ON "security_scans"."build_id" = "ci_builds"."id"
WHERE "ci_builds"."type" = 'Ci::Build'
AND "ci_builds"."status" = 'success'
AND ( "ci_builds"."retried" = false
OR "ci_builds"."retried" IS NULL )
AND ( security_scans.scan_type = 2 )
AND "ci_builds"."created_at" BETWEEN '2020-06-25 12:12:35.535725' AND
'2020-07-23 12:12:35.536078'
AND "ci_builds"."commit_id" BETWEEN 0 AND 9999
Edited by Alper Akgun