SearchFilesByContent is taking 30-60 s to complete

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

From https://gitlab.com/gitlab-com/gl-infra/infrastructure/issues/6441#note_153112998:

I suspect now that Gitaly's SearchFilesByContent actually works as of 11.8 (gitaly#1377 (closed)), we may be seeing the slowness from the large searches (https://dashboards.gitlab.net/d/PqeIQ9Iik/gitaly-feature-latency-detail?refresh=5m&orgId=1&var-job=gitaly&var-method=SearchFilesByContent):

From https://dashboards.gitlab.net/d/thYzurImk/rails-controllers?orgId=1&from=now-24h&to=now&var-action=SearchController%23show&var-database=influxdb-01-inf-gprd, we see SearchController data:

It's possible that this is also driven by slow SQL timings: