Duplicate Indexes

These indexes exist, but aren’t needed. Remove them for faster writes.

rails generate migration remove_unneeded_indexes

And paste

remove_index :ir_act_window_group_rel, name: "ir_act_window_group_rel_act_id_idx", column: :act_id
remove_index :ir_config_parameter, name: "ir_config_parameter_key_index", column: :key
remove_index :ir_model, name: "ir_model_model_index", column: :model
remove_index :ir_model_constraint, name: "ir_model_constraint_name_index", column: :name
remove_index :ir_model_fields, name: "ir_model_fields_model_index", column: :model
remove_index :ir_model_fields_group_rel, name: "ir_model_fields_group_rel_field_id_idx", column: :field_id
remove_index :ir_module_module, name: "ir_module_module_name_index", column: :name
remove_index :ir_ui_menu_group_rel, name: "ir_ui_menu_group_rel_menu_id_idx", column: :menu_id
remove_index :ir_ui_view, name: "ir_ui_view_model_index", column: :model
remove_index :ir_ui_view_custom, name: "ir_ui_view_custom_user_id_index", column: :user_id
remove_index :ir_ui_view_group_rel, name: "ir_ui_view_group_rel_view_id_idx", column: :view_id
remove_index :rel_modules_langexport, name: "rel_modules_langexport_wiz_id_idx", column: :wiz_id
remove_index :rel_server_actions, name: "rel_server_actions_server_id_idx", column: :server_id
remove_index :res_company_users_rel, name: "res_company_users_rel_cid_idx", column: :cid
remove_index :res_country_res_country_group_rel, name: "res_country_res_country_group_rel_res_country_id_idx", column: :res_country_id
remove_index :res_currency_rate, name: "res_currency_rate_name_index", column: :name
remove_index :res_groups, name: "res_groups_category_id_index", column: :category_id
remove_index :res_groups_implied_rel, name: "res_groups_implied_rel_gid_idx", column: :gid
remove_index :res_groups_report_rel, name: "res_groups_report_rel_uid_idx", column: :uid
remove_index :res_groups_users_rel, name: "res_groups_users_rel_gid_idx", column: :gid
remove_index :res_partner_res_partner_category_rel, name: "res_partner_res_partner_category_rel_category_id_idx", column: :category_id
remove_index :rule_group_rel, name: "rule_group_rel_rule_group_id_idx", column: :rule_group_id

Details
On ir_act_window_group_rel ir_act_window_group_rel_act_id_idx (act_id) is covered by ir_act_window_group_rel_act_id_gid_key (act_id, gid)
On ir_config_parameter ir_config_parameter_key_index (key) is covered by ir_config_parameter_key_uniq (key)
On ir_model ir_model_model_index (model) is covered by ir_model_obj_name_uniq (model)
On ir_model_constraint ir_model_constraint_name_index (name) is covered by ir_model_constraint_module_name_uniq (name, module)
On ir_model_fields ir_model_fields_model_index (model) is covered by ir_model_fields_name_unique (model, name)
On ir_model_fields_group_rel ir_model_fields_group_rel_field_id_idx (field_id) is covered by ir_model_fields_group_rel_field_id_group_id_key (field_id, group_id)
On ir_module_module ir_module_module_name_index (name) is covered by name_uniq (name)
On ir_ui_menu_group_rel ir_ui_menu_group_rel_menu_id_idx (menu_id) is covered by ir_ui_menu_group_rel_menu_id_gid_key (menu_id, gid)
On ir_ui_view ir_ui_view_model_index (model) is covered by ir_ui_view_model_type_inherit_id (model, inherit_id)
On ir_ui_view_custom ir_ui_view_custom_user_id_index (user_id) is covered by ir_ui_view_custom_user_id_ref_id (user_id, ref_id)
On ir_ui_view_group_rel ir_ui_view_group_rel_view_id_idx (view_id) is covered by ir_ui_view_group_rel_view_id_group_id_key (view_id, group_id)
On rel_modules_langexport rel_modules_langexport_wiz_id_idx (wiz_id) is covered by rel_modules_langexport_wiz_id_module_id_key (wiz_id, module_id)
On rel_server_actions rel_server_actions_server_id_idx (server_id) is covered by rel_server_actions_server_id_action_id_key (server_id, action_id)
On res_company_users_rel res_company_users_rel_cid_idx (cid) is covered by res_company_users_rel_cid_user_id_key (cid, user_id)
On res_country_res_country_group_rel res_country_res_country_group_rel_res_country_id_idx (res_country_id) is covered by res_country_res_country_group_res_country_id_res_country_gr_key (res_country_id, res_country_group_id)
On res_currency_rate res_currency_rate_name_index (name) is covered by res_currency_rate_unique_name_per_day (name, currency_id, company_id)
On res_groups res_groups_category_id_index (category_id) is covered by res_groups_name_uniq (category_id, name)
On res_groups_implied_rel res_groups_implied_rel_gid_idx (gid) is covered by res_groups_implied_rel_gid_hid_key (gid, hid)
On res_groups_report_rel res_groups_report_rel_uid_idx (uid) is covered by res_groups_report_rel_uid_gid_key (uid, gid)
On res_groups_users_rel res_groups_users_rel_gid_idx (gid) is covered by res_groups_users_rel_gid_uid_key (gid, uid)
On res_partner_res_partner_category_rel res_partner_res_partner_category_rel_category_id_idx (category_id) is covered by res_partner_res_partner_category_rel_category_id_partner_id_key (category_id, partner_id)
On rule_group_rel rule_group_rel_rule_group_id_idx (rule_group_id) is covered by rule_group_rel_rule_group_id_group_id_key (rule_group_id, group_id)

Details

On ir_act_window_group_rel

ir_act_window_group_rel_act_id_idx (act_id)

is covered by

ir_act_window_group_rel_act_id_gid_key (act_id, gid)

On ir_config_parameter

ir_config_parameter_key_index (key)

is covered by

ir_config_parameter_key_uniq (key)

On ir_model

ir_model_model_index (model)

is covered by

ir_model_obj_name_uniq (model)

On ir_model_constraint

ir_model_constraint_name_index (name)

is covered by

ir_model_constraint_module_name_uniq (name, module)

On ir_model_fields

ir_model_fields_model_index (model)

is covered by

ir_model_fields_name_unique (model, name)

On ir_model_fields_group_rel

ir_model_fields_group_rel_field_id_idx (field_id)

is covered by

ir_model_fields_group_rel_field_id_group_id_key (field_id, group_id)

On ir_module_module

ir_module_module_name_index (name)

is covered by

name_uniq (name)

On ir_ui_menu_group_rel

ir_ui_menu_group_rel_menu_id_idx (menu_id)

is covered by

ir_ui_menu_group_rel_menu_id_gid_key (menu_id, gid)

On ir_ui_view

ir_ui_view_model_index (model)

is covered by

ir_ui_view_model_type_inherit_id (model, inherit_id)

On ir_ui_view_custom

ir_ui_view_custom_user_id_index (user_id)

is covered by

ir_ui_view_custom_user_id_ref_id (user_id, ref_id)

On ir_ui_view_group_rel

ir_ui_view_group_rel_view_id_idx (view_id)

is covered by

ir_ui_view_group_rel_view_id_group_id_key (view_id, group_id)

On rel_modules_langexport

rel_modules_langexport_wiz_id_idx (wiz_id)

is covered by

rel_modules_langexport_wiz_id_module_id_key (wiz_id, module_id)

On rel_server_actions

rel_server_actions_server_id_idx (server_id)

is covered by

rel_server_actions_server_id_action_id_key (server_id, action_id)

On res_company_users_rel

res_company_users_rel_cid_idx (cid)

is covered by

res_company_users_rel_cid_user_id_key (cid, user_id)

On res_country_res_country_group_rel

res_country_res_country_group_rel_res_country_id_idx (res_country_id)

is covered by

res_country_res_country_group_res_country_id_res_country_gr_key (res_country_id, res_country_group_id)

On res_currency_rate

res_currency_rate_name_index (name)

is covered by

res_currency_rate_unique_name_per_day (name, currency_id, company_id)

On res_groups

res_groups_category_id_index (category_id)

is covered by

res_groups_name_uniq (category_id, name)

On res_groups_implied_rel

res_groups_implied_rel_gid_idx (gid)

is covered by

res_groups_implied_rel_gid_hid_key (gid, hid)

On res_groups_report_rel

res_groups_report_rel_uid_idx (uid)

is covered by

res_groups_report_rel_uid_gid_key (uid, gid)

On res_groups_users_rel

res_groups_users_rel_gid_idx (gid)

is covered by

res_groups_users_rel_gid_uid_key (gid, uid)

On res_partner_res_partner_category_rel

res_partner_res_partner_category_rel_category_id_idx (category_id)

is covered by

res_partner_res_partner_category_rel_category_id_partner_id_key (category_id, partner_id)

On rule_group_rel

rule_group_rel_rule_group_id_idx (rule_group_id)

is covered by

rule_group_rel_rule_group_id_group_id_key (rule_group_id, group_id)

Duplicate Indexes

Query Stats