Duplicate Indexes

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

rails generate migration remove_unneeded_indexes

And paste

remove_index :auth_group_permissions, name: "auth_group_permissions_group_id_b120cbf9", column: :group_id
remove_index :auth_permission, name: "auth_permission_content_type_id_2f476e4b", column: :content_type_id
remove_index :auth_user_groups, name: "auth_user_groups_user_id_6a12ed8b", column: :user_id
remove_index :auth_user_user_permissions, name: "auth_user_user_permissions_user_id_a95ead1b", column: :user_id
remove_index :main_alert, name: "main_alert_query_id_51a10a2d", column: :query_id
remove_index :main_feed, name: "main_feed_user_id_bebf3c0c", column: :user_id
remove_index :main_frame, name: "main_frame_feed_id_c0be8123", column: :feed_id
remove_index :main_frameobject, name: "main_frameobject_frame_id_de7653e7", column: :frame_id
remove_index :main_frameobject, name: "main_frameobject_object_id_93cfc3ec", column: :object_id
remove_index :main_identity, name: "main_identity_user_id_a461608c", column: :user_id
remove_index :main_licenseplate, name: "main_licenseplate_user_id_83de9606", column: :user_id
remove_index :main_query, name: "main_query_user_id_2cb523f5", column: :user_id
remove_index :main_queryresult, name: "main_queryresult_matching_frame_id_53605855", column: :matching_frame_id
remove_index :main_queryresult, name: "main_queryresult_query_id_132781e7", column: :query_id
remove_index :main_queryresult, name: "main_queryresult_start_frame_id_a28bbd5c", column: :start_frame_id
remove_index :main_querystep, name: "main_querystep_query_id_7eb4c481", column: :query_id
remove_index :main_reidcollection, name: "main_reidcollection_object_id_8036c800", column: :object_id
remove_index :main_rule, name: "main_rule_user_id_4f721b26", column: :user_id
remove_index :main_segment, name: "main_segment_feed_id_b2aab1cf", column: :feed_id
remove_index :main_segment, name: "main_segmen_feed_id_6e1574_idx", column: [:feed_id, :start_time]
remove_index :main_vpnconfig, name: "main_vpnconfig_user_id_6fe1d370", column: :user_id

Details
On auth_group_permissions auth_group_permissions_group_id_b120cbf9 (group_id) is covered by auth_group_permissions_group_id_permission_id_0cd325b0_uniq (group_id, permission_id)
On auth_permission auth_permission_content_type_id_2f476e4b (content_type_id) is covered by auth_permission_content_type_id_codename_01ab375a_uniq (content_type_id, codename)
On auth_user_groups auth_user_groups_user_id_6a12ed8b (user_id) is covered by auth_user_groups_user_id_group_id_94350c0c_uniq (user_id, group_id)
On auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b (user_id) is covered by auth_user_user_permissions_user_id_permission_id_14a6b632_uniq (user_id, permission_id)
On main_alert main_alert_query_id_51a10a2d (query_id) is covered by idx_alert_query_user (query_id, created_at)
On main_feed main_feed_user_id_bebf3c0c (user_id) is covered by idx_feed_user_last_processed (user_id, last_processed)
On main_frame main_frame_feed_id_c0be8123 (feed_id) is covered by idx_frame_feed_created_at (feed_id, created_at)
On main_frameobject main_frameobject_frame_id_de7653e7 (frame_id) is covered by idx_frameobject_frame_label (frame_id, label)
On main_frameobject main_frameobject_object_id_93cfc3ec (object_id) is covered by idx_frameobject_object_frame (object_id, frame_id)
On main_identity main_identity_user_id_a461608c (user_id) is covered by main_identity_user_id_label_5398677a_uniq (user_id, label)
On main_licenseplate main_licenseplate_user_id_83de9606 (user_id) is covered by idx_licenseplate_user_active (user_id, is_active, last_frame_id)
On main_query main_query_user_id_2cb523f5 (user_id) is covered by idx_query_user_created (user_id, created_at)
On main_queryresult main_queryresult_matching_frame_id_53605855 (matching_frame_id) is covered by idx_queryresult_matching_frame (matching_frame_id)
On main_queryresult main_queryresult_query_id_132781e7 (query_id) is covered by idx_queryresult_query_score (query_id, average_score)
On main_queryresult main_queryresult_start_frame_id_a28bbd5c (start_frame_id) is covered by idx_queryresult_frames (start_frame_id, end_frame_id)
On main_querystep main_querystep_query_id_7eb4c481 (query_id) is covered by idx_querystep_query (query_id)
On main_reidcollection main_reidcollection_object_id_8036c800 (object_id) is covered by idx_reidcollection_object_feed (object_id, feed_id)
On main_rule main_rule_user_id_4f721b26 (user_id) is covered by idx_rule_user_active (user_id, is_active)
On main_segment main_segment_feed_id_b2aab1cf (feed_id) is covered by main_segmen_feed_id_db80c5_idx (feed_id, end_time)
On main_segment main_segmen_feed_id_6e1574_idx (feed_id, start_time) is covered by idx_segment_feed_time (feed_id, start_time, end_time)
On main_vpnconfig main_vpnconfig_user_id_6fe1d370 (user_id) is covered by main_vpnconfig_user_id_name_aa42fbcd_uniq (user_id, name)

