AddObjectConcurrentIndexes: add missing object index

1 files changed, 7 insertions, 0 deletions

diff --git a/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs b/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs
index d6809f692..3d112d172 100644
--- a/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs
+++ b/priv/repo/migrations/20211231013155_add_object_concurrent_indexes.exs
@@ -29,5 +29,12 @@ defmodule Pleroma.Repo.Migrations.AddObjectConcurrentIndexes do
         where: "data->>'type' = 'Create'"
       )
     )
+
+    create_if_not_exists(
+      index(:objects, ["(coalesce(data->'object'->>'id', data->>'object'))"],
+        name: :objects_create_objects_index,
+        concurrently: true
+      )
+    )
   end
 end