mastodon/db/migrate/20200917222316_add_index_notifications_on_type.rb

class AddIndexNotificationsOnType < ActiveRecord::Migration[5.2]
  disable_ddl_transaction!

  def change
    add_index :notifications, [:account_id, :id, :type], order: { id: :desc }, algorithm: :concurrently
  end
end