diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/post_migrate/20221206012013_add_index_author_id_created_at_on_merge_requests.rb | 15 | ||||
| -rw-r--r-- | db/schema_migrations/20221206012013 | 1 | ||||
| -rw-r--r-- | db/structure.sql | 2 |
3 files changed, 18 insertions, 0 deletions
diff --git a/db/post_migrate/20221206012013_add_index_author_id_created_at_on_merge_requests.rb b/db/post_migrate/20221206012013_add_index_author_id_created_at_on_merge_requests.rb new file mode 100644 index 00000000000..886d8aed71a --- /dev/null +++ b/db/post_migrate/20221206012013_add_index_author_id_created_at_on_merge_requests.rb @@ -0,0 +1,15 @@ +# frozen_string_literal: true + +class AddIndexAuthorIdCreatedAtOnMergeRequests < Gitlab::Database::Migration[2.0] + INDEX_NAME = 'index_merge_requests_on_author_id_and_created_at' + + disable_ddl_transaction! + + def up + add_concurrent_index :merge_requests, %i[author_id created_at], name: INDEX_NAME + end + + def down + remove_concurrent_index_by_name :merge_requests, INDEX_NAME + end +end diff --git a/db/schema_migrations/20221206012013 b/db/schema_migrations/20221206012013 new file mode 100644 index 00000000000..a7cfcc43f7c --- /dev/null +++ b/db/schema_migrations/20221206012013 @@ -0,0 +1 @@ +52294ac9fd807fdff49d918d6b49c071b53e683a479af6beef9449302080e44f
\ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index 3c884e05285..f7523d18f6b 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -29844,6 +29844,8 @@ CREATE INDEX index_merge_requests_on_assignee_id ON merge_requests USING btree ( CREATE INDEX index_merge_requests_on_author_id ON merge_requests USING btree (author_id); +CREATE INDEX index_merge_requests_on_author_id_and_created_at ON merge_requests USING btree (author_id, created_at); + CREATE INDEX index_merge_requests_on_author_id_and_id ON merge_requests USING btree (author_id, id); CREATE INDEX index_merge_requests_on_author_id_and_target_project_id ON merge_requests USING btree (author_id, target_project_id); |