7783393900
65%

Ran 05 Feb 2024 11:04AM UTC

Jobs 1

Files 113

Run time 8s

Badge

Embed ▾

Committed 05 Feb 2024 10:59AM UTC coverage: 65.299%. Remained the same

Build # 7783393900

Build Type

push

github

Committed by

web-flow

Commit Message

fix: improve perf in account linking (#1394)

## What kind of change does this PR introduce?
* Currently, we use an `ilike` which doesn't use the index on
`auth.identities.email`. Since the emails in the `verifiedEmails` slice
only contains lowercased emails, and the `auth.identities.email` are
also guaranteed to be lowercase, there is no need for a case-insensitive
search
* The partial unique index (`users_email_partial_key`) in auth.users is
defined on the condition that `is_sso_user = false`. However, the query
uses `is_sso_user is false` which causes it to not use the index ever
(along with `ilike`). It would be much faster to do `lower(email) = any
(?)` rather than `email ilike any (?)`
* Fixes #1390

Run Details

7924 of 12135 relevant lines covered (65.3%)

55.47 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	7783393900.1	05 Feb 2024 11:04AM UTC	0	65.3	GitHub Action Run

Source Files on build 7783393900

Detailed source file information is not available for this build.

supabase / gotrue / 7783393900
65%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 7783393900

supabase / gotrue / 7783393900 65%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 7783393900

supabase / gotrue / 7783393900
65%

README BADGES
x