How to add WHERE discarded_at IS NULL

[erick-ol]

I ran the unindexed_deleted_at rake to see what was going on and I received a bunch of indexes to add the WHERE discarded_at IS NULL but I don't know how I can do this. I am using the discard gem to do the soft delete.

What I am receiving:

consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_alignment_id - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_brand_id - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_discarded_at - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_repair_from_job_id - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_slug - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_status - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_tribe_id - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_uuid - a partial index can speed lookups of soft-deletable models
consider adding `WHERE discarded_at IS NULL` or `WHERE discarded_at IS NOT NULL` to index_jobs_on_yu_contact_id - a partial index can speed lookups of soft-deletable models

[erick-ol]

I already discover it by creating a migration using the example below:

def change
  remove_index :jobs, name: :index_jobs_on_area_id
  add_index :jobs, :area_id, where: 'discarded_at IS NULL'
end

To update an index you need to remove it first and then create in the right way after