Skip to content

Add index to oauth_access_grants.application_id

What does this MR do and why?

This MR adds an index to the application_id column to fix the timeout error when removing oauth applications. Internal issue: https://gitlab.com/gitlab-com/support/internal-requests/-/issues/18610

The table contains about 50m rows but it doesn't seem to be a high traffic table (not in the list).

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #393247 (closed)

Edited by Adam Hegyi

Merge request reports