1 files changed, 17 insertions, 0 deletions
diff --git a/db/post_migrate/20240111131500_add_async_index_merge_request_metrics_on_merged_by_id_target_project_id_m_r_id.rb b/db/post_migrate/20240111131500_add_async_index_merge_request_metrics_on_merged_by_id_target_project_id_m_r_id.rb
new file mode 100644
index 00000000000..cec9020f20b
--- /dev/null
+++ b/db/post_migrate/20240111131500_add_async_index_merge_request_metrics_on_merged_by_id_target_project_id_m_r_id.rb
@@ -0,0 +1,17 @@
+# frozen_string_literal: true
+
+class AddAsyncIndexMergeRequestMetricsOnMergedByIdTargetProjectIdMRId < Gitlab::Database::Migration[2.2]
+  milestone '16.9'
+
+  TABLE_NAME = :merge_request_metrics
+  INDEX_NAME = :idx_merge_request_metrics_on_merged_by_project_and_mr
+  INDEX_COLUMNS = %i[merged_by_id target_project_id merge_request_id]
+
+  def up
+    prepare_async_index TABLE_NAME, INDEX_COLUMNS, name: INDEX_NAME
+  end
+
+  def down
+    unprepare_async_index TABLE_NAME, INDEX_COLUMNS, name: INDEX_NAME
+  end
+end