Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :scheduled_job_runs, name: "ix_jobruns_name", column: :job_name remove_index :sessions, name: "ix_sessions_token", column: :token_hash remove_index :team_memberships, name: "ix_membership_user", column: :user_id remove_index :users, name: "ix_users_email", column: :email
| Details |
|---|
On scheduled_job_runs
ix_jobruns_name (job_name)is covered by uq_job_slot (job_name, slot) |
On sessions
ix_sessions_token (token_hash)is covered by sessions_token_hash_key (token_hash) |
On team_memberships
ix_membership_user (user_id)is covered by uq_membership (user_id, team_id) |
On users
ix_users_email (email)is covered by users_email_key (email) |