Skip to content

Create index for users.unconfirmed_email

Andreas Brandl requested to merge ab/unconfirmed-email-index into master

What does this MR do?

Create index for users.unconfirmed_email

This speeds up the following query:

SELECT
    users.*
FROM
    users
WHERE
    users.unconfirmed_email = ?
ORDER BY
    users.id ASC
LIMIT 1

Context is https://gitlab.com/gitlab-org/gitlab-ce/issues/66958.

Conformity

  • Changelog entry for user-facing changes, or community contribution. Check the link for other scenarios.

Performance and Testing

More testing in https://gitlab.com/gitlab-org/gitlab-ce/snippets/1892156

Edited by Andreas Brandl

Merge request reports