misskey
misskey copied to clipboard
Published
20 hours ago •
misskey-dev
misskey-dev
重複しているインデックスを削除してパフォーマンスを向上させる
Summary
PgHeroがインデックスの重複を出してきたので整理した方がパフォーマンスの向上に繋がるかもしれない おま環かも
PgHero曰く
Duplicate Indexes
These indexes exist, but aren’t needed. Remove them for faster writes.
Details
On announcement_readIDX_8288151386172b8109f7239ab2 (userId)
is covered by
IDX_924fa71815cfa3941d003702a0 (userId, announcementId)
On antenna_noteIDX_bd0397be22147e17210940e125 (noteId)
is covered by
IDX_335a0bf3f904406f9ef3dd51c2 (noteId, antennaId)
On blockingIDX_0627125f1a8a42c9a1929edb55 (blockerId)
is covered by
IDX_98a1bc5cb30dfd159de056549f (blockerId, blockeeId)
On channel_followingIDX_6d8084ec9496e7334a4602707e (followerId)
is covered by
IDX_2e230dd45a10e671d781d99f3e (followerId, followeeId)
On channel_note_piningIDX_8125f950afd3093acb10d2db8a (channelId)
is covered by
IDX_f36fed37d6d4cdcc68c803cd9c (channelId, noteId)
On clip_noteIDX_a012eaf5c87c65da1deb5fdbfa (noteId)
is covered by
IDX_6fc0ec357d55a18646262fdfff (noteId, clipId)
On drive_fileIDX_860fa6f6c7df5bb887249fba22 (userId)
is covered by
IDX_55720b33a61a7c806a8215b825 (userId, folderId, id)
On emojiIDX_b37dafc86e9af007e3295c2781 (name)
is covered by
IDX_4f4d35e1256c84ae3d1f0eab10 (name, host)
On flash_likeIDX_60c4af1c19a7a75f1592f93b28 (userId)
is covered by
IDX_cfbfeeccb0cbedcd660b17eb07 (userId, flashId)
On follow_requestIDX_a7fd92dd6dc519e6fb435dd108 (followerId)
is covered by
IDX_d54a512b822fac7ed52800f6b4 (followerId, followeeId)
On followingIDX_6516c5a6f3c015b4eed39978be (followerId)
is covered by
IDX_307be5f1d1252e0388662acb96 (followerId, followeeId)
On gallery_likeIDX_8fd5215095473061855ceb948c (userId)
is covered by
IDX_df1b5f4099e99fb0bc5eae53b6 (userId, postId)
On muted_noteIDX_70ab9786313d78e4201d81cdb8 (noteId)
is covered by
IDX_a8c6bfd637d3f1d67a27c48e27 (noteId, userId)
On mutingIDX_93060675b4a79a577f31d260c6 (muterId)
is covered by
IDX_1eb9d9824a630321a29fd3b290 (muterId, muteeId)
On note_favoriteIDX_47f4b1892f5d6ba8efb3057d81 (userId)
is covered by
IDX_0f4fb9ad355f3effff221ef245 (userId, noteId)
On note_reactionIDX_13761f64257f40c5636d0ff95e (userId)
is covered by
IDX_ad0c221b25672daf2df320a817 (userId, noteId)
On note_thread_mutingIDX_29c11c7deb06615076f8c95b80 (userId)
is covered by
IDX_ae7aab18a2641d3e5f25e0c4ea (userId, threadId)
On note_unreadIDX_56b0166d34ddae49d8ef7610bb (userId)
is covered by
IDX_d908433a4953cc13216cd9c274 (userId, noteId)
On note_watchingIDX_b0134ec406e8d09a540f818288 (userId)
is covered by
IDX_a42c93c69989ce1d09959df4cf (userId, noteId)
On pageIDX_ae1d917992dd0c9d9bbdad06c4 (userId)
is covered by
IDX_2133ef8317e4bdb839c0dcbf13 (userId, name)
On page_likeIDX_0e61efab7f88dbb79c9166dbb4 (userId)
is covered by
IDX_4ce6fb9c70529b4c8ac46c9bfa (userId, pageId)
On poll_voteIDX_66d2bd2ee31d14bcc23069a89f (userId)
is covered by
IDX_50bd7164c5b78f1f4a42c4d21f (userId, noteId, choice)
On promo_readIDX_9657d55550c3d37bfafaf7d4b0 (userId)
is covered by
IDX_2882b8a1a07c7d281a98b6db16 (userId, noteId)
On role_assignmentIDX_db5b72c16227c97ca88734d5c2 (userId)
is covered by
IDX_0953deda7ce6e1448e935859e5 (userId, roleId)
On userIDX_a27b942a0d6dcff90e3ee9b5e8 (usernameLower)
is covered by
IDX_5deb01ae162d1d70b80d064c27 (usernameLower, host)
On user_group_invitationIDX_bfbc6305547539369fe73eb144 (userId)
is covered by
IDX_e9793f65f504e5a31fbaedbf2f (userId, userGroupId)
On user_group_inviteIDX_1039988afa3bf991185b277fe0 (userId)
is covered by
IDX_78787741f9010886796f2320a4 (userId, userGroupId)
On user_group_joiningIDX_f3a1b4bd0c7cabba958a0c0b23 (userId)
is covered by
IDX_d9ecaed8c6dc43f3592c229282 (userId, userGroupId)
On user_ipIDX_7f7f1c66f48e9a8e18a33bc515 (userId)
is covered by
IDX_361b500e06721013c124b7b6c5 (userId, ip)
On user_list_joiningIDX_d844bfc6f3f523a05189076efa (userId)
is covered by
IDX_90f7da835e4c10aca6853621e1 (userId, userListId)
On user_note_piningIDX_bfbc6f79ba4007b4ce5097f08d (userId)
is covered by
IDX_410cd649884b501c02d6e72738 (userId, noteId)
