PgHero

Space

Database Size: 17.6 MB

101 unused indices. Remove them for faster writes. 

rails generate migration remove_unused_indexes

And paste

remove_index :ir_model_data, name: "ir_model_data_model_res_id_index"
remove_index :ir_module_module, name: "ir_module_module_name_index"
remove_index :ir_attachment, name: "ir_attachment_checksum_index"
remove_index :ir_model_fields, name: "ir_model_fields_model_index"
remove_index :ir_model_fields, name: "ir_model_fields_name_index"
remove_index :ir_attachment, name: "ir_attachment_res_idx"
remove_index :ir_model_fields, name: "ir_model_fields_complete_name_index"
remove_index :ir_model_fields, name: "ir_model_fields_model_id_index"
remove_index :ir_model_fields, name: "ir_model_fields_state_index"
remove_index :ir_module_module_dependency, name: "ir_module_module_dependency_name_index"
remove_index :ir_act_window_group_rel, name: "ir_act_window_group_rel_act_id_idx"
remove_index :ir_act_window_group_rel, name: "ir_act_window_group_rel_gid_idx"
remove_index :ir_actions_todo, name: "ir_actions_todo_action_id_index"
remove_index :ir_attachment, name: "ir_attachment_url_index"
remove_index :ir_config_parameter, name: "ir_config_parameter_key_index"
remove_index :ir_default, name: "ir_default_company_id_index"
remove_index :ir_default, name: "ir_default_field_id_index"
remove_index :ir_default, name: "ir_default_user_id_index"
remove_index :ir_mail_server, name: "ir_mail_server_name_index"
remove_index :ir_model_access, name: "ir_model_access_group_id_index"
remove_index :ir_model_access, name: "ir_model_access_model_id_index"
remove_index :ir_model_access, name: "ir_model_access_name_index"
remove_index :ir_model_constraint, name: "ir_model_constraint_model_index"
remove_index :ir_model_constraint, name: "ir_model_constraint_module_index"
remove_index :ir_model_constraint, name: "ir_model_constraint_name_index"
remove_index :ir_model_constraint, name: "ir_model_constraint_type_index"
remove_index :ir_model, name: "ir_model_model_index"
remove_index :ir_model_relation, name: "ir_model_relation_model_index"
remove_index :ir_model_relation, name: "ir_model_relation_module_index"
remove_index :ir_model_relation, name: "ir_model_relation_name_index"
remove_index :ir_module_category, name: "ir_module_category_name_index"
remove_index :ir_module_category, name: "ir_module_category_parent_id_index"
remove_index :ir_module_module, name: "ir_module_module_category_id_index"
remove_index :ir_module_module_exclusion, name: "ir_module_module_exclusion_name_index"
remove_index :ir_module_module, name: "ir_module_module_state_index"
remove_index :ir_rule, name: "ir_rule_model_id_index"
remove_index :ir_rule, name: "ir_rule_name_index"
remove_index :ir_ui_menu_group_rel, name: "ir_ui_menu_group_rel_gid_idx"
remove_index :ir_ui_menu_group_rel, name: "ir_ui_menu_group_rel_menu_id_idx"
remove_index :ir_ui_menu, name: "ir_ui_menu_parent_id_index"
remove_index :ir_ui_menu, name: "ir_ui_menu_parent_left_index"
remove_index :ir_ui_menu, name: "ir_ui_menu_parent_right_index"
remove_index :ir_ui_view, name: "ir_ui_view_inherit_id_index"
remove_index :ir_ui_view, name: "ir_ui_view_model_index"
remove_index :ir_ui_view, name: "ir_ui_view_model_type_inherit_id"
remove_index :res_bank, name: "res_bank_bic_index"
remove_index :res_company, name: "res_company_parent_id_index"
remove_index :res_company_users_rel, name: "res_company_users_rel_cid_idx"
remove_index :res_company_users_rel, name: "res_company_users_rel_user_id_idx"
remove_index :res_country_res_country_group_rel, name: "res_country_res_country_group_rel_res_country_group_id_idx"
remove_index :res_country_res_country_group_rel, name: "res_country_res_country_group_rel_res_country_id_idx"
remove_index :res_groups, name: "res_groups_category_id_index"
remove_index :res_groups_implied_rel, name: "res_groups_implied_rel_gid_idx"
remove_index :res_groups_implied_rel, name: "res_groups_implied_rel_hid_idx"
remove_index :res_groups_users_rel, name: "res_groups_users_rel_gid_idx"
remove_index :res_groups_users_rel, name: "res_groups_users_rel_uid_idx"
remove_index :res_partner, name: "res_partner_commercial_partner_id_index"
remove_index :res_partner, name: "res_partner_company_id_index"
remove_index :res_partner, name: "res_partner_date_index"
remove_index :res_partner, name: "res_partner_display_name_index"
remove_index :res_partner, name: "res_partner_name_index"
remove_index :res_partner, name: "res_partner_parent_id_index"
remove_index :res_partner, name: "res_partner_ref_index"
remove_index :rule_group_rel, name: "rule_group_rel_group_id_idx"
remove_index :rule_group_rel, name: "rule_group_rel_rule_group_id_idx"
remove_index :ir_exports_line, name: "ir_exports_line_export_id_index"
remove_index :ir_exports, name: "ir_exports_resource_index"
remove_index :ir_logging, name: "ir_logging_dbname_index"
remove_index :ir_logging, name: "ir_logging_level_index"
remove_index :ir_logging, name: "ir_logging_type_index"
remove_index :ir_model_fields_group_rel, name: "ir_model_fields_group_rel_field_id_idx"
remove_index :ir_model_fields_group_rel, name: "ir_model_fields_group_rel_group_id_idx"
remove_index :ir_property, name: "ir_property_company_id_index"
remove_index :ir_property, name: "ir_property_fields_id_index"
remove_index :ir_property, name: "ir_property_name_index"
remove_index :ir_property, name: "ir_property_res_id_index"
remove_index :ir_property, name: "ir_property_type_index"
remove_index :ir_translation, name: "ir_translation_comments_index"
remove_index :ir_translation, name: "ir_translation_ltn"
remove_index :ir_translation, name: "ir_translation_module_index"
remove_index :ir_translation, name: "ir_translation_res_id_index"
remove_index :ir_translation, name: "ir_translation_src_md5"
remove_index :ir_translation, name: "ir_translation_type_index"
remove_index :ir_ui_view_custom, name: "ir_ui_view_custom_ref_id_index"
remove_index :ir_ui_view_custom, name: "ir_ui_view_custom_user_id_index"
remove_index :ir_ui_view_custom, name: "ir_ui_view_custom_user_id_ref_id"
remove_index :ir_ui_view_group_rel, name: "ir_ui_view_group_rel_group_id_idx"
remove_index :ir_ui_view_group_rel, name: "ir_ui_view_group_rel_view_id_idx"
remove_index :rel_modules_langexport, name: "rel_modules_langexport_module_id_idx"
remove_index :rel_modules_langexport, name: "rel_modules_langexport_wiz_id_idx"
remove_index :rel_server_actions, name: "rel_server_actions_action_id_idx"
remove_index :rel_server_actions, name: "rel_server_actions_server_id_idx"
remove_index :res_currency_rate, name: "res_currency_rate_name_index"
remove_index :res_groups_report_rel, name: "res_groups_report_rel_gid_idx"
remove_index :res_groups_report_rel, name: "res_groups_report_rel_uid_idx"
remove_index :res_partner_bank, name: "res_partner_bank_partner_id_index"
remove_index :res_partner_category, name: "res_partner_category_parent_id_index"
remove_index :res_partner_category, name: "res_partner_category_parent_left_index"
remove_index :res_partner_category, name: "res_partner_category_parent_right_index"
remove_index :res_partner_res_partner_category_rel, name: "res_partner_res_partner_category_rel_category_id_idx"
remove_index :res_partner_res_partner_category_rel, name: "res_partner_res_partner_category_rel_partner_id_idx"
Relation Size
ir_module_module 696 KB
ir_model_data 488 KB
ir_model_data_module_name_uniq_index 272 KB
ir_ui_view 264 KB
ir_model_data_model_res_id_index UNUSED 256 KB
ir_model_fields 216 KB
ir_attachment 176 KB
ir_model 168 KB
ir_model_fields_name_unique 120 KB
ir_model_data_pkey 104 KB
res_country_state 88 KB
ir_module_module_dependency 80 KB
res_country 80 KB
ir_act_window 56 KB
ir_module_module_name_index UNUSED 56 KB
ir_module_module_name_uniq 56 KB
ir_ui_menu 56 KB
name_uniq 56 KB
res_currency 56 KB
ir_model_access 48 KB
ir_model_constraint 48 KB
ir_model_fields_pkey 48 KB
res_country_state_name_code_uniq 48 KB
res_lang 48 KB
ir_attachment_checksum_index UNUSED 40 KB
ir_model_fields_model_index UNUSED 40 KB
ir_model_fields_name_index UNUSED 40 KB
ir_module_module_dependency_pkey 40 KB
ir_module_module_pkey 40 KB
ir_attachment_pkey 32 KB
ir_attachment_res_idx UNUSED 32 KB
ir_model_fields_complete_name_index UNUSED 32 KB
ir_model_fields_model_id_index UNUSED 32 KB
ir_model_fields_state_index UNUSED 32 KB
ir_module_module_dependency_name_index UNUSED 32 KB
res_country_state_pkey 32 KB
act_window_view_unique_mode_per_action 16 KB
ir_act_client 16 KB
ir_act_client_pkey 16 KB
ir_act_report_xml 16 KB
ir_act_report_xml_pkey 16 KB
ir_act_server 16 KB
ir_act_server_pkey 16 KB
ir_act_url 16 KB
ir_act_url_pkey 16 KB
ir_act_window_group_rel_act_id_gid_key 16 KB
ir_act_window_group_rel_act_id_idx UNUSED 16 KB
ir_act_window_group_rel_gid_idx UNUSED 16 KB
ir_act_window_pkey 16 KB
ir_act_window_view 16 KB
ir_act_window_view_pkey 16 KB
ir_actions_todo 16 KB
ir_actions_todo_action_id_index UNUSED 16 KB
ir_actions_todo_pkey 16 KB
ir_attachment_url_index UNUSED 16 KB
ir_config_parameter 16 KB
ir_config_parameter_key_index UNUSED 16 KB
ir_config_parameter_key_uniq 16 KB
ir_config_parameter_pkey 16 KB
ir_cron 16 KB
ir_cron_pkey 16 KB
ir_default 16 KB
ir_default_company_id_index UNUSED 16 KB
ir_default_field_id_index UNUSED 16 KB
ir_default_pkey 16 KB
ir_default_user_id_index UNUSED 16 KB
ir_mail_server 16 KB
ir_mail_server_name_index UNUSED 16 KB
ir_mail_server_pkey 16 KB
ir_model_access_group_id_index UNUSED 16 KB
ir_model_access_model_id_index UNUSED 16 KB
ir_model_access_name_index UNUSED 16 KB
ir_model_access_pkey 16 KB
ir_model_constraint_model_index UNUSED 16 KB
ir_model_constraint_module_index UNUSED 16 KB
ir_model_constraint_module_name_uniq 16 KB
ir_model_constraint_name_index UNUSED 16 KB
ir_model_constraint_pkey 16 KB
ir_model_constraint_type_index UNUSED 16 KB
ir_model_model_index UNUSED 16 KB
ir_model_obj_name_uniq 16 KB
ir_model_pkey 16 KB
ir_model_relation 16 KB
ir_model_relation_model_index UNUSED 16 KB
ir_model_relation_module_index UNUSED 16 KB
ir_model_relation_name_index UNUSED 16 KB
ir_model_relation_pkey 16 KB
ir_module_category 16 KB
ir_module_category_name_index UNUSED 16 KB
ir_module_category_parent_id_index UNUSED 16 KB
ir_module_category_pkey 16 KB
ir_module_module_category_id_index UNUSED 16 KB
ir_module_module_exclusion 16 KB
ir_module_module_exclusion_name_index UNUSED 16 KB
ir_module_module_exclusion_pkey 16 KB
ir_module_module_state_index UNUSED 16 KB
ir_rule 16 KB
ir_rule_model_id_index UNUSED 16 KB
ir_rule_name_index UNUSED 16 KB
ir_rule_pkey 16 KB
ir_ui_menu_group_rel_gid_idx UNUSED 16 KB
ir_ui_menu_group_rel_menu_id_gid_key 16 KB
ir_ui_menu_group_rel_menu_id_idx UNUSED 16 KB
ir_ui_menu_parent_id_index UNUSED 16 KB
ir_ui_menu_parent_left_index UNUSED 16 KB
ir_ui_menu_parent_right_index UNUSED 16 KB
ir_ui_menu_pkey 16 KB
ir_ui_view_inherit_id_index UNUSED 16 KB
ir_ui_view_model_index UNUSED 16 KB
ir_ui_view_model_type_inherit_id UNUSED 16 KB
ir_ui_view_pkey 16 KB
report_paperformat 16 KB
report_paperformat_pkey 16 KB
res_bank 16 KB
res_bank_bic_index UNUSED 16 KB
res_bank_pkey 16 KB
res_company 16 KB
res_company_name_uniq 16 KB
res_company_parent_id_index UNUSED 16 KB
res_company_pkey 16 KB
res_company_users_rel_cid_idx UNUSED 16 KB
res_company_users_rel_cid_user_id_key 16 KB
res_company_users_rel_user_id_idx UNUSED 16 KB
res_country_code_uniq 16 KB
res_country_group 16 KB
res_country_group_pkey 16 KB
res_country_name_uniq 16 KB
res_country_pkey 16 KB
res_country_res_country_group_rel_res_country_group_id_idx UNUSED 16 KB
res_country_res_country_group_rel_res_country_id_idx UNUSED 16 KB
res_country_res_country_group_res_country_id_res_country_gr_key 16 KB
res_currency_pkey 16 KB
res_currency_unique_name 16 KB
res_groups 16 KB
res_groups_category_id_index UNUSED 16 KB
res_groups_implied_rel_gid_hid_key 16 KB
res_groups_implied_rel_gid_idx UNUSED 16 KB
res_groups_implied_rel_hid_idx UNUSED 16 KB
res_groups_name_uniq 16 KB
res_groups_pkey 16 KB
res_groups_users_rel_gid_idx UNUSED 16 KB
res_groups_users_rel_gid_uid_key 16 KB
res_groups_users_rel_uid_idx UNUSED 16 KB
res_lang_code_uniq 16 KB
res_lang_name_uniq 16 KB
res_lang_pkey 16 KB
res_partner 16 KB
res_partner_commercial_partner_id_index UNUSED 16 KB
res_partner_company_id_index UNUSED 16 KB
res_partner_date_index UNUSED 16 KB
res_partner_display_name_index UNUSED 16 KB
res_partner_industry 16 KB
res_partner_industry_pkey 16 KB
res_partner_name_index UNUSED 16 KB
res_partner_parent_id_index UNUSED 16 KB
res_partner_pkey 16 KB
res_partner_ref_index UNUSED 16 KB
res_partner_title 16 KB
res_partner_title_pkey 16 KB
res_request_link 16 KB
res_request_link_pkey 16 KB
res_users 16 KB
res_users_login_key 16 KB
res_users_pkey 16 KB
rule_group_rel_group_id_idx UNUSED 16 KB
rule_group_rel_rule_group_id_group_id_key 16 KB
rule_group_rel_rule_group_id_idx UNUSED 16 KB
base_import_import 8 KB
base_import_import_pkey 8 KB
base_import_tests_models_char 8 KB
base_import_tests_models_char_noreadonly 8 KB
base_import_tests_models_char_noreadonly_pkey 8 KB
base_import_tests_models_char_pkey 8 KB
base_import_tests_models_char_readonly 8 KB
base_import_tests_models_char_readonly_pkey 8 KB
base_import_tests_models_char_required 8 KB
base_import_tests_models_char_required_pkey 8 KB
base_import_tests_models_char_states 8 KB
base_import_tests_models_char_states_pkey 8 KB
base_import_tests_models_char_stillreadonly 8 KB
base_import_tests_models_char_stillreadonly_pkey 8 KB
base_import_tests_models_m2o_pkey 8 KB
base_import_tests_models_m2o_related_pkey 8 KB
base_import_tests_models_m2o_required_pkey 8 KB
base_import_tests_models_m2o_required_related_pkey 8 KB
base_import_tests_models_o2m_child_pkey 8 KB
base_import_tests_models_o2m_pkey 8 KB
base_import_tests_models_preview 8 KB
base_import_tests_models_preview_pkey 8 KB
base_language_export 8 KB
base_language_export_pkey 8 KB
base_language_import 8 KB
base_language_import_pkey 8 KB
base_language_install 8 KB
base_language_install_pkey 8 KB
base_module_uninstall_pkey 8 KB
base_module_update 8 KB
base_module_update_pkey 8 KB
base_module_upgrade 8 KB
base_module_upgrade_pkey 8 KB
base_update_translations 8 KB
base_update_translations_pkey 8 KB
change_password_user 8 KB
change_password_user_pkey 8 KB
change_password_wizard_pkey 8 KB
iap_account 8 KB
iap_account_pkey 8 KB
ir_act_window_group_rel 8 KB
ir_actions 8 KB
ir_actions_pkey 8 KB
ir_exports 8 KB
ir_exports_line 8 KB
ir_exports_line_export_id_index UNUSED 8 KB
ir_exports_line_pkey 8 KB
ir_exports_pkey 8 KB
ir_exports_resource_index UNUSED 8 KB
ir_filters 8 KB
ir_filters_name_model_uid_unique 8 KB
ir_filters_name_model_uid_unique_action_index 8 KB
ir_filters_pkey 8 KB
ir_logging 8 KB
ir_logging_dbname_index UNUSED 8 KB
ir_logging_level_index UNUSED 8 KB
ir_logging_pkey 8 KB
ir_logging_type_index UNUSED 8 KB
ir_model_fields_group_rel_field_id_group_id_key 8 KB
ir_model_fields_group_rel_field_id_idx UNUSED 8 KB
ir_model_fields_group_rel_group_id_idx UNUSED 8 KB
ir_property 8 KB
ir_property_company_id_index UNUSED 8 KB
ir_property_fields_id_index UNUSED 8 KB
ir_property_name_index UNUSED 8 KB
ir_property_pkey 8 KB
ir_property_res_id_index UNUSED 8 KB
ir_property_type_index UNUSED 8 KB
ir_sequence 8 KB
ir_sequence_date_range_pkey 8 KB
ir_sequence_pkey 8 KB
ir_server_object_lines 8 KB
ir_server_object_lines_pkey 8 KB
ir_translation 8 KB
ir_translation_comments_index UNUSED 8 KB
ir_translation_ltn UNUSED 8 KB
ir_translation_module_index UNUSED 8 KB
ir_translation_pkey 8 KB
ir_translation_res_id_index UNUSED 8 KB
ir_translation_src_md5 UNUSED 8 KB
ir_translation_type_index UNUSED 8 KB
ir_ui_menu_group_rel 8 KB
ir_ui_view_custom 8 KB
ir_ui_view_custom_pkey 8 KB
ir_ui_view_custom_ref_id_index UNUSED 8 KB
ir_ui_view_custom_user_id_index UNUSED 8 KB
ir_ui_view_custom_user_id_ref_id UNUSED 8 KB
ir_ui_view_group_rel_group_id_idx UNUSED 8 KB
ir_ui_view_group_rel_view_id_group_id_key 8 KB
ir_ui_view_group_rel_view_id_idx UNUSED 8 KB
rel_modules_langexport_module_id_idx UNUSED 8 KB
rel_modules_langexport_wiz_id_idx UNUSED 8 KB
rel_modules_langexport_wiz_id_module_id_key 8 KB
rel_server_actions_action_id_idx UNUSED 8 KB
rel_server_actions_server_id_action_id_key 8 KB
rel_server_actions_server_id_idx UNUSED 8 KB
res_company_users_rel 8 KB
res_config_installer_pkey 8 KB
res_config_pkey 8 KB
res_config_settings_pkey 8 KB
res_country_res_country_group_rel 8 KB
res_currency_rate 8 KB
res_currency_rate_name_index UNUSED 8 KB
res_currency_rate_pkey 8 KB
res_currency_rate_unique_name_per_day 8 KB
res_groups_implied_rel 8 KB
res_groups_report_rel_gid_idx UNUSED 8 KB
res_groups_report_rel_uid_gid_key 8 KB
res_groups_report_rel_uid_idx UNUSED 8 KB
res_groups_users_rel 8 KB
res_partner_bank 8 KB
res_partner_bank_partner_id_index UNUSED 8 KB
res_partner_bank_pkey 8 KB
res_partner_bank_unique_number 8 KB
res_partner_category 8 KB
res_partner_category_parent_id_index UNUSED 8 KB
res_partner_category_parent_left_index UNUSED 8 KB
res_partner_category_parent_right_index UNUSED 8 KB
res_partner_category_pkey 8 KB
res_partner_res_partner_category_rel_category_id_idx UNUSED 8 KB
res_partner_res_partner_category_rel_category_id_partner_id_key 8 KB
res_partner_res_partner_category_rel_partner_id_idx UNUSED 8 KB
res_users_log_pkey 8 KB
rule_group_rel 8 KB
web_editor_converter_test 8 KB
web_editor_converter_test_pkey 8 KB
web_editor_converter_test_sub 8 KB
web_editor_converter_test_sub_pkey 8 KB
web_planner 8 KB
web_planner_pkey 8 KB
web_tour_tour 8 KB
web_tour_tour_pkey 8 KB
wizard_ir_model_menu_create 8 KB
wizard_ir_model_menu_create_pkey 8 KB
base_import_tests_models_m2o 0 Bytes
base_import_tests_models_m2o_related 0 Bytes
base_import_tests_models_m2o_required 0 Bytes
base_import_tests_models_m2o_required_related 0 Bytes
base_import_tests_models_o2m 0 Bytes
base_import_tests_models_o2m_child 0 Bytes
base_module_uninstall 0 Bytes
change_password_wizard 0 Bytes
ir_model_fields_group_rel 0 Bytes
ir_sequence_date_range 0 Bytes
ir_ui_view_group_rel 0 Bytes
rel_modules_langexport 0 Bytes
rel_server_actions 0 Bytes
res_config 0 Bytes
res_config_installer 0 Bytes
res_config_settings 0 Bytes
res_groups_report_rel 0 Bytes
res_partner_res_partner_category_rel 0 Bytes
res_users_log 0 Bytes