Skip to content
  • Top results are

    projects.shared_runners_enabled -4861115307529270576
    SELECT
      $1 AS one
    FROM
      "projects"
    WHERE
      "projects"."namespace_id" IN ( WITH RECURSIVE "base_and_descendants" AS ((
            SELECT
              "namespaces".*
            FROM
              "namespaces"
            WHERE
              "namespaces"."type" = $2
              AND "namespaces"."id" = $3) +
          UNION
          + (
            SELECT
              "namespaces".*
            FROM
              "namespaces",
              "base_and_descendants"
            WHERE
              "namespaces"."type" = $4
              AND "namespaces"."parent_id" = "base_and_descendants"."id"))
          SELECT
            id
          FROM
            "base_and_descendants" AS "namespaces")
        AND "projects"."shared_runners_enabled" = $5
      LIMIT $6
    
    web_hooks 7643958809750055506
    SELECT
      $1 AS one
    FROM
      "web_hooks"
    WHERE
      "web_hooks"."type" = $2
      AND "web_hooks"."group_id" IN ( WITH RECURSIVE "base_and_ancestors" AS ((
            SELECT
              "namespaces".*
            FROM
              "namespaces"
            WHERE
              "namespaces"."type" = $3
              AND "namespaces"."id" = $4) +
          UNION
          + (
            SELECT
              "namespaces".*
            FROM
              "namespaces",
              "base_and_ancestors"
            WHERE
              "namespaces"."type" = $5
              AND "namespaces"."id" = "base_and_ancestors"."parent_id"))
          SELECT
            "namespaces"."id"
          FROM
            "base_and_ancestors" AS "namespaces")
        AND "web_hooks"."job_events" = $6
      LIMIT $7
    
    project_statistics -688638164611048261
    SELECT
      SUM((("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size") - "projects"."repository_size_limit"))
    FROM
      "projects"
      INNER JOIN "project_statistics" ON "project_statistics"."project_id" = "projects"."id"
    WHERE
      "projects"."namespace_id" IN ( WITH RECURSIVE "base_and_descendants" AS ((
            SELECT
              "namespaces".*
            FROM
              "namespaces"
            WHERE
              "namespaces"."type" = $1
              AND "namespaces"."id" = $2) +
          UNION
          + (
            SELECT
              "namespaces".*
            FROM
              "namespaces",
              "base_and_descendants"
            WHERE
              "namespaces"."type" = $3
              AND "namespaces"."parent_id" = "base_and_descendants"."id"))
          SELECT
            id
          FROM
            "base_and_descendants" AS "namespaces")
        AND ("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size") > "projects"."repository_size_limit"
        AND "projects"."repository_size_limit" != $4
    
    project_statistics -8100380766120221092
    SELECT
      SUM((("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size") - $1))
    FROM
      "projects"
      INNER JOIN "project_statistics" ON "project_statistics"."project_id" = "projects"."id"
    WHERE
      "projects"."namespace_id" IN ( WITH RECURSIVE "base_and_descendants" AS ((
            SELECT
              "namespaces".*
            FROM
              "namespaces"
            WHERE
              "namespaces"."type" = $2
              AND "namespaces"."id" = $3) +
          UNION
          + (
            SELECT
              "namespaces".*
            FROM
              "namespaces",
              "base_and_descendants"
            WHERE
              "namespaces"."type" = $4
              AND "namespaces"."parent_id" = "base_and_descendants"."id"))
          SELECT
            id
          FROM
            "base_and_descendants" AS "namespaces")
        AND ("project_statistics"."repository_size" + "project_statistics"."lfs_objects_size") > $5
        AND "projects"."repository_size_limit" IS NULL
    
    jira_connect_installations -6950614318406704078
    SELECT DISTINCT
      "jira_connect_installations".*
    FROM
      "jira_connect_installations"
      INNER JOIN "jira_connect_subscriptions" ON "jira_connect_subscriptions"."jira_connect_installation_id" = "jira_connect_installations"."id"
    WHERE
      "jira_connect_subscriptions"."id" IN (
        SELECT
          "jira_connect_subscriptions"."id"
        FROM
          "jira_connect_subscriptions"
        WHERE
          "jira_connect_subscriptions"."namespace_id" IN ( WITH RECURSIVE "base_and_ancestors" AS ((
                SELECT
                  "namespaces".*
                FROM
                  "namespaces"
                WHERE
                  "namespaces"."type" = $1
                  AND "namespaces"."id" = $2) +
              UNION
              + (
                SELECT
                  "namespaces".*
                FROM
                  "namespaces",
                  "base_and_ancestors"
                WHERE
                  "namespaces"."type" = $3
                  AND "namespaces"."id" = "base_and_ancestors"."parent_id"))
              SELECT
                "namespaces"."id"
              FROM
                "base_and_ancestors" AS "namespaces"))
    
    ci_runners 33866971430695439
    SELECT
      "ci_runners".*
    FROM ((
        SELECT
          "ci_runners".*
        FROM
          "ci_runners"
          INNER JOIN "ci_runner_projects" ON "ci_runners"."id" = "ci_runner_projects"."runner_id"
        WHERE
          "ci_runner_projects"."project_id" = $1) +
      UNION
      + (
        SELECT
          "ci_runners".*
        FROM
          "ci_runners"
          INNER JOIN "ci_runner_namespaces" ON "ci_runner_namespaces"."runner_id" = "ci_runners"."id"
          INNER JOIN "namespaces" ON "namespaces"."id" = "ci_runner_namespaces"."namespace_id"
            AND "namespaces"."type" = $2
        WHERE
          "namespaces"."id" IN ( WITH RECURSIVE "base_and_ancestors" AS ((
                SELECT
                  "namespaces".*
                FROM
                  "namespaces"
                  INNER JOIN "projects" ON "projects"."namespace_id" = "namespaces"."id"
                WHERE
                  "namespaces"."type" = $3
                  AND "projects"."id" = $4) +
              UNION
              + (
                SELECT
                  "namespaces".*
                FROM
                  "namespaces",
                  "base_and_ancestors"
                WHERE
                  "namespaces"."type" = $5
                  AND "namespaces"."id" = "base_and_ancestors"."parent_id"))
              SELECT
                "namespaces"."id"
              FROM
                "base_and_ancestors" AS "namespaces")) +
          UNION
          + (
            SELECT
              "ci_runners".*
            FROM
              "ci_runners"
            WHERE
              "ci_runners"."runner_type" = $6)) ci_runners
      WHERE (contacted_at > $7)
    
    Edited by Andrew Newdigate
0% or .
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!
Please register or to comment