Make use of the indices.

Indices in postgresql rely on operators, so they won't be used if you use only functions.
2 jobs for i1t/pleroma-477_user_search_improvements in 5 minutes and 37 seconds (queued for 3 seconds)
Status Job ID Name Coverage
  Lint
passed #14013
lint

00:03:12

 
  Test
failed #14014
unit-testing

00:02:24

 
Name Stage Failure
failed
unit-testing Test
Pleroma.CaptchaTest
* test Kocaptcha new and validate * test Kocaptcha new and validate (0.09ms)


Finished in 83.4 seconds
833 tests, 1 failure, 10 skipped

Randomized with seed 450123
ERROR: Job failed: exit code 1