Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :alert_rule_tag, name: "IDX_alert_rule_tag_alert_id", column: :alert_id remove_index :api_key, name: "IDX_api_key_org_id", column: :org_id remove_index :builtin_role, name: "IDX_builtin_role_org_id", column: :org_id remove_index :correlation, name: "IDX_correlation_uid", column: :uid remove_index :dashboard, name: "IDX_dashboard_org_id", column: :org_id remove_index :dashboard_acl, name: "IDX_dashboard_acl_dashboard_id", column: :dashboard_id remove_index :dashboard_provisioning, name: "IDX_dashboard_provisioning_dashboard_id", column: :dashboard_id remove_index :dashboard_version, name: "IDX_dashboard_version_dashboard_id", column: :dashboard_id remove_index :data_source, name: "IDX_data_source_org_id", column: :org_id remove_index :org_user, name: "IDX_org_user_org_id", column: :org_id remove_index :role, name: "IDX_role_org_id", column: :org_id remove_index :team, name: "IDX_team_org_id", column: :org_id remove_index :team_member, name: "IDX_team_member_org_id", column: :org_id remove_index :team_role, name: "IDX_team_role_org_id", column: :org_id remove_index :user_role, name: "IDX_user_role_org_id", column: :org_id
| Details |
|---|
On alert_rule_tag
IDX_alert_rule_tag_alert_id (alert_id)is covered by UQE_alert_rule_tag_alert_id_tag_id (alert_id, tag_id) |
On api_key
IDX_api_key_org_id (org_id)is covered by UQE_api_key_org_id_name (org_id, name) |
On builtin_role
IDX_builtin_role_org_id (org_id)is covered by UQE_builtin_role_org_id_role_id_role (org_id, role_id, role) |
On correlation
IDX_correlation_uid (uid)is covered by correlation_pkey1 (uid, org_id, source_uid) |
On dashboard
IDX_dashboard_org_id (org_id)is covered by UQE_dashboard_org_id_uid (org_id, uid) |
On dashboard_acl
IDX_dashboard_acl_dashboard_id (dashboard_id)is covered by UQE_dashboard_acl_dashboard_id_user_id (dashboard_id, user_id) |
On dashboard_provisioning
IDX_dashboard_provisioning_dashboard_id (dashboard_id)is covered by IDX_dashboard_provisioning_dashboard_id_name (dashboard_id, name) |
On dashboard_version
IDX_dashboard_version_dashboard_id (dashboard_id)is covered by UQE_dashboard_version_dashboard_id_version (dashboard_id, version) |
On data_source
IDX_data_source_org_id (org_id)is covered by UQE_data_source_org_id_uid (org_id, uid) |
On org_user
IDX_org_user_org_id (org_id)is covered by UQE_org_user_org_id_user_id (org_id, user_id) |
On role
IDX_role_org_id (org_id)is covered by UQE_role_org_id_name (org_id, name) |
On team
IDX_team_org_id (org_id)is covered by UQE_team_org_id_uid (org_id, uid) |
On team_member
IDX_team_member_org_id (org_id)is covered by UQE_team_member_org_id_team_id_user_id (org_id, team_id, user_id) |
On team_role
IDX_team_role_org_id (org_id)is covered by UQE_team_role_org_id_team_id_role_id (org_id, team_id, role_id) |
On user_role
IDX_user_role_org_id (org_id)is covered by UQE_user_role_org_id_user_id_role_id_group_mapping_uid (org_id, user_id, role_id, group_mapping_uid) |