diff options
author | Yorick Peterse <yorickpeterse@gmail.com> | 2015-11-09 17:17:40 +0100 |
---|---|---|
committer | Yorick Peterse <yorickpeterse@gmail.com> | 2015-11-19 11:46:38 +0100 |
commit | 50f654161036ac0f97d9f931dc11678a9509d083 (patch) | |
tree | 162248647cf8ba822085371e46a68aa9d42edab0 /db/migrate/20151109134526_add_issues_state_index.rb | |
parent | a42d469ab2ac13ba40544e4cb40659fb6953d548 (diff) | |
download | gitlab-ce-50f654161036ac0f97d9f931dc11678a9509d083.tar.gz |
Added index on issues.state
This field is queried when filtering issues and due to the lack of an
index would end up triggering a sequence scan.
Diffstat (limited to 'db/migrate/20151109134526_add_issues_state_index.rb')
-rw-r--r-- | db/migrate/20151109134526_add_issues_state_index.rb | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate/20151109134526_add_issues_state_index.rb b/db/migrate/20151109134526_add_issues_state_index.rb new file mode 100644 index 00000000000..1c4d2e30171 --- /dev/null +++ b/db/migrate/20151109134526_add_issues_state_index.rb @@ -0,0 +1,5 @@ +class AddIssuesStateIndex < ActiveRecord::Migration + def change + add_index :issues, :state + end +end |