[Explorer] Execution failed for question 9b32491d-5a4b-4fed-8e8d-8378dcdb7e7f: What is the absolute average response time (in hours) for issues, in @surrealdb organization each month?

[naisofly]

Hi, It's failed to execute the question 9b32491d-5a4b-4fed-8e8d-8378dcdb7e7f What is the absolute average response time (in hours) for issues, in @surrealdb organization each month? (errorType = error-query-execute):

• executedAt: 2023-11-07T08:06:43.000+00:00
• requestedAt: 2023-11-07T08:06:43.000+00:00

Error message

other error for mpp stream: Code: 0, e.displayText() = DB::TiFlashException: Memory limit (total) exceeded caused by 'RSS(Resident Set Size) much larger than limit' : process memory size would be 28.75 GiB for (attempt to allocate chunk of 2093056 bytes), limit of memory for data computing : 27.68 GiB. Memory Usage of Storage: non-query: peak=0.00 B, amount=0.00 B; query-storage-task: peak=15.84 MiB, amount=0.00 B; fetch-pages: peak=15.84 MiB, amount=0.00 B., e.what() = DB::TiFlashException,

Generated SQL

SELECT
  DATE_FORMAT(ge.created_at, '%Y-%m-01') AS t_month,
  AVG(
    TIMESTAMPDIFF(
      HOUR,
      ge.pr_or_issue_created_at,
      (
        SELECT
          MIN(ge2.created_at)
        FROM
          github_events ge2
        WHERE
          ge2.pr_or_issue_id = ge.pr_or_issue_id
          AND ge2.type = 'IssueCommentEvent'
      )
    )
  ) AS avg_response_time
FROM
  github_events ge
  JOIN github_repos gr ON ge.repo_id = gr.repo_id
  JOIN github_users gu ON ge.actor_id = gu.id
WHERE
  ge.type = 'IssueCommentEvent'
  AND gu.organization = 'surrealdb'
GROUP BY
  t_month
ORDER BY
  t_month ASC