PgHero

Space

Database Size: 9.59 GB

44 unused indices. Remove them for faster writes. 

rails generate migration remove_unused_indexes

And paste

remove_index :main_frameobject, name: "idx_frameobject_frame_label"
remove_index :main_frame, name: "idx_frame_image"
remove_index :main_frame, name: "idx_frame_feed_scene_created"
remove_index :main_frameobject, name: "main_frameobject_label_69dc6d97_like"
remove_index :main_frameobject, name: "main_frameobject_label_69dc6d97"
remove_index :main_query, name: "idx_query_completed_error"
remove_index :main_querystep, name: "main_querystep_query_id_7eb4c481"
remove_index :main_query, name: "idx_query_trigger"
remove_index :main_queryresult, name: "main_queryresult_matching_frame_id_53605855"
remove_index :django_admin_log, name: "django_admin_log_content_type_id_c4bce8eb"
remove_index :django_celery_beat_periodictask, name: "django_celery_beat_periodictask_clocked_id_47a69f82"
remove_index :django_celery_beat_periodictask, name: "django_celery_beat_periodictask_crontab_id_d3cba168"
remove_index :django_celery_beat_periodictask, name: "django_celery_beat_periodictask_interval_id_a8ca27da"
remove_index :django_celery_beat_periodictask, name: "django_celery_beat_periodictask_solar_id_a87ce72c"
remove_index :django_session, name: "django_session_expire_date_a5c62663"
remove_index :main_rule, name: "idx_rule_active_ready_global"
remove_index :main_feedroute, name: "main_feedroute_destination_id_563049ee"
remove_index :main_prompt, name: "main_prompt_title_7acb46bd_like"
remove_index :main_promptusage, name: "main_promptusage_prompt_id_1099e964"
remove_index :main_queryresult, name: "main_queryresult_segment_id_86208d38"
remove_index :main_rule, name: "main_rule_user_id_4f721b26"
remove_index :omni_session, name: "omni_session_system_prompt_id_ed4e5bd1"
remove_index :omni_session, name: "omni_session_user_id_173d1a6a"
remove_index :omni_usage, name: "omni_usage_session_id_45887ae0"
remove_index :auth_group, name: "auth_group_name_a6ea08ec_like"
remove_index :auth_group_permissions, name: "auth_group_permissions_group_id_b120cbf9"
remove_index :auth_group_permissions, name: "auth_group_permissions_permission_id_84c5c92e"
remove_index :auth_user_groups, name: "auth_user_groups_group_id_97559544"
remove_index :auth_user_groups, name: "auth_user_groups_user_id_6a12ed8b"
remove_index :auth_user_user_permissions, name: "auth_user_user_permissions_permission_id_1fbb5f2c"
remove_index :authtoken_token, name: "authtoken_token_key_10f0b77e_like"
remove_index :constance_constance, name: "constance_constance_key_c43474b0_like"
remove_index :main_alert, name: "idx_alert_review"
remove_index :main_identity, name: "idx_identity_last_detected"
remove_index :main_licenseplate, name: "idx_licenseplate_last_detected"
remove_index :main_reidcollection, name: "idx_reidcollection_object_feed"
remove_index :main_alert, name: "main_alert_query_id_51a10a2d"
remove_index :main_face, name: "main_face_identity_id_9a208770"
remove_index :main_feedgroup, name: "main_feedgroup_user_id_7ef23be7"
remove_index :main_identity, name: "main_identity_user_id_a461608c"
remove_index :main_licenseplate, name: "main_licenseplate_user_id_83de9606"
remove_index :main_reidcollection, name: "main_reidcollection_match_id_921b39c7"
remove_index :main_reidcollection, name: "main_reidcollection_object_id_8036c800"
remove_index :main_vpnconfig, name: "main_vpnconfig_user_id_6fe1d370"
Relation Size
main_frameobject 2.72 GB
idx_frameobject_frame_id_order 882 MB
idx_frameobj_obj_quality_score 735 MB
main_frame 631 MB
idx_frameobject_confidence 565 MB
main_frameobject_pkey 485 MB
idx_frameobject_object_frame 451 MB
idx_frameobject_frame_label UNUSED 440 MB
idx_frame_image UNUSED 287 MB
idx_frm_feed_scn_lkd_created 250 MB
main_frameobject_frame_id_de7653e7 235 MB
idx_frame_feed_scene_created UNUSED 234 MB
idx_frame_feed_proc_tracked 216 MB
main_frameobject_object_id_93cfc3ec 206 MB
idx_frame_feed_created_at 196 MB
main_frameobject_label_69dc6d97_like UNUSED 188 MB
main_frameobject_label_69dc6d97 UNUSED 188 MB
main_frame_id_629a63_idx 171 MB
idx_frame_timestamp 168 MB
idx_frame_created_at_id 161 MB
main_frame_pkey 124 MB
main_frame_scene_id_43fc6cbe 54.5 MB
main_frame_feed_id_c0be8123 33.3 MB
main_query 32.4 MB
main_object 16.1 MB
main_segment 8.48 MB
omni_sessionmessage 8.42 MB
detected_text_trgm_gist 7.73 MB
main_querystep 6.7 MB
idx_query_type_user 5.97 MB
idx_object_id_last_detected 4.01 MB
fo_detected_text_trgm_gist 3.73 MB
idx_query_user_created 3.44 MB
main_object_pkey 3.43 MB
idx_query_completed_error UNUSED 3.09 MB
main_segment_pkey 2.63 MB
main_query_pkey 2.16 MB
main_promptusage 1.77 MB
idx_segment_feed_time 1.36 MB
idx_segment_time_range 1.3 MB
main_segmen_feed_id_6e1574_idx 1.27 MB
main_segmen_feed_id_db80c5_idx 1.27 MB
idx_track_status 1.06 MB
main_querystep_pkey 1.05 MB
main_segment_feed_id_b2aab1cf 1.03 MB
main_object_feed_id_0c152d92 960 KB
idx_querystep_query 952 KB
main_querystep_query_id_7eb4c481 UNUSED 952 KB
main_object_label_da2c4d7e 896 KB
main_object_label_da2c4d7e_like 896 KB
main_query_frameobject_id_b83f13fb 688 KB
idx_query_trigger UNUSED 680 KB
main_query_user_id_2cb523f5 656 KB
main_feed 320 KB
main_queryresult 288 KB
omni_skill 288 KB
omni_systemprompt 104 KB
omni_usage 96 KB
django_admin_log 80 KB
django_migrations 64 KB
main_promptmessage 64 KB
django_celery_beat_periodictask 56 KB
main_rule 56 KB
omni_sessionmessage_pkey 48 KB
auth_permission 40 KB
django_celery_beat_intervalschedule 40 KB
django_celery_beat_periodictasks 40 KB
idx_queryresult_frames 40 KB
idx_queryresult_query_score 40 KB
main_feedroute 40 KB
omni_session 40 KB
fo_detected_plate_trgm_gist 32 KB
idx_queryresult_matching_frame 32 KB
main_queryresult_end_frame_id_2134f9ef 32 KB
main_queryresult_matching_frame_id_53605855 UNUSED 32 KB
main_queryresult_pkey 32 KB
main_queryresult_start_frame_id_a28bbd5c 32 KB
omni_sessionmessage_session_id_468ba534 32 KB
omni_usage_pkey 32 KB
admin_interface_theme 16 KB
admin_interface_theme_name_30bda70f_like 16 KB
admin_interface_theme_name_30bda70f_uniq 16 KB
admin_interface_theme_pkey 16 KB
auth_permission_content_type_id_2f476e4b 16 KB
auth_permission_content_type_id_codename_01ab375a_uniq 16 KB
auth_permission_pkey 16 KB
auth_user 16 KB
auth_user_pkey 16 KB
auth_user_username_6821ab7c_like 16 KB
auth_user_username_key 16 KB
django_admin_log_content_type_id_c4bce8eb UNUSED 16 KB
django_admin_log_pkey 16 KB
django_admin_log_user_id_c564eba6 16 KB
django_celery_beat_crontabschedule 16 KB
django_celery_beat_crontabschedule_pkey 16 KB
django_celery_beat_intervalschedule_pkey 16 KB
django_celery_beat_periodictask_clocked_id_47a69f82 UNUSED 16 KB
django_celery_beat_periodictask_crontab_id_d3cba168 UNUSED 16 KB
django_celery_beat_periodictask_interval_id_a8ca27da UNUSED 16 KB
django_celery_beat_periodictask_name_265a36b7_like 16 KB
django_celery_beat_periodictask_name_key 16 KB
django_celery_beat_periodictask_pkey 16 KB
django_celery_beat_periodictask_solar_id_a87ce72c UNUSED 16 KB
django_celery_beat_periodictasks_pkey 16 KB
django_content_type_app_label_model_76bd3d3b_uniq 16 KB
django_content_type_pkey 16 KB
django_migrations_pkey 16 KB
django_session 16 KB
django_session_expire_date_a5c62663 UNUSED 16 KB
django_session_pkey 16 KB
django_session_session_key_c0390e0f_like 16 KB
idx_feed_restart 16 KB
idx_feed_status_processor 16 KB
idx_feed_type_user 16 KB
idx_feed_user_active 16 KB
idx_feed_user_last_processed 16 KB
idx_prompt_type_active 16 KB
idx_rule_active_ready_global UNUSED 16 KB
idx_rule_user_active 16 KB
main_feed_pkey 16 KB
main_feed_user_id_bebf3c0c 16 KB
main_feed_vpn_id_b2f79d90 16 KB
main_feedroute_destination_id_563049ee UNUSED 16 KB
main_feedroute_origin_id_599d41cb 16 KB
main_feedroute_pkey 16 KB
main_feedview 16 KB
main_feedview_pkey 16 KB
main_feedview_user_id_aaa66059 16 KB
main_member_key_b2f05459_like 16 KB
main_member_key_key 16 KB
main_member_pkey 16 KB
main_member_user_id_key 16 KB
main_prompt 16 KB
main_prompt_pkey 16 KB
main_prompt_title_7acb46bd_like UNUSED 16 KB
main_prompt_title_7acb46bd_uniq 16 KB
main_promptmessage_pkey 16 KB
main_promptmessage_prompt_id_f2da8de0 16 KB
main_promptusage_pkey 16 KB
main_promptusage_prompt_id_1099e964 UNUSED 16 KB
main_queryresult_query_id_132781e7 16 KB
main_queryresult_segment_id_86208d38 UNUSED 16 KB
main_rule_pkey 16 KB
main_rule_user_id_4f721b26 UNUSED 16 KB
omni_session_client_uuid_key 16 KB
omni_session_pkey 16 KB
omni_session_system_prompt_id_ed4e5bd1 UNUSED 16 KB
omni_session_user_id_173d1a6a UNUSED 16 KB
omni_sessionattachment_message_id_0d56e144 16 KB
omni_sessionattachment_pkey 16 KB
omni_skill_pkey 16 KB
omni_skill_slug_ee75c772_like 16 KB
omni_skill_slug_key 16 KB
omni_systemprompt_pkey 16 KB
omni_systemprompt_title_37b0b632_like 16 KB
omni_systemprompt_title_key 16 KB
omni_usage_session_id_45887ae0 UNUSED 16 KB
auth_group_name_a6ea08ec_like UNUSED 8 KB
auth_group_name_key 8 KB
auth_group_permissions_group_id_b120cbf9 UNUSED 8 KB
auth_group_permissions_group_id_permission_id_0cd325b0_uniq 8 KB
auth_group_permissions_permission_id_84c5c92e UNUSED 8 KB
auth_group_permissions_pkey 8 KB
auth_group_pkey 8 KB
auth_user_groups_group_id_97559544 UNUSED 8 KB
auth_user_groups_pkey 8 KB
auth_user_groups_user_id_6a12ed8b UNUSED 8 KB
auth_user_groups_user_id_group_id_94350c0c_uniq 8 KB
auth_user_user_permissions_permission_id_1fbb5f2c UNUSED 8 KB
auth_user_user_permissions_pkey 8 KB
auth_user_user_permissions_user_id_a95ead1b 8 KB
auth_user_user_permissions_user_id_permission_id_14a6b632_uniq 8 KB
authtoken_token_key_10f0b77e_like UNUSED 8 KB
authtoken_token_pkey 8 KB
authtoken_token_user_id_key 8 KB
constance_constance 8 KB
constance_constance_key_c43474b0_like UNUSED 8 KB
constance_constance_key_key 8 KB
constance_constance_pkey 8 KB
django_celery_beat_clockedschedule_pkey 8 KB
django_celery_beat_solar_event_latitude_longitude_ba64999a_uniq 8 KB
django_celery_beat_solarschedule_pkey 8 KB
django_content_type 8 KB
idx_alert_query_user 8 KB
idx_alert_review UNUSED 8 KB
idx_alert_trigger 8 KB
idx_identity_last_detected UNUSED 8 KB
idx_identity_user_active 8 KB
idx_licenseplate_last_detected UNUSED 8 KB
idx_licenseplate_user_active 8 KB
idx_reidcollection_object_feed UNUSED 8 KB
idx_reidcollection_status 8 KB
main_alert 8 KB
main_alert_pkey 8 KB
main_alert_query_id_51a10a2d UNUSED 8 KB
main_face_identity_id_9a208770 UNUSED 8 KB
main_face_pkey 8 KB
main_feedgroup 8 KB
main_feedgroup_pkey 8 KB
main_feedgroup_user_id_7ef23be7 UNUSED 8 KB
main_identity 8 KB
main_identity_pkey 8 KB
main_identity_user_id_a461608c UNUSED 8 KB
main_identity_user_id_label_5398677a_uniq 8 KB
main_licenseplate 8 KB
main_licenseplate_pkey 8 KB
main_licenseplate_user_id_83de9606 UNUSED 8 KB
main_member 8 KB
main_reidcollection 8 KB
main_reidcollection_feed_id_38f104e1 8 KB
main_reidcollection_match_id_921b39c7 UNUSED 8 KB
main_reidcollection_object_id_8036c800 UNUSED 8 KB
main_reidcollection_pkey 8 KB
main_vpnconfig 8 KB
main_vpnconfig_pkey 8 KB
main_vpnconfig_user_id_6fe1d370 UNUSED 8 KB
main_vpnconfig_user_id_host_port_beaff954_uniq 8 KB
main_vpnconfig_user_id_name_aa42fbcd_uniq 8 KB
omni_sessionattachment 8 KB
auth_group 0 Bytes
auth_group_permissions 0 Bytes
auth_user_groups 0 Bytes
auth_user_user_permissions 0 Bytes
authtoken_token 0 Bytes
django_celery_beat_clockedschedule 0 Bytes
django_celery_beat_solarschedule 0 Bytes
main_face 0 Bytes