PgHero

Space

Database Size: 204 MB

91 unused indices. Remove them for faster writes.

Relation Size
site_settings_zipcode_pkey 39.8 MB
site_settings_zipcode_value_47599c63_like UNUSED 39.8 MB
site_settings_zipcode_value_key 39.8 MB
site_settings_zipcode 39.2 MB
recipe_recipe 6.98 MB
recipe_ingredient 4.07 MB
recipe_ingredient_pkey 1.5 MB
recipe_ingredient_recipe_id_f514f422 1.49 MB
recipe_ingredient_custom_unit_id_6c72fb20 UNUSED 1.16 MB
recipe_ingredient_basic_ingredient_id_47b68ea6 UNUSED 1.11 MB
stats_statrecord 880 KB
recipe_recipe_source_url_e847b45c_uniq 728 KB
recipe_recipe_source_url_e847b45c_like UNUSED 720 KB
stats_statrecord_date_content_type_id_object_id_254d146f_uniq 688 KB
stats_viewscounter 672 KB
stats_statrecord_pkey 648 KB
stats_statrecord_shares_counter_id_key 648 KB
stats_statrecord_views_counter_id_key 648 KB
stats_sharescounter 600 KB
stats_sharescounter_pkey 544 KB
stats_viewscounter_pkey 544 KB
silk_response 528 KB
stats_statrecord_content_type_id_7daf3a3c UNUSED 464 KB
users_outstandingtoken 408 KB
recipe_recipeimage 400 KB
silk_sqlquery 320 KB
recipe_recipe_user_id_publish_status_status_idx 240 KB
recipe_recipe_source_id_45e3b9f6_uniq 208 KB
recipe_recipe_status_provider_id_5e36c1fc UNUSED 192 KB
recipe_recipe_pkey 184 KB
recipe_recipeimage_recipe_id_3d470cfd 184 KB
users_outstandingtoken_jti_47b42996_like UNUSED 184 KB
users_outstandingtoken_jti_key 184 KB
recipe_recipe_user_id_3eb7547f UNUSED 176 KB
recipe_recipeimage_pkey 176 KB
recipe_recipeimage_user_id_fd88e7d2 UNUSED 176 KB
silk_request 176 KB
notifications_notify 160 KB
django_admin_log 152 KB
site_settings_parserdata 144 KB
recipe_basicingredient 136 KB
django_session 128 KB
recipe_basicingredient_title_c29efe22_like UNUSED 112 KB
recipe_basicingredient_title_en_32c8ac92_like UNUSED 112 KB
recipe_basicingredient_title_en_key 112 KB
recipe_basicingredient_title_key 112 KB
recipe_basicingredient_title_nl_c5bd490d_like UNUSED 112 KB
recipe_basicingredient_title_nl_key 112 KB
recipe_recipestep 112 KB
users_outstandingtoken_user_id_7ade9188 UNUSED 104 KB
users_user 104 KB
django_admin_log_content_type_id_c4bce8eb UNUSED 96 KB
django_admin_log_user_id_c564eba6 UNUSED 96 KB
recipe_basicingredient_pkey 88 KB
users_outstandingtoken_pkey 88 KB
django_admin_log_pkey 80 KB
notifications_notify_pkey 80 KB
notifications_notify_user_id_b4f901b1 UNUSED 80 KB
recipe_basicingredient_group_id_fa70c479 UNUSED 80 KB
recipe_ingredientgroup 80 KB
users_userviewhistoryrecord 80 KB
users_userviewhistoryrecord_recipe_id_cfb0d444 UNUSED 80 KB
users_userviewhistoryrecord_user_id_57d1b2a7 UNUSED 80 KB
users_userviewhistoryrecord_user_id_recipe_id_c0dc3c79_uniq 80 KB
django_migrations 72 KB
recipe_ingredientgroup_u_ingredientgroup_id_unit__fdcdfcd4_uniq 72 KB
recipe_ingredientgroup_units_ingredientgroup_id_a6c59b68 UNUSED 64 KB
recipe_ingredientgroup_units_pkey 64 KB
recipe_ingredientgroup_units_unit_id_642658cb UNUSED 64 KB
users_userviewhistoryrecord_pkey 64 KB
auth_permission 56 KB
payments_paymentrequest 56 KB
silk_request_id_5a356c4f_like UNUSED 56 KB
silk_request_pkey 56 KB
silk_response_id_dda88710_like UNUSED 56 KB
silk_response_pkey 56 KB
silk_response_request_id_1e8e2776_like UNUSED 56 KB
silk_response_request_id_key 56 KB
recipe_ingredientgroup_units 48 KB
silk_request_view_name_68559f7b UNUSED 48 KB
silk_request_view_name_68559f7b_like UNUSED 48 KB
social_auth_usersocialauth 48 KB
social_like 48 KB
django_content_type 40 KB
django_session_pkey 40 KB
django_session_session_key_c0390e0f_like UNUSED 40 KB
silk_request_path_9f3d798e UNUSED 40 KB
silk_request_path_9f3d798e_like UNUSED 40 KB
auth_permission_content_type_id_codename_01ab375a_uniq 32 KB
cart_address 32 KB
chef_pencils_chefpencilrecord 32 KB
recipe_recipereview 32 KB
recipe_unit 32 KB
silk_request_start_time_1300bc58 UNUSED 32 KB
cart_cart 24 KB
chef_pencils_chefpencilimage 24 KB
chef_pencils_savedchefpencilrecord 24 KB
order_order 24 KB
recipe_recipevideo 24 KB
recipe_savedrecipe 24 KB
auth_group_name_a6ea08ec_like UNUSED 16 KB
auth_group_name_key 16 KB
auth_group_permissions_group_id_b120cbf9 UNUSED 16 KB
auth_group_permissions_group_id_permission_id_0cd325b0_uniq 16 KB
auth_group_permissions_permission_id_84c5c92e UNUSED 16 KB
auth_group_permissions_pkey 16 KB
auth_group_pkey 16 KB
auth_permission_content_type_id_2f476e4b UNUSED 16 KB
auth_permission_pkey 16 KB
cart_address_pkey 16 KB
cart_address_user_id_e46fbfa1 16 KB
cart_cart_pkey 16 KB
cart_cart_user_id_key 16 KB
cart_cart_user_id_user_uuid_24b2b47b_uniq 16 KB
cart_cartproduct_cart_id_55d1af26 UNUSED 16 KB
cart_cartproduct_content_type_id_11e28e0e UNUSED 16 KB
cart_cartproduct_pkey 16 KB
chef_pencils_attachment_chefpencil_record_id_e2c480b6 16 KB
chef_pencils_attachment_pkey 16 KB
chef_pencils_chefpencilcategory_pkey 16 KB
chef_pencils_chefpencilrec_chefpencil_record_id_bf0dc80c 16 KB
chef_pencils_chefpencilrecord_pkey 16 KB
chef_pencils_chefpencilrecord_user_id_79ce4ff3 UNUSED 16 KB
chef_pencils_chefpencilrecordcategorylink_category_id_2314e6ff UNUSED 16 KB
chef_pencils_chefpencilrecordcategorylink_pkey 16 KB
chef_pencils_savedchefpenc_chef_pencil_record_id_b18ff7e9 UNUSED 16 KB
chef_pencils_savedchefpencilrecord_pkey 16 KB
chef_pencils_savedchefpencilrecord_user_id_78a08e3f UNUSED 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_expire_date_a5c62663 UNUSED 16 KB
order_deliveryregion_location_c004f38a_like UNUSED 16 KB
order_deliveryregion_location_c004f38a_uniq 16 KB
order_deliveryregion_pkey 16 KB
order_order_address_id_f6eb43ad UNUSED 16 KB
order_order_payment_request_id_45b78ffe_uniq 16 KB
order_order_pkey 16 KB
order_order_user_id_7cf9bc2b UNUSED 16 KB
order_orderproduct 16 KB
order_orderproducts_content_type_id_48b43179 UNUSED 16 KB
order_orderproducts_order_id_55be4b9d UNUSED 16 KB
order_orderproducts_pkey 16 KB
payments_paymentrequest_pkey 16 KB
payments_paymentrequest_user_id_9e81f4a9 UNUSED 16 KB
recipe_ingredientgroup_parent_id_d3993d22 UNUSED 16 KB
recipe_ingredientgroup_pkey 16 KB
recipe_recipereview_pkey 16 KB
recipe_recipereview_recipe_id_e6dd2e83 UNUSED 16 KB
recipe_recipereview_user_id_783047f7 UNUSED 16 KB
recipe_recipestep_pkey 16 KB
recipe_recipestep_recipe_id_a982f983 16 KB
recipe_recipevideo_pkey 16 KB
recipe_recipevideo_recipe_id_key 16 KB
recipe_recipevideo_user_id_eddbe056 UNUSED 16 KB
recipe_savedrecipe_pkey 16 KB
recipe_savedrecipe_recipe_id_aaae7bf5 UNUSED 16 KB
recipe_savedrecipe_user_id_1a837aad UNUSED 16 KB
recipe_savedrecipe_user_id_recipe_id_ad955cd2_uniq 16 KB
recipe_unit_pkey 16 KB
silk_sqlquery_pkey 16 KB
silk_sqlquery_request_id_6f8f0527 UNUSED 16 KB
silk_sqlquery_request_id_6f8f0527_like UNUSED 16 KB
site_settings_banner_pkey 16 KB
site_settings_block 16 KB
site_settings_block_pkey 16 KB
site_settings_featuredrecipe_pkey 16 KB
site_settings_featuredrecipe_recipe_id_key 16 KB
site_settings_homepagepinnedrecipe_pkey 16 KB
site_settings_homepagepinnedrecipe_recipe_id_key 16 KB
site_settings_mealoftheweekrecipe_pkey 16 KB
site_settings_mealoftheweekrecipe_recipe_id_key 16 KB
site_settings_parserdata_date_de657d0a_uniq 16 KB
site_settings_parserdata_pkey 16 KB
site_settings_recipeparameterscheckpoint_pkey 16 KB
site_settings_topratedrecipe_pkey 16 KB
site_settings_topratedrecipe_recipe_id_key 16 KB
site_settings_weekmenu_pkey 16 KB
site_settings_weekmenu_recipe1_id_90929d1a UNUSED 16 KB
site_settings_weekmenu_recipe2_id_240f79b4 UNUSED 16 KB
site_settings_weekmenu_recipe3_id_c1efc8df UNUSED 16 KB
site_settings_weekmenu_recipe4_id_14d927d0 UNUSED 16 KB
site_settings_weekmenu_recipe5_id_962f3199 UNUSED 16 KB
social_auth_usersocialauth_pkey 16 KB
social_auth_usersocialauth_provider_uid_e6b5e668_uniq 16 KB
social_auth_usersocialauth_uid_796e51dc UNUSED 16 KB
social_auth_usersocialauth_uid_796e51dc_like UNUSED 16 KB
social_auth_usersocialauth_user_id_17d28448 UNUSED 16 KB
social_like_content_type_id_41c5dd37 UNUSED 16 KB
social_like_pkey 16 KB
social_like_user_id_09067f26 UNUSED 16 KB
social_like_user_id_content_type_id_object_id_5a7e6f07_uniq 16 KB
social_rating_content_type_id_8b7802d3 UNUSED 16 KB
social_rating_pkey 16 KB
social_rating_user_id_4fc3d978 UNUSED 16 KB
social_rating_user_id_content_type_id__5d7e1966_uniq 16 KB
users_favoriterecipe_pkey 16 KB
users_favoriterecipe_recipe_id_cff90a8a UNUSED 16 KB
users_favoriterecipe_user_id_c82adc5b 16 KB
users_rolemodel_pkey 16 KB
users_rolemodel_user_id_8fc2520e 16 KB
users_user_email_243f6e77_like UNUSED 16 KB
users_user_email_key 16 KB
users_user_groups_group_id_9afc8d0e UNUSED 16 KB
users_user_groups_pkey 16 KB
users_user_groups_user_id_5f6f5a90 UNUSED 16 KB
users_user_groups_user_id_group_id_b88eab82_uniq 16 KB
users_user_pkey 16 KB
users_workexperiencerecord_pkey 16 KB
users_workexperiencerecord_user_id_39b4760b 16 KB
auth_group 8 KB
auth_group_permissions 8 KB
cart_cartproduct 8 KB
chef_pencils_chefpencilcategory 8 KB
chef_pencils_chefpencilrecordcategorylink 8 KB
order_deliveryregion 8 KB
recipe_tag_pkey 8 KB
recipe_tag_text_f78fecf4_like UNUSED 8 KB
recipe_tag_text_key 8 KB
recipe_tagreciperelation_pkey 8 KB
recipe_tagreciperelation_recipe_id_4bc4c791 UNUSED 8 KB
recipe_tagreciperelation_tag_id_41055dee UNUSED 8 KB
recipe_tagreciperelation_tag_id_recipe_id_3288019e_uniq 8 KB
silk_profile 8 KB
silk_profile_pkey 8 KB
silk_profile_queries_pkey 8 KB
silk_profile_queries_profile_id_a3d76db8 UNUSED 8 KB
silk_profile_queries_profile_id_sqlquery_id_b2403d9b_uniq 8 KB
silk_profile_queries_sqlquery_id_155df455 UNUSED 8 KB
silk_profile_request_id_7b81bd69 UNUSED 8 KB
silk_profile_request_id_7b81bd69_like UNUSED 8 KB
site_settings_banner 8 KB
site_settings_featuredrecipe 8 KB
site_settings_homepagepinnedrecipe 8 KB
site_settings_mealoftheweekrecipe 8 KB
site_settings_recipecheckpoint 8 KB
site_settings_support_pkey 8 KB
site_settings_support_user_id_704cbc71 UNUSED 8 KB
site_settings_topratedrecipe 8 KB
site_settings_weekmenu 8 KB
social_auth_association 8 KB
social_auth_association_pkey 8 KB
social_auth_association_server_url_handle_078befa2_uniq 8 KB
social_auth_code_code_a2393167 UNUSED 8 KB
social_auth_code_code_a2393167_like UNUSED 8 KB
social_auth_code_email_code_801b2d02_uniq 8 KB
social_auth_code_pkey 8 KB
social_auth_code_timestamp_176b341f UNUSED 8 KB
social_auth_nonce_pkey 8 KB
social_auth_nonce_server_url_timestamp_salt_f6284463_uniq 8 KB
social_auth_partial 8 KB
social_auth_partial_pkey 8 KB
social_auth_partial_timestamp_50f2119f UNUSED 8 KB
social_auth_partial_token_3017fea3 UNUSED 8 KB
social_auth_partial_token_3017fea3_like UNUSED 8 KB
social_comment 8 KB
social_comment_content_type_id_66a72a60 8 KB
social_comment_pkey 8 KB
social_comment_user_id_1de4ccfb UNUSED 8 KB
social_commentlike_comment_id_282fb416 UNUSED 8 KB
social_commentlike_pkey 8 KB
social_commentlike_user_id_4c7df38a UNUSED 8 KB
social_commentlike_user_id_comment_id_229186eb_uniq 8 KB
social_rating 8 KB
users_blacklistedtoken_pkey 8 KB
users_blacklistedtoken_token_id_key 8 KB
users_favoriterecipe 8 KB
users_rolemodel 8 KB
users_supplierdocument_pkey 8 KB
users_supplierdocument_user_id_021dab13 UNUSED 8 KB
users_supplierprofile 8 KB
users_supplierprofile_pkey 8 KB
users_supplierprofile_user_id_key 8 KB
users_user_groups 8 KB
users_user_user_permissions_permission_id_0b93982e UNUSED 8 KB
users_user_user_permissions_pkey 8 KB
users_user_user_permissions_user_id_20aca447 UNUSED 8 KB
users_user_user_permissions_user_id_permission_id_43338c45_uniq 8 KB
users_workexperiencerecord 8 KB
recipe_tag 0 Bytes
recipe_tagreciperelation 0 Bytes
silk_profile_queries 0 Bytes
site_settings_support 0 Bytes
social_auth_code 0 Bytes
social_auth_nonce 0 Bytes
social_commentlike 0 Bytes
users_blacklistedtoken 0 Bytes
users_supplierdocument 0 Bytes
users_user_user_permissions 0 Bytes