Details

On auth_group_permissions

auth_group_permissions_group_id_b120cbf9 (group_id)

is covered by

auth_group_permissions_group_id_permission_id_0cd325b0_uniq (group_id, permission_id)

On auth_permission

auth_permission_content_type_id_2f476e4b (content_type_id)

is covered by

auth_permission_content_type_id_codename_01ab375a_uniq (content_type_id, codename)

On auth_user_groups

auth_user_groups_user_id_6a12ed8b (user_id)

is covered by

auth_user_groups_user_id_group_id_94350c0c_uniq (user_id, group_id)

On auth_user_user_permissions

auth_user_user_permissions_user_id_a95ead1b (user_id)

is covered by

auth_user_user_permissions_user_id_permission_id_14a6b632_uniq (user_id, permission_id)

On main_alert

main_alert_query_id_51a10a2d (query_id)

is covered by

idx_alert_query_user (query_id, created_at)

On main_feed

main_feed_user_id_bebf3c0c (user_id)

is covered by

idx_feed_user_last_processed (user_id, last_processed)

On main_frame

main_frame_feed_id_c0be8123 (feed_id)

is covered by

idx_frame_feed_created_at (feed_id, created_at)

On main_frameobject

main_frameobject_frame_id_de7653e7 (frame_id)

is covered by

idx_frameobject_frame_label (frame_id, label)

On main_frameobject

main_frameobject_object_id_93cfc3ec (object_id)

is covered by

idx_frameobject_object_frame (object_id, frame_id)

On main_identity

main_identity_user_id_a461608c (user_id)

is covered by

main_identity_user_id_label_5398677a_uniq (user_id, label)

On main_licenseplate

main_licenseplate_user_id_83de9606 (user_id)

is covered by

idx_licenseplate_user_active (user_id, is_active, last_frame_id)

On main_query

main_query_user_id_2cb523f5 (user_id)

is covered by

idx_query_user_created (user_id, created_at)

On main_queryresult

main_queryresult_matching_frame_id_53605855 (matching_frame_id)

is covered by

idx_queryresult_matching_frame (matching_frame_id)

On main_queryresult

main_queryresult_query_id_132781e7 (query_id)

is covered by

idx_queryresult_query_score (query_id, average_score)

On main_queryresult

main_queryresult_start_frame_id_a28bbd5c (start_frame_id)

is covered by

idx_queryresult_frames (start_frame_id, end_frame_id)

On main_querystep

main_querystep_query_id_7eb4c481 (query_id)

is covered by

idx_querystep_query (query_id)

On main_reidcollection

main_reidcollection_object_id_8036c800 (object_id)

is covered by

idx_reidcollection_object_feed (object_id, feed_id)

On main_rule

main_rule_user_id_4f721b26 (user_id)

is covered by

idx_rule_user_active (user_id, is_active)

On main_segment

main_segment_feed_id_b2aab1cf (feed_id)

is covered by

main_segmen_feed_id_db80c5_idx (feed_id, end_time)

On main_segment

main_segmen_feed_id_6e1574_idx (feed_id, start_time)

is covered by

idx_segment_feed_time (feed_id, start_time, end_time)

On main_vpnconfig

main_vpnconfig_user_id_6fe1d370 (user_id)

is covered by

main_vpnconfig_user_id_name_aa42fbcd_uniq (user_id, name)

Duplicate Indexes

Query Stats