1 files changed, 0 insertions, 54 deletions
diff --git a/db/migrate/20200930094812_update_postgres_indexes_view.rb b/db/migrate/20200930094812_update_postgres_indexes_view.rb
deleted file mode 100644
index b36ea362e6f..00000000000
--- a/db/migrate/20200930094812_update_postgres_indexes_view.rb
+++ /dev/null
@@ -1,54 +0,0 @@
-# frozen_string_literal: true
-
-class UpdatePostgresIndexesView < ActiveRecord::Migration[6.0]
-  DOWNTIME = false
-
-  def up
-    execute(<<~SQL)
-      CREATE OR REPLACE VIEW postgres_indexes AS
-      SELECT
-        pg_namespace.nspname || '.' || pg_class.relname as identifier,
-        pg_index.indexrelid,
-        pg_namespace.nspname as schema,
-        pg_class.relname as name,
-        pg_index.indisunique as unique,
-        pg_index.indisvalid as valid_index,
-        pg_class.relispartition as partitioned,
-        pg_index.indisexclusion as exclusion,
-        pg_indexes.indexdef as definition,
-        pg_relation_size(pg_class.oid) as ondisk_size_bytes
-      FROM pg_index
-      INNER JOIN pg_class ON pg_class.oid = pg_index.indexrelid
-      INNER JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid
-      INNER JOIN pg_indexes ON pg_class.relname = pg_indexes.indexname
-      WHERE pg_namespace.nspname <> 'pg_catalog'
-        AND pg_namespace.nspname IN (
-          current_schema(),
-          'gitlab_partitions_dynamic',
-          'gitlab_partitions_static'
-        )
-    SQL
-  end
-
-  def down
-    execute(<<~SQL)
-      CREATE OR REPLACE VIEW postgres_indexes AS
-      SELECT
-        pg_namespace.nspname || '.' || pg_class.relname as identifier,
-        pg_index.indexrelid,
-        pg_namespace.nspname as schema,
-        pg_class.relname as name,
-        pg_index.indisunique as unique,
-        pg_index.indisvalid as valid_index,
-        pg_class.relispartition as partitioned,
-        pg_index.indisexclusion as exclusion,
-        pg_indexes.indexdef as definition,
-        pg_relation_size(pg_class.oid) as ondisk_size_bytes
-      FROM pg_index
-      INNER JOIN pg_class ON pg_class.oid = pg_index.indexrelid
-      INNER JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid
-      INNER JOIN pg_indexes ON pg_class.relname = pg_indexes.indexname
-      WHERE pg_namespace.nspname <> 'pg_catalog'
-    SQL
-  end
-end