1 files changed, 1 insertions, 1 deletions
diff --git a/db/post_migrate/20200831065705_ensure_target_project_id_is_filled.rb b/db/post_migrate/20200831065705_ensure_target_project_id_is_filled.rb
index 9b267933b04..8693dca0000 100644
--- a/db/post_migrate/20200831065705_ensure_target_project_id_is_filled.rb
+++ b/db/post_migrate/20200831065705_ensure_target_project_id_is_filled.rb
@@ -32,7 +32,7 @@ class EnsureTargetProjectIdIsFilled < ActiveRecord::Migration[6.0]
       )
 
       MergeRequestMetrics.connection.execute <<-SQL
-        WITH target_project_id_and_metrics_id as (
+        WITH target_project_id_and_metrics_id as #{Gitlab::Database::AsWithMaterialized.materialized_if_supported} (
           #{query_for_cte.to_sql}
         )
         UPDATE #{MergeRequestMetrics.connection.quote_table_name(MergeRequestMetrics.table_name)}