sentry: Slow DB Query /repositories/

[fey]

https://nikolay-gagarinov.sentry.io/share/issue/04bd2032be5445a4bc35290158c57e4d/

FROM (
  WITH RECURSIVE "cte" AS (
  SELECT DISTINCT "contributors_repository"."id", ROW_NUMBER() OVER (
  ORDER BY COUNT("contributors_contribution"."id") FILTER (
  WHERE (
    "contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
  )) DESC) AS "num", COUNT("contributors_contribution"."id") FILTER (
  WHERE (
    "contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
  ))
  FROM "contributors_repository"
  LEFT OUTER JOIN "contributors_contribution" ON ("contributors_repository"."id" =
    "contributors_contribution"."repository_id")
  LEFT OUTER JOIN "contributors_contributor" ON ("contributors_contribution"."contributor_id" =
    "contributors_contributor"."id")
  INNER JOIN "contributors_repository_labels" ON ("contributors_repository"."id" =
    "contributors_repository_labels"."repository_id")
  INNER JOIN "contributors_label" ON ("contributors_repository_labels"."label_id" =
    "contributors_label"."id")
  INNER JOIN "contributors_repository_labels" T6 ON ("contributors_repository"."id" =
    T6."repository_id")
  INNER JOIN "contributors_label" T7 ON (T6."label_id" = T7."id")
  INNER JOIN "contributors_repository_labels" T8 ON ("contributors_repository"."id" =
    T8."repository_id")
  INNER JOIN "contributors_label" T9 ON (T8."label_id" = T9."id")
  WHERE (
    "contributors_repository"."is_visible" AND LOWER("contributors_label"."name") IN (
      %s, %s, %s, %s, %s, %s, %s, %s, %s, %s
    ) AND LOWER(T7."name") IN (
      %s, %s, %s, %s, %s, %s, %s, %s, %s, %s
    ) AND LOWER(T9."name") IN (
      %s, %s, %s, %s, %s, %s, %s, %s, %s, %s
    )
  )
  GROUP BY "contributors_repository"."id"
  ORDER BY COUNT("contributors_contribution"."id") FILTER (
  WHERE (
    "contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
  )) DESC)
  SELECT DISTINCT "contributors_repository"."id" AS "col1", "contributors_repository"."name" AS "col2",
     "contributors_repository"."html_url" AS "col3", "contributors_repository"."is_tracked" AS "col4",
    "contributors_repository"."owner_id" AS "col5", "contributors_repository"."organization_id" AS
    "col6", "contributors_repository"."project_id" AS "col7", "contributors_repository"."full_name" AS
    "col8", "contributors_repository"."is_visible" AS "col9", COUNT("contributors_contribution"."id")
    FILTER (
  WHERE (
    "contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
  )) AS "pull_requests", COUNT("contributors_contribution"."id") FILTER (
  WHERE (
    "contributors_contribution"."type" = %s AND "contributors_contributor"."is_visible"
  )) AS "issues", COUNT(DISTINCT "contributors_contribution"."contributor_id") FILTER (
  WHERE "contributors_contributor"."is_visible") AS "contributors_count", "cte"."num" AS "num"
  FROM "contributors_repository"
  LEFT OUTER JOIN "contributors_contribution" ON ("contributors_repository"."id" =
    "contributors_contribution"."repository_id")
  LEFT OUTER JOIN "contributors_contributor" ON ("contributors_contribution"."contributor_id" =
    "contributors_contributor"."id")
  INNER JOIN "contributors_repository_labels" ON ("contributors_repository"."id" =
    "contributors_repository_labels"."repository_id")
  INNER JOIN "contributors_label" ON ("contributors_repository_labels"."label_id" =
    "contributors_label"."id")
  INNER JOIN "contributors_repository_labels" T6 ON ("contributors_repository"."id" =
    T6."repository_id")
  INNER JOIN "contributors_label" T7 ON (T6."label_id" = T7."id")
  INNER JOIN "contributors_repository_labels" T8 ON ("contributors_repository"."id" =
    T8."repository_id")
  INNER JOIN "contributors_label" T9 ON (T8."label_id" = T9."id")
  INNER JOIN "cte" ON "contributors_repository"."id" = ("cte"."id")
  WHERE (
    "contributors_repository"."is_visible" AND LOWER("contributors_label"."name") IN (
      %s, %s, %s, %s, %s, %s, %s, %s, %s, %s
    ) AND LOWER(T7."name") IN (
      %s, %s, %s, %s, %s, %s, %s, %s, %s, %s
    ) AND LOWER(T9."name") IN (
      %s, %s, %s, %s, %s, %s, %s, %s, %s, %s
    )
  )
  GROUP BY 1, 13
) subquery```

labels
mathematica.php.makefile.fortran.scss.java.nsis.c.javascript.racket
sort
-issues

нужно посмотреть в чем дело и мб улучшить запрос

[fey]

[fey]

Актуально.
https://nikolay-gagarinov.sentry.io/issues/6317474933/events/1bb81d9eae6c498baff9da3ce1128d1a/

SELECT "contributors_contributor"."id", "contributors_contributor"."name",
  "contributors_contributor"."html_url", "contributors_contributor"."is_tracked",
  "contributors_contributor"."user_id", "contributors_contributor"."login",
  "contributors_contributor"."avatar_url", "contributors_contributor"."is_visible", COUNT(
  "contributors_contribution"."id") FILTER (
WHERE "contributors_contribution"."type" = %s) AS "commits", COALESCE(SUM(
  "contributors_commitstats"."additions"), %s) AS "additions", COALESCE(SUM(
  "contributors_commitstats"."deletions"), %s) AS "deletions", COUNT("contributors_contribution"."id")
   FILTER (
WHERE "contributors_contribution"."type" = %s) AS "pull_requests", COUNT(
  "contributors_contribution"."id") FILTER (
WHERE "contributors_contribution"."type" = %s) AS "issues", COUNT("contributors_contribution"."id")
  FILTER (
WHERE "contributors_contribution"."type" = %s) AS "comments", (COALESCE(SUM(
  "contributors_commitstats"."additions"), %s) + COALESCE(SUM("contributors_commitstats"."deletions"),
   %s)) AS "editions", ((((COUNT("contributors_contribution"."id") FILTER (
WHERE "contributors_contribution"."type" = %s) + (COALESCE(SUM(
  "contributors_commitstats"."additions"), %s) + COALESCE(SUM("contributors_commitstats"."deletions"),
   %s))) + COUNT("contributors_contribution"."id") FILTER (
WHERE "contributors_contribution"."type" = %s)) + COUNT("contributors_contribution"."id") FILTER (
WHERE "contributors_contribution"."type" = %s)) + COUNT("contributors_contribution"."id") FILTER (
WHERE "contributors_contribution"."type" = %s)) AS "contribution_amount"
FROM "contributors_contributor"
LEFT OUTER JOIN "contributors_contribution" ON ("contributors_contributor"."id" =
  "contributors_contribution"."contributor_id")
LEFT OUTER JOIN "contributors_commitstats" ON ("contributors_contribution"."id" =
  "contributors_commitstats"."commit_id")
GROUP BY "contributors_contributor"."id" HAVING COUNT("contributors_contribution"."id") FILTER (
WHERE (
  "contributors_contribution"."type" = %s
)) >= %s