diff options
| author | Roman Chvanikov <chvanikoff@pm.me> | 2020-05-09 13:13:26 +0300 |
|---|---|---|
| committer | Roman Chvanikov <chvanikoff@pm.me> | 2020-05-09 13:13:26 +0300 |
| commit | 56819f7f0604e5d4eb69edba1d6828256acbc7fe (patch) | |
| tree | 468864a073a1c3f02f22f42cf35c7f04175e52f2 | |
| parent | 4f265397179e7286f27fafaf8365a0edc6972448 (diff) | |
| download | pleroma-56819f7f0604e5d4eb69edba1d6828256acbc7fe.tar.gz | |
Use index on refresh_counter_cache
| -rw-r--r-- | lib/mix/tasks/pleroma/refresh_counter_cache.ex | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/mix/tasks/pleroma/refresh_counter_cache.ex b/lib/mix/tasks/pleroma/refresh_counter_cache.ex index b44e2545d..efcbaa3b1 100644 --- a/lib/mix/tasks/pleroma/refresh_counter_cache.ex +++ b/lib/mix/tasks/pleroma/refresh_counter_cache.ex @@ -42,7 +42,7 @@ defmodule Mix.Tasks.Pleroma.RefreshCounterCache do Activity |> where([a], fragment("(? ->> 'type'::text) = 'Create'", a.data)) - |> where([a], like(a.actor, ^"%#{instance}%")) + |> where([a], fragment("split_part(?, '/', 3) = ?", a.actor, ^instance)) |> select( [a], {fragment( |