Skip to content
Snippets Groups Projects

Add missing indexes to codeintel tables

Merged Administrator requested to merge es/codeintel-indexes-prod into main

Created by: eseliger

There were two really slow queries I found on dotcom; as it turns out, they were missing and index on two columns that were filtered by. This brings down the HasRepository query from 580ms to 0.082, and the IsQueued query from ~1100ms to 0.141ms. This also seems to propagate into other codeintel queries as the congestion on these tables is reduced. Overall, we see a 10% CPU usage reduction on dotcom.

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
Please register or sign in to reply
Loading