about summary refs log tree commit diff
path: root/db/migrate
diff options
context:
space:
mode:
authorEugen Rochko <eugen@zeonfederated.com>2017-04-07 00:04:09 +0200
committerEugen Rochko <eugen@zeonfederated.com>2017-04-07 00:04:38 +0200
commit31597fd37717db79edb69a64c97b1dca2f9a8a08 (patch)
tree799a9e9c5936afd482ce73edbc89bf6f3488591d /db/migrate
parent8cb7d157bd5df803d72499bbb39ac9631189628d (diff)
Low-hanging fruit of query optimization, these indices were missing
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20170406215816_add_notifications_and_favourites_indices.rb7
1 files changed, 7 insertions, 0 deletions
diff --git a/db/migrate/20170406215816_add_notifications_and_favourites_indices.rb b/db/migrate/20170406215816_add_notifications_and_favourites_indices.rb
new file mode 100644
index 000000000..00e41bf3a
--- /dev/null
+++ b/db/migrate/20170406215816_add_notifications_and_favourites_indices.rb
@@ -0,0 +1,7 @@
+class AddNotificationsAndFavouritesIndices < ActiveRecord::Migration[5.0]
+  def change
+    add_index :notifications, [:activity_id, :activity_type]
+    add_index :accounts, :url
+    add_index :favourites, :status_id
+  end
+end