pleroma

commit: bee8b64fa79b74a8fa9a862956d80018eebc2966
parent f25ef1aa7f4ba547c543eec0ec1c42d14f131d02
Author: Lain Soykaf <lain@lain.com>
Date:   Fri, 14 Mar 2025 19:41:46 +0400

Migrations: Add activities_actor_type index

Diffstat:
A
changelog.d/activity_type_index.change
1
+
A
priv/repo/migrations/20250314153704_add_activities_actor_type_index.exs
7
+++++++

2 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/changelog.d/activity_type_index.change b/changelog.d/activity_type_index.change
@@ -0,0 +1 @@
+Add new activity actor/type index. Greatly speeds up retrieval of rare types (like "Listen")
diff --git a/priv/repo/migrations/20250314153704_add_activities_actor_type_index.exs b/priv/repo/migrations/20250314153704_add_activities_actor_type_index.exs
@@ -0,0 +1,7 @@
+defmodule Pleroma.Repo.Migrations.AddActivitiesActorTypeIndex do
+  use Ecto.Migration
+
+  def change do
+    create(index(:activities, ["actor", "(data ->> 'type'::text)", "id DESC NULLS LAST"]))
+  end
+end