Skip to content
  • Andrew Newdigate @andrewn ·
    Author Owner

    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