diff options
| author | Alex Gleason <alex@alexgleason.me> | 2020-08-05 13:08:13 -0500 |
|---|---|---|
| committer | Alex Gleason <alex@alexgleason.me> | 2020-08-05 13:08:13 -0500 |
| commit | ad9c925efb77287316f5dbac26f6a1b16662910a (patch) | |
| tree | 288bb238e45e610ef03a12d4b287ed1679d8de5d /lib | |
| parent | afa8b469ed0a71247f27efec08d6eeac24b6674f (diff) | |
| download | pleroma-ad9c925efb77287316f5dbac26f6a1b16662910a.tar.gz pleroma-ad9c925efb77287316f5dbac26f6a1b16662910a.zip | |
Speed up instance timeline query
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/pleroma/web/activity_pub/activity_pub.ex | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/lib/pleroma/web/activity_pub/activity_pub.ex b/lib/pleroma/web/activity_pub/activity_pub.ex index 9ce2b04dd..76fc9c3ee 100644 --- a/lib/pleroma/web/activity_pub/activity_pub.ex +++ b/lib/pleroma/web/activity_pub/activity_pub.ex @@ -928,7 +928,10 @@ defmodule Pleroma.Web.ActivityPub.ActivityPub do defp restrict_muted_reblogs(query, _), do: query defp restrict_instance(query, %{instance: instance}) when is_binary(instance) do - from(activity in query, where: ilike(activity.actor, ^"%://#{instance}/%")) + from( + activity in query, + where: fragment("split_part(actor::text, '/'::text, 3) = ?", ^instance) + ) end defp restrict_instance(query, _), do: query |