PgHero
No long running queries
Connections healthy 7
Vacuuming healthy
No columns near integer overflow
No invalid indexes or constraints
13 duplicate indexes
No suggested indexes
1 slow query

Duplicate Indexes

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

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 recipe_ingredientgroup_units
recipe_ingredientgroup_units_ingredientgroup_id_a6c59b68 (ingredientgroup_id)
is covered by
recipe_ingredientgroup_u_ingredientgroup_id_unit__fdcdfcd4_uniq (ingredientgroup_id, unit_id)
On recipe_recipe
recipe_recipe_user_id_3eb7547f (user_id)
is covered by
recipe_recipe_user_id_publish_status_status_idx (user_id, publish_status, status)
On recipe_savedrecipe
recipe_savedrecipe_user_id_1a837aad (user_id)
is covered by
recipe_savedrecipe_user_id_recipe_id_ad955cd2_uniq (user_id, recipe_id)
On recipe_tagreciperelation
recipe_tagreciperelation_tag_id_41055dee (tag_id)
is covered by
recipe_tagreciperelation_tag_id_recipe_id_3288019e_uniq (tag_id, recipe_id)
On silk_profile_queries
silk_profile_queries_profile_id_a3d76db8 (profile_id)
is covered by
silk_profile_queries_profile_id_sqlquery_id_b2403d9b_uniq (profile_id, sqlquery_id)
On social_commentlike
social_commentlike_user_id_4c7df38a (user_id)
is covered by
social_commentlike_user_id_comment_id_229186eb_uniq (user_id, comment_id)
On social_like
social_like_user_id_09067f26 (user_id)
is covered by
social_like_user_id_content_type_id_object_id_5a7e6f07_uniq (user_id, content_type_id, object_id)
On social_rating
social_rating_user_id_4fc3d978 (user_id)
is covered by
social_rating_user_id_content_type_id__5d7e1966_uniq (user_id, content_type_id, object_id, rating_type)
On users_user_groups
users_user_groups_user_id_5f6f5a90 (user_id)
is covered by
users_user_groups_user_id_group_id_b88eab82_uniq (user_id, group_id)
On users_user_user_permissions
users_user_user_permissions_user_id_20aca447 (user_id)
is covered by
users_user_user_permissions_user_id_permission_id_43338c45_uniq (user_id, permission_id)
On users_userviewhistoryrecord
users_userviewhistoryrecord_user_id_57d1b2a7 (user_id)
is covered by
users_userviewhistoryrecord_user_id_recipe_id_c0dc3c79_uniq (user_id, recipe_id)

Slow Queries

Slow queries take 20 ms or more on average and have been called at least 100 times.

Explain queries to see where to add indexes.

Total Time Average Time Calls
0 min 18% 27 ms 161 main
SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/