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