Last active
June 12, 2022 06:09
-
-
Save ThinaticSystem/8f38b08893afa37a680eab5315b01158 to your computer and use it in GitHub Desktop.
Misskey12.111.0でのスロークエリログ
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Logs begin at Mon 2022-05-23 19:36:51 JST, end at Sun 2022-06-12 14:55:37 JST. -- | |
| query is slow: SELECT DISTINCT "distinctAlias"."notification_id" AS "ids_notification_id", "distinctAlias"."notification_id" FROM (SELECT "notification"."id" AS "notification_id", "notification"."createdAt" AS "notification_createdAt", "notification"."notifieeId" AS "notification_notifieeId", "notification"."notifierId" AS "notification_notifierId", "notification"."type" AS "notification_type", "notification"."isRead" AS "notification_isRead", "notification"."noteId" AS "notification_noteId", "notification"."followRequestId" AS "notification_followRequestId", "notification"."userGroupInvitationId" AS "notification_userGroupInvitationId", "notification"."reaction" AS "notification_reaction", "notification"."choice" AS "notification_choice", "notification"."customBody" AS "notification_customBody", "notification"."customHeader" AS "notification_customHeader", "notification"."customIcon" AS "notification_customIcon", "notification"."appAccessTokenId" AS "notification_appAccessTokenId", "notifier"."id" AS "notifier_id", "notifier"."createdAt" AS "notifier_createdAt", "notifier"."updatedAt" AS "notifier_updatedAt", "notifier"."lastFetchedAt" AS "notifier_lastFetchedAt", "notifier"."lastActiveDate" AS "notifier_lastActiveDate", "notifier"."hideOnlineStatus" AS "notifier_hideOnlineStatus", "notifier"."username" AS "notifier_username", "notifier"."name" AS "notifier_name", "notifier"."followersCount" AS "notifier_followersCount", "notifier"."followingCount" AS "notifier_followingCount", "notifier"."notesCount" AS "notifier_notesCount", "notifier"."avatarId" AS "notifier_avatarId", "notifier"."bannerId" AS "notifier_bannerId", "notifier"."tags" AS "notifier_tags", "notifier"."isSuspended" AS "notifier_isSuspended", "notifier"."isSilenced" AS "notifier_isSilenced", "notifier"."isLocked" AS "notifier_isLocked", "notifier"."isBot" AS "notifier_isBot", "notifier"."isCat" AS "notifier_isCat", "notifier"."isAdmin" AS "notifier_isAdmin", "notifier"."isModerator" AS "notifier_isModerator", "notifier"."isExplorable" AS "notifier_isExplorable", "notifier"."isDeleted" AS "notifier_isDeleted", "notifier"."emojis" AS "notifier_emojis", "notifier"."host" AS "notifier_host", "notifier"."inbox" AS "notifier_inbox", "notifier"."sharedInbox" AS "notifier_sharedInbox", "notifier"."featured" AS "notifier_featured", "notifier"."uri" AS "notifier_uri", "notifier"."followersUri" AS "notifier_followersUri", "notifier"."showTimelineReplies" AS "notifier_showTimelineReplies", "notifier"."token" AS "notifier_token", "note"."id" AS "note_id", "note"."createdAt" AS "note_createdAt", "note"."replyId" AS "note_replyId", "note"."renoteId" AS "note_renoteId", "note"."threadId" AS "note_threadId", "note"."text" AS "note_text", "note"."name" AS "note_name", "note"."cw" AS "note_cw", "note"."userId" AS "note_userId", "note"."localOnly" AS "note_localOnly", "note"."renoteCount" AS "note_renoteCount", "note"."repliesCount" AS "note_repliesCount", "note"."reactions" AS "note_reactions", "note"."visibility" AS "note_visibility", "note"."uri" AS "note_uri", "note"."url" AS "note_url", "note"."fileIds" AS "note_fileIds", "note"."attachedFileTypes" AS "note_attachedFileTypes", "note"."visibleUserIds" AS "note_visibleUserIds", "note"."mentions" AS "note_mentions", "note"."mentionedRemoteUsers" AS "note_mentionedRemoteUsers", "note"."emojis" AS "note_emojis", "note"."tags" AS "note_tags", "note"."hasPoll" AS "note_hasPoll", "note"."channelId" AS "note_channelId", "note"."userHost" AS "note_userHost", "note"."replyUserId" AS "note_replyUserId", "note"."replyUserHost" AS "note_replyUserHost", "note"."renoteUserId" AS "note_renoteUserId", "note"."renoteUserHost" AS "note_renoteUserHost", "notifierAvatar"."id" AS "notifierAvatar_id", "notifierAvatar"."createdAt" AS "notifierAvatar_createdAt", "notifierAvatar"."userId" AS "notifierAvatar_userId", "notifierAvatar"."userHost" AS "notifierAvatar_userHost", "notifierAvatar"."md5" AS "notifierAvatar_md5", "notifierAvatar"."name" AS "notifierAvatar_name", "notifierAvatar"."type" AS "notifierAvatar_type", "notifierAvatar"."size" AS "notifierAvatar_size", "notifierAvatar"."comment" AS "notifierAvatar_comment", "notifierAvatar"."blurhash" AS "notifierAvatar_blurhash", "notifierAvatar"."properties" AS "notifierAvatar_properties", "notifierAvatar"."storedInternal" AS "notifierAvatar_storedInternal", "notifierAvatar"."url" AS "notifierAvatar_url", "notifierAvatar"."thumbnailUrl" AS "notifierAvatar_thumbnailUrl", "notifierAvatar"."webpublicUrl" AS "notifierAvatar_webpublicUrl", "notifierAvatar"."webpublicType" AS "notifierAvatar_webpublicType", "notifierAvatar"."accessKey" AS "notifierAvatar_accessKey", "notifierAvatar"."thumbnailAccessKey" AS "notifierAvatar_thumbnailAccessKey", "notifierAvatar"."webpublicAccessKey" AS "notifierAvatar_webpublicAccessKey", "notifierAvatar"."uri" AS "notifierAvatar_uri", "notifierAvatar"."src" AS "notifierAvatar_src", "notifierAvatar"."folderId" AS "notifierAvatar_folderId", "notifierAvatar"."isSensitive" AS "notifierAvatar_isSensitive", "notifierAvatar"."isLink" AS "notifierAvatar_isLink", "notifierBanner"."id" AS "notifierBanner_id", "notifierBanner"."createdAt" AS "notifierBanner_createdAt", "notifierBanner"."userId" AS "notifierBanner_userId", "notifierBanner"."userHost" AS "notifierBanner_userHost", "notifierBanner"."md5" AS "notifierBanner_md5", "notifierBanner"."name" AS "notifierBanner_name", "notifierBanner"."type" AS "notifierBanner_type", "notifierBanner"."size" AS "notifierBanner_size", "notifierBanner"."comment" AS "notifierBanner_comment", "notifierBanner"."blurhash" AS "notifierBanner_blurhash", "notifierBanner"."properties" AS "notifierBanner_properties", "notifierBanner"."storedInternal" AS "notifierBanner_storedInternal", "notifierBanner"."url" AS "notifierBanner_url", "notifierBanner"."thumbnailUrl" AS "notifierBanner_thumbnailUrl", "notifierBanner"."webpublicUrl" AS "notifierBanner_webpublicUrl", "notifierBanner"."webpublicType" AS "notifierBanner_webpublicType", "notifierBanner"."accessKey" AS "notifierBanner_accessKey", "notifierBanner"."thumbnailAccessKey" AS "notifierBanner_thumbnailAccessKey", "notifierBanner"."webpublicAccessKey" AS "notifierBanner_webpublicAccessKey", "notifierBanner"."uri" AS "notifierBanner_uri", "notifierBanner"."src" AS "notifierBanner_src", "notifierBanner"."folderId" AS "notifierBanner_folderId", "notifierBanner"."isSensitive" AS "notifierBanner_isSensitive", "notifierBanner"."isLink" AS "notifierBanner_isLink", "user"."id" AS "user_id", "user"."createdAt" AS "user_createdAt", "user"."updatedAt" AS "user_updatedAt", "user"."lastFetchedAt" AS "user_lastFetchedAt", "user"."lastActiveDate" AS "user_lastActiveDate", "user"."hideOnlineStatus" AS "user_hideOnlineStatus", "user"."username" AS "user_username", "user"."name" AS "user_name", "user"."followersCount" AS "user_followersCount", "user"."followingCount" AS "user_followingCount", "user"."notesCount" AS "user_notesCount", "user"."avatarId" AS "user_avatarId", "user"."bannerId" AS "user_bannerId", "user"."tags" AS "user_tags", "user"."isSuspended" AS "user_isSuspended", "user"."isSilenced" AS "user_isSilenced", "user"."isLocked" AS "user_isLocked", "user"."isBot" AS "user_isBot", "user"."isCat" AS "user_isCat", "user"."isAdmin" AS "user_isAdmin", "user"."isModerator" AS "user_isModerator", "user"."isExplorable" AS "user_isExplorable", "user"."isDeleted" AS "user_isDeleted", "user"."emojis" AS "user_emojis", "user"."host" AS "user_host", "user"."inbox" AS "user_inbox", "user"."sharedInbox" AS "user_sharedInbox", "user"."featured" AS "user_featured", "user"."uri" AS "user_uri", "user"."followersUri" AS "user_followersUri", "user"."showTimelineReplies" AS "user_showTimelineReplies", "user"."token" AS "user_token", "avatar"."id" AS "avatar_id", "avatar"."createdAt" AS "avatar_createdAt", "avatar"."userId" AS "avatar_userId", "avatar"."userHost" AS "avatar_userHost", "avatar"."md5" AS "avatar_md5", "avatar"."name" AS "avatar_name", "avatar"."type" AS "avatar_type", "avatar"."size" AS "avatar_size", "avatar"."comment" AS "avatar_comment", "avatar"."blurhash" AS "avatar_blurhash", "avatar"."properties" AS "avatar_properties", "avatar"."storedInternal" AS "avatar_storedInternal", "avatar"."url" AS "avatar_url", "avatar"."thumbnailUrl" AS "avatar_thumbnailUrl", "avatar"."webpublicUrl" AS "avatar_webpublicUrl", "avatar"."webpublicType" AS "avatar_webpublicType", "avatar"."accessKey" AS "avatar_accessKey", "avatar"."thumbnailAccessKey" AS "avatar_thumbnailAccessKey", "avatar"."webpublicAccessKey" AS "avatar_webpublicAccessKey", "avatar"."uri" AS "avatar_uri", "avatar"."src" AS "avatar_src", "avatar"."folderId" AS "avatar_folderId", "avatar"."isSensitive" AS "avatar_isSensitive", "avatar"."isLink" AS "avatar_isLink", "banner"."id" AS "banner_id", "banner"."createdAt" AS "banner_createdAt", "banner"."userId" AS "banner_userId", "banner"."userHost" AS "banner_userHost", "banner"."md5" AS "banner_md5", "banner"."name" AS "banner_name", "banner"."type" AS "banner_type", "banner"."size" AS "banner_size", "banner"."comment" AS "banner_comment", "banner"."blurhash" AS "banner_blurhash", "banner"."properties" AS "banner_properties", "banner"."storedInternal" AS "banner_storedInternal", "banner"."url" AS "banner_url", "banner"."thumbnailUrl" AS "banner_thumbnailUrl", "banner"."webpublicUrl" AS "banner_webpublicUrl", "banner"."webpublicType" AS "banner_webpublicType", "banner"."accessKey" AS "banner_accessKey", "banner"."thumbnailAccessKey" AS "banner_thumbnailAccessKey", "banner"."webpublicAccessKey" AS "banner_webpublicAccessKey", "banner"."uri" AS "banner_uri", "banner"."src" AS "banner_src", "banner"."folderId" AS "banner_folderId", "banner"."isSensitive" AS "banner_isSensitive", "banner"."isLink" AS "banner_isLink", "reply"."id" AS "reply_id", "reply"."createdAt" AS "reply_createdAt", "reply"."replyId" AS "reply_replyId", "reply"."renoteId" AS "reply_renoteId", "reply"."threadId" AS "reply_threadId", "reply"."text" AS "reply_text", "reply"."name" AS "reply_name", "reply"."cw" AS "reply_cw", "reply"."userId" AS "reply_userId", "reply"."localOnly" AS "reply_localOnly", "reply"."renoteCount" AS "reply_renoteCount", "reply"."repliesCount" AS "reply_repliesCount", "reply"."reactions" AS "reply_reactions", "reply"."visibility" AS "reply_visibility", "reply"."uri" AS "reply_uri", "reply"."url" AS "reply_url", "reply"."fileIds" AS "reply_fileIds", "reply"."attachedFileTypes" AS "reply_attachedFileTypes", "reply"."visibleUserIds" AS "reply_visibleUserIds", "reply"."mentions" AS "reply_mentions", "reply"."mentionedRemoteUsers" AS "reply_mentionedRemoteUsers", "reply"."emojis" AS "reply_emojis", "reply"."tags" AS "reply_tags", "reply"."hasPoll" AS "reply_hasPoll", "reply"."channelId" AS "reply_channelId", "reply"."userHost" AS "reply_userHost", "reply"."replyUserId" AS "reply_replyUserId", "reply"."replyUserHost" AS "reply_replyUserHost", "reply"."renoteUserId" AS "reply_renoteUserId", "reply"."renoteUserHost" AS "reply_renoteUserHost", "renote"."id" AS "renote_id", "renote"."createdAt" AS "renote_createdAt", "renote"."replyId" AS "renote_replyId", "renote"."renoteId" AS "renote_renoteId", "renote"."threadId" AS "renote_threadId", "renote"."text" AS "renote_text", "renote"."name" AS "renote_name", "renote"."cw" AS "renote_cw", "renote"."userId" AS "renote_userId", "renote"."localOnly" AS "renote_localOnly", "renote"."renoteCount" AS "renote_renoteCount", "renote"."repliesCount" AS "renote_repliesCount", "renote"."reactions" AS "renote_reactions", "renote"."visibility" AS "renote_visibility", "renote"."uri" AS "renote_uri", "renote"."url" AS "renote_url", "renote"."fileIds" AS "renote_fileIds", "renote"."attachedFileTypes" AS "renote_attachedFileTypes", "renote"."visibleUserIds" AS "renote_visibleUserIds", "renote"."mentions" AS "renote_mentions", "renote"."mentionedRemoteUsers" AS "renote_mentionedRemoteUsers", "renote"."emojis" AS "renote_emojis", "renote"."tags" AS "renote_tags", "renote"."hasPoll" AS "renote_hasPoll", "renote"."channelId" AS "renote_channelId", "renote"."userHost" AS "renote_userHost", "renote"."replyUserId" AS "renote_replyUserId", "renote"."replyUserHost" AS "renote_replyUserHost", "renote"."renoteUserId" AS "renote_renoteUserId", "renote"."renoteUserHost" AS "renote_renoteUserHost", "replyUser"."id" AS "replyUser_id", "replyUser"."createdAt" AS "replyUser_createdAt", "replyUser"."updatedAt" AS "replyUser_updatedAt", "replyUser"."lastFetchedAt" AS "replyUser_lastFetchedAt", "replyUser"."lastActiveDate" AS "replyUser_lastActiveDate", "replyUser"."hideOnlineStatus" AS "replyUser_hideOnlineStatus", "replyUser"."username" AS "replyUser_username", "replyUser"."name" AS "replyUser_name", "replyUser"."followersCount" AS "replyUser_followersCount", "replyUser"."followingCount" AS "replyUser_followingCount", "replyUser"."notesCount" AS "replyUser_notesCount", "replyUser"."avatarId" AS "replyUser_avatarId", "replyUser"."bannerId" AS "replyUser_bannerId", "replyUser"."tags" AS "replyUser_tags", "replyUser"."isSuspended" AS "replyUser_isSuspended", "replyUser"."isSilenced" AS "replyUser_isSilenced", "replyUser"."isLocked" AS "replyUser_isLocked", "replyUser"."isBot" AS "replyUser_isBot", "replyUser"."isCat" AS "replyUser_isCat", "replyUser"."isAdmin" AS "replyUser_isAdmin", "replyUser"."isModerator" AS "replyUser_isModerator", "replyUser"."isExplorable" AS "replyUser_isExplorable", "replyUser"."isDeleted" AS "replyUser_isDeleted", "replyUser"."emojis" AS "replyUser_emojis", "replyUser"."host" AS "replyUser_host", "replyUser"."inbox" AS "replyUser_inbox", "replyUser"."sharedInbox" AS "replyUser_sharedInbox", "replyUser"."featured" AS "replyUser_featured", "replyUser"."uri" AS "replyUser_uri", "replyUser"."followersUri" AS "replyUser_followersUri", "replyUser"."showTimelineReplies" AS "replyUser_showTimelineReplies", "replyUser"."token" AS "replyUser_token", "replyUserAvatar"."id" AS "replyUserAvatar_id", "replyUserAvatar"."createdAt" AS "replyUserAvatar_createdAt", "replyUserAvatar"."userId" AS "replyUserAvatar_userId", "replyUserAvatar"."userHost" AS "replyUserAvatar_userHost", "replyUserAvatar"."md5" AS "replyUserAvatar_md5", "replyUserAvatar"."name" AS "replyUserAvatar_name", "replyUserAvatar"."type" AS "replyUserAvatar_type", "replyUserAvatar"."size" AS "replyUserAvatar_size", "replyUserAvatar"."comment" AS "replyUserAvatar_comment", "replyUserAvatar"."blurhash" AS "replyUserAvatar_blurhash", "replyUserAvatar"."properties" AS "replyUserAvatar_properties", "replyUserAvatar"."storedInternal" AS "replyUserAvatar_storedInternal", "replyUserAvatar"."url" AS "replyUserAvatar_url", "replyUserAvatar"."thumbnailUrl" AS "replyUserAvatar_thumbnailUrl", "replyUserAvatar"."webpublicUrl" AS "replyUserAvatar_webpublicUrl", "replyUserAvatar"."webpublicType" AS "replyUserAvatar_webpublicType", "replyUserAvatar"."accessKey" AS "replyUserAvatar_accessKey", "replyUserAvatar"."thumbnailAccessKey" AS "replyUserAvatar_thumbnailAccessKey", "replyUserAvatar"."webpublicAccessKey" AS "replyUserAvatar_webpublicAccessKey", "replyUserAvatar"."uri" AS "replyUserAvatar_uri", "replyUserAvatar"."src" AS "replyUserAvatar_src", "replyUserAvatar"."folderId" AS "replyUserAvatar_folderId", "replyUserAvatar"."isSensitive" AS "replyUserAvatar_isSensitive", "replyUserAvatar"."isLink" AS "replyUserAvatar_isLink", "replyUserBanner"."id" AS "replyUserBanner_id", "replyUserBanner"."createdAt" AS "replyUserBanner_createdAt", "replyUserBanner"."userId" AS "replyUserBanner_userId", "replyUserBanner"."userHost" AS "replyUserBanner_userHost", "replyUserBanner"."md5" AS "replyUserBanner_md5", "replyUserBanner"."name" AS "replyUserBanner_name", "replyUserBanner"."type" AS "replyUserBanner_type", "replyUserBanner"."size" AS "replyUserBanner_size", "replyUserBanner"."comment" AS "replyUserBanner_comment", "replyUserBanner"."blurhash" AS "replyUserBanner_blurhash", "replyUserBanner"."properties" AS "replyUserBanner_properties", "replyUserBanner"."storedInternal" AS "replyUserBanner_storedInternal", "replyUserBanner"."url" AS "replyUserBanner_url", "replyUserBanner"."thumbnailUrl" AS "replyUserBanner_thumbnailUrl", "replyUserBanner"."webpublicUrl" AS "replyUserBanner_webpublicUrl", "replyUserBanner"."webpublicType" AS "replyUserBanner_webpublicType", "replyUserBanner"."accessKey" AS "replyUserBanner_accessKey", "replyUserBanner"."thumbnailAccessKey" AS "replyUserBanner_thumbnailAccessKey", "replyUserBanner"."webpublicAccessKey" AS "replyUserBanner_webpublicAccessKey", "replyUserBanner"."uri" AS "replyUserBanner_uri", "replyUserBanner"."src" AS "replyUserBanner_src", "replyUserBanner"."folderId" AS "replyUserBanner_folderId", "replyUserBanner"."isSensitive" AS "replyUserBanner_isSensitive", "replyUserBanner"."isLink" AS "replyUserBanner_isLink", "renoteUser"."id" AS "renoteUser_id", "renoteUser"."createdAt" AS "renoteUser_createdAt", "renoteUser"."updatedAt" AS "renoteUser_updatedAt", "renoteUser"."lastFetchedAt" AS "renoteUser_lastFetchedAt", "renoteUser"."lastActiveDate" AS "renoteUser_lastActiveDate", "renoteUser"."hideOnlineStatus" AS "renoteUser_hideOnlineStatus", "renoteUser"."username" AS "renoteUser_username", "renoteUser"."name" AS "renoteUser_name", "renoteUser"."followersCount" AS "renoteUser_followersCount", "renoteUser"."followingCount" AS "renoteUser_followingCount", "renoteUser"."notesCount" AS "renoteUser_notesCount", "renoteUser"."avatarId" AS "renoteUser_avatarId", "renoteUser"."bannerId" AS "renoteUser_bannerId", "renoteUser"."tags" AS "renoteUser_tags", "renoteUser"."isSuspended" AS "renoteUser_isSuspended", "renoteUser"."isSilenced" AS "renoteUser_isSilenced", "renoteUser"."isLocked" AS "renoteUser_isLocked", "renoteUser"."isBot" AS "renoteUser_isBot", "renoteUser"."isCat" AS "renoteUser_isCat", "renoteUser"."isAdmin" AS "renoteUser_isAdmin", "renoteUser"."isModerator" AS "renoteUser_isModerator", "renoteUser"."isExplorable" AS "renoteUser_isExplorable", "renoteUser"."isDeleted" AS "renoteUser_isDeleted", "renoteUser"."emojis" AS "renoteUser_emojis", "renoteUser"."host" AS "renoteUser_host", "renoteUser"."inbox" AS "renoteUser_inbox", "renoteUser"."sharedInbox" AS "renoteUser_sharedInbox", "renoteUser"."featured" AS "renoteUser_featured", "renoteUser"."uri" AS "renoteUser_uri", "renoteUser"."followersUri" AS "renoteUser_followersUri", "renoteUser"."showTimelineReplies" AS "renoteUser_showTimelineReplies", "renoteUser"."token" AS "renoteUser_token", "renoteUserAvatar"."id" AS "renoteUserAvatar_id", "renoteUserAvatar"."createdAt" AS "renoteUserAvatar_createdAt", "renoteUserAvatar"."userId" AS "renoteUserAvatar_userId", "renoteUserAvatar"."userHost" AS "renoteUserAvatar_userHost", "renoteUserAvatar"."md5" AS "renoteUserAvatar_md5", "renoteUserAvatar"."name" AS "renoteUserAvatar_name", "renoteUserAvatar"."type" AS "renoteUserAvatar_type", "renoteUserAvatar"."size" AS "renoteUserAvatar_size", "renoteUserAvatar"."comment" AS "renoteUserAvatar_comment", "renoteUserAvatar"."blurhash" AS "renoteUserAvatar_blurhash", "renoteUserAvatar"."properties" AS "renoteUserAvatar_properties", "renoteUserAvatar"."storedInternal" AS "renoteUserAvatar_storedInternal", "renoteUserAvatar"."url" AS "renoteUserAvatar_url", "renoteUserAvatar"."thumbnailUrl" AS "renoteUserAvatar_thumbnailUrl", "renoteUserAvatar"."webpublicUrl" AS "renoteUserAvatar_webpublicUrl", "renoteUserAvatar"."webpublicType" AS "renoteUserAvatar_webpublicType", "renoteUserAvatar"."accessKey" AS "renoteUserAvatar_accessKey", "renoteUserAvatar"."thumbnailAccessKey" AS "renoteUserAvatar_thumbnailAccessKey", "renoteUserAvatar"."webpublicAccessKey" AS "renoteUserAvatar_webpublicAccessKey", "renoteUserAvatar"."uri" AS "renoteUserAvatar_uri", "renoteUserAvatar"."src" AS "renoteUserAvatar_src", "renoteUserAvatar"."folderId" AS "renoteUserAvatar_folderId", "renoteUserAvatar"."isSensitive" AS "renoteUserAvatar_isSensitive", "renoteUserAvatar"."isLink" AS "renoteUserAvatar_isLink", "renoteUserBanner"."id" AS "renoteUserBanner_id", "renoteUserBanner"."createdAt" AS "renoteUserBanner_createdAt", "renoteUserBanner"."userId" AS "renoteUserBanner_userId", "renoteUserBanner"."userHost" AS "renoteUserBanner_userHost", "renoteUserBanner"."md5" AS "renoteUserBanner_md5", "renoteUserBanner"."name" AS "renoteUserBanner_name", "renoteUserBanner"."type" AS "renoteUserBanner_type", "renoteUserBanner"."size" AS "renoteUserBanner_size", "renoteUserBanner"."comment" AS "renoteUserBanner_comment", "renoteUserBanner"."blurhash" AS "renoteUserBanner_blurhash", "renoteUserBanner"."properties" AS "renoteUserBanner_properties", "renoteUserBanner"."storedInternal" AS "renoteUserBanner_storedInternal", "renoteUserBanner"."url" AS "renoteUserBanner_url", "renoteUserBanner"."thumbnailUrl" AS "renoteUserBanner_thumbnailUrl", "renoteUserBanner"."webpublicUrl" AS "renoteUserBanner_webpublicUrl", "renoteUserBanner"."webpublicType" AS "renoteUserBanner_webpublicType", "renoteUserBanner"."accessKey" AS "renoteUserBanner_accessKey", "renoteUserBanner"."thumbnailAccessKey" AS "renoteUserBanner_thumbnailAccessKey", "renoteUserBanner"."webpublicAccessKey" AS "renoteUserBanner_webpublicAccessKey", "renoteUserBanner"."uri" AS "renoteUserBanner_uri", "renoteUserBanner"."src" AS "renoteUserBanner_src", "renoteUserBanner"."folderId" AS "renoteUserBanner_folderId", "renoteUserBanner"."isSensitive" AS "renoteUserBanner_isSensitive", "renoteUserBanner"."isLink" AS "renoteUserBanner_isLink" FROM "notification" "notification" LEFT JOIN "user" "notifier" ON "notifier"."id"="notification"."notifierId" LEFT JOIN "note" "note" ON "note"."id"="notification"."noteId" LEFT JOIN "drive_file" "notifierAvatar" ON "notifierAvatar"."id"="notifier"."avatarId" LEFT JOIN "drive_file" "notifierBanner" ON "notifierBanner"."id"="notifier"."bannerId" LEFT JOIN "user" "user" ON "user"."id"="note"."userId" LEFT JOIN "drive_file" "avatar" ON "avatar"."id"="user"."avatarId" LEFT JOIN "drive_file" "banner" ON "banner"."id"="user"."bannerId" LEFT JOIN "note" "reply" ON "reply"."id"="note"."replyId" LEFT JOIN "note" "renote" ON "renote"."id"="note"."renoteId" LEFT JOIN "user" "replyUser" ON "replyUser"."id"="reply"."userId" LEFT JOIN "drive_file" "replyUserAvatar" ON "replyUserAvatar"."id"="replyUser"."avatarId" LEFT JOIN "drive_file" "replyUserBanner" ON "replyUserBanner"."id"="replyUser"."bannerId" LEFT JOIN "user" "renoteUser" ON "renoteUser"."id"="renote"."userId" LEFT JOIN "drive_file" "renoteUserAvatar" ON "renoteUserAvatar"."id"="renoteUser"."avatarId" LEFT JOIN "drive_file" "renoteUserBanner" ON "renoteUserBanner"."id"="renoteUser"."bannerId" WHERE "notification"."notifieeId" = $1 AND ("notification"."notifierId" NOT IN (SELECT "muting"."muteeId" AS "muting_muteeId" FROM "muting" "muting" WHERE "muting"."muterId" = $2) OR "notification"."notifierId" IS NULL) AND ("notifier"."host" IS NULL OR NOT (( SELECT "user_profile"."mutedInstances" AS "user_profile_mutedInstances" FROM "user_profile" "user_profile" WHERE "user_profile"."userId" = $3 )::jsonb ? "notifier"."host")) AND ("notification"."notifierId" NOT IN (SELECT "users"."id" AS "users_id" FROM "user" "users" WHERE "users"."isSuspended" = TRUE) OR "notification"."notifierId" IS NULL)) "distinctAlias" ORDER BY "distinctAlias"."notification_id" DESC, "notification_id" ASC LIMIT 10 -- PARAMETERS: ["8rlgk7ume6","8rlgk7ume6","8rlgk7ume6"] | |
| execution time: 4588 | |
| QueryFailedError: bind message has 21771 parameter formats but 0 parameters | |
| at PostgresQueryRunner.query (/home/user/misskey/packages/backend/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19) | |
| at process.processTicksAndRejections (node:internal/process/task_queues:95:5) | |
| at async UpdateQueryBuilder.execute (/home/user/misskey/packages/backend/node_modules/typeorm/query-builder/UpdateQueryBuilder.js:83:33) | |
| at async readNotification (file:///home/user/misskey/packages/backend/built/server/api/common/read-notification.js:7:5) { | |
| query: 'UPDATE "notification" SET "isRead" = $1 WHERE ("id" IN ($2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809, $810, $811, $812, $813, $814, $815, $816, $817, $818, $819, $820, $821, $822, $823, $824, $825, $826, $827, $828, $829, $830, $831, $832, $833, $834, $835, $836, $837, $838, $839, $840, $841, $842, $843, $844, $845, $846, $847, $848, $849, $850, $851, $852, $853, $854, $855, $856, $857, $858, $859, $860, $861, $862, $863, $864, $865, $866, $867, $868, $869, $870, $871, $872, $873, $874, $875, $876, $877, $878, $879, $880, $881, $882, $883, $884, $885, $886, $887, $888, $889, $890, $891, $892, $893, $894, $895, $896, $897, $898, $899, $900, $901, $902, $903, $904, $905, $906, $907, $908, $909, $910, $911, $912, $913, $914, $915, $916, $917, $918, $919, $920, $921, $922, $923, $924, $925, $926, $927, $928, $929, $930, $931, $932, $933, $934, $935, $936, $937, $938, $939, $940, $941, $942, $943, $944, $945, $946, $947, $948, $949, $950, $951, $952, $953, $954, $955, $956, $957, $958, $959, $960, $961, $962, $963, $964, $965, $966, $967, $968, $969, $970, $971, $972, $973, $974, $975, $976, $977, $978, $979, $980, $981, $982, $983, $984, $985, $986, $987, $988, $989, $990, $991, $992, $993, $994, $995, $996, $997, $998, $999, $1000, $1001, $1002, $1003, $1004, $1005, $1006, $1007, $1008, $1009, $1010, $1011, $1012, $1013, $1014, $1015, $1016, $1017, $1018, $1019, $1020, $1021, $1022, $1023, $1024, $1025, $1026, $1027, $1028, $1029, $1030, $1031, $1032, $1033, $1034, $1035, $1036, $1037, $1038, $1039, $1040, $1041, $1042, $1043, $1044, $1045, $1046, $1047, $1048, $1049, $1050, $1051, $1052, $1053, $1054, $1055, $1056, $1057, $1058, $1059, $1060, $1061, $1062, $1063, $1064, $1065, $1066, $1067, $1068, $1069, $1070, $1071, $1072, $1073, $1074, $1075, $1076, $1077, $1078, $1079, $1080, $1081, $1082, $1083, $1084, $1085, $1086, $1087, $1088, $1089, $1090, $1091, $1092, $1093, $1094, $1095, $1096, $1097, $1098, $1099, $1100, $1101, $1102, $1103, $1104, $1105, $1106, $1107, $1108, $1109, $1110, $1111, $1112, $1113, $1114, $1115, $1116, $1117, $1118, $1119, $1120, $1121, $1122, $1123, $1124, $1125, $1126, $1127, $1128, $1129, $1130, $1131, $1132, $1133, $1134, $1135, $1136, $1137, $1138, $1139, $1140, $1141, $1142, $1143, $1144, $1145, $1146, $1147, $1148, $1149, $1150, $1151, $1152, $1153, $1154, $1155, $1156, $1157, $1158, $1159, $1160, $1161, $1162, $1163, $1164, $1165, $1166, $1167, $1168, $1169, $1170, $1171, $1172, $1173, $1174, $1175, $1176, $1177, $1178, $1179, $1180, $1181, $1182, $1183, $1184, $1185, $1186, $1187, $1188, $1189, $1190, $1191, $1192, $1193, $1194, $1195, $1196, $1197, $1198, $1199, $1200, $1201, $1202, $1203, $1204, $1205, $1206, $1207, $1208, $1209, $1210, $1211, $1212, $1213, $1214, $1215, $1216, $1217, $1218, $1219, $1220, $1221, $1222, $1223, $1224, $1225, $1226, $1227, $1228, $1229, $1230, $1231, $1232, $1233, $1234, $1235, $1236, $1237, $1238, $1239, $1240, $1241, $1242, $1243, $1244, $1245, $1246, $1247, $1248, $1249, $1250, $1251, $1252, $1253, $1254, $1255, $1256, $1257, $1258, $1259, $1260, $1261, $1262, $1263, $1264, $1265, $1266, $1267, $1268, $1269, $1270, $1271, $1272, $1273, $1274, $1275, $1276, $1277, $1278, $1279, $1280, $1281, $1282, $1283, $1284, $1285, $1286, $1287, $1288, $1289, $1290, $1291, $1292, $1293, $1294, $1295, $1296, $1297, $1298, $1299, $1300, $1301, $1302, $1303, $1304, $1305, $1306, $1307, $1308, $1309, $1310, $1311, $1312, $1313, $1314, $1315, $1316, $1317, $1318, $1319, $1320, $1321, $1322, $1323, $1324, $1325, $1326, $1327, $1328, $1329, $1330, $1331, $1332, $1333, $1334, $1335, $1336, $1337, $1338, $1339, $1340, $1341, $1342, $1343, $1344, $1345, $1346, $1347, $1348, $1349, $1350, $1351, $1352, $1353, $1354, $1355, $1356, $1357, $1358, $1359, $1360, $1361, $1362, $1363, $1364, $1365, $1366, $1367, $1368, $1369, $1370, $1371, $1372, $1373, $1374, $1375, $1376, $1377, $1378, $1379, $1380, $1381, $1382, $1383, $1384, $1385, $1386, $1387, $1388, $1389, $1390, $1391, $1392, $1393, $1394, $1395, $1396, $1397, $1398, $1399, $1400, $1401, $1402, $1403, $1404, $1405, $1406, $1407, $1408, $1409, $1410, $1411, $1412, $1413, $1414, $1415, $1416, $1417, $1418, $1419, $1420, $1421, $1422, $1423, $1424, $1425, $1426, $1427, $1428, $1429, $1430, $1431, $1432, $1433, $1434, $1435, $1436, $1437, $1438, $1439, $1440, $1441, $1442, $1443, $1444, $1445, $1446, $1447, $1448, $1449, $1450, $1451, $1452, $1453, $1454, $1455, $1456, $1457, $1458, $1459, $1460, $1461, $1462, $1463, $1464, $1465, $1466, $1467, $1468, $1469, $1470, $1471, $1472, $1473, $1474, $1475, $1476, $1477, $1478, $1479, $1480, $1481, $1482, $1483, $1484, $1485, $1486, $1487, $1488, $1489, $1490, $1491, $1492, $1493, $1494, $1495, $1496, $1497, $1498, $1499, $1500, $1501, $1502, $1503, $1504, $1505, $1506, $1507, $1508, $1509, $1510, $1511, $1512, $1513, $1514, $1515, $1516, $1517, $1518, $1519, $1520, $1521, $1522, $1523, $1524, $1525, $1526, $1527, $1528, $1529, $1530, $1531, $1532, $1533, $1534, $1535, $1536, $1537, $1538, $1539, $1540, $1541, $1542, $1543, $1544, $1545, $1546, $1547, $1548, $1549, $1550, $1551, $1552, $1553, $1554, $1555, $1556, $1557, $1558, $1559, $1560, $1561, $1562, $1563, $1564, $1565, $1566, $1567, $1568, $1569, $1570, $1571, $1572, $1573, $1574, $1575, $1576, $1577, $1578, $1579, $1'... 1844372 more characters, | |
| parameters: [ | |
| true, '8o7dyohvqz', '8o7lknfwhf', '8o7e3gter6', '8o7lkyqlhn', | |
| '8o7pzql8l9', '8o8dledwby', '8o7e6crfsc', '8o7e6a0ms6', '8o7e5sqvry', | |
| '8o7q9dwfzq', '8o7ed960u3', '8rer650qm8', '8o7qirpypk', '8o7gf01e2r', | |
| '8o7fgssy7v', '8o8dn6c1if', '8rtlfxj31u', '8rf5gi1s3a', '8t6y5w24ye', | |
| '8rfd9tu1eb', '8o7oxddqpb', '8rfhpob6vw', '8t8bsce3yl', '8vwgflgcau', | |
| '8rfu7po0xk', '8rfw5ovx2i', '8o7jlyfzp8', '8o7k8uo5ww', '8o7k988dy2', | |
| '8o7k7p3cua', '8o7mfxj1dq', '8o7l1l79im', '8o7l1sepiu', '8o7mlpewpo', | |
| '8o7mmew7sm', '8o7mn6pmsv', '8o7n0tmbn9', '8o7n1qlspn', '8o7n1tz9q4', | |
| '8o7n2612qw', '8o7n2z4gua', '8o7n32dluk', '8o7n6hq4dd', '8o7n6q1eh1', | |
| '8o7n71gnlf', '8o7n7fqrm6', '8o7n8sowsh', '8o7n98rnsx', '8o7nb4i6vw', | |
| '8o7nb6unwb', '8o7nbkn1wv', '8o7ncdr9yi', '8o7nclqtyq', '8o7ncv9qyw', | |
| '8o7ne0r30e', '8o7nexfz13', '8o7nf05p17', '8o7nf5381o', '8o7nfg4p2v', | |
| '8o7nflmn33', '8o7nfs4n35', '8o7ngctz3u', '8o7ngf0p4u', '8o7nhhza64', | |
| '8o7nhmzs7o', '8o7ni4y79b', '8o7nit7pbk', '8o7noi40nt', '8o7non5eo0', | |
| '8o7np9p3p0', '8o7nr0wysj', '8o7nrb91sq', '8o7nwlo0ml', '8o8dm4aage', | |
| '8o7nzj5ivl', '8o7nztqiy0', '8o7nzxplzp', '8oo9kpwj3c', '8o7o1d7g2s', | |
| '8o8dmsrihi', '8o7o2vkl47', '8o7qq0pf1r', '8o7ob6wcvz', '8o7oe7dl14', | |
| '8o7oeas518', '8o7oee8r1i', '8o7oeji71s', '8o7oj71f77', '8o7oj7zv7d', | |
| '8o7ojah87h', '8o7okwoniv', '8o7opnve1h', '8o7oubzaff', '8o7ouiuqfz', | |
| '8o7ouy3vg1', '8o7ovajdhp', '8o7ow1vwmn', '8o7ow2ogmq', '8o7owjannk', | |
| ... 218279 more items | |
| ], | |
| driverError: error: bind message has 21771 parameter formats but 0 parameters | |
| at Parser.parseErrorMessage (/home/user/misskey/packages/backend/node_modules/pg-protocol/dist/parser.js:287:98) | |
| at Parser.handlePacket (/home/user/misskey/packages/backend/node_modules/pg-protocol/dist/parser.js:126:29) | |
| at Parser.parse (/home/user/misskey/packages/backend/node_modules/pg-protocol/dist/parser.js:39:38) | |
| at Socket.<anonymous> (/home/user/misskey/packages/backend/node_modules/pg-protocol/dist/index.js:11:42) | |
| at Socket.emit (node:events:527:28) | |
| at Socket.emit (node:domain:475:12) | |
| at addChunk (node:internal/streams/readable:324:12) | |
| at readableAddChunk (node:internal/streams/readable:297:9) | |
| at Readable.push (node:internal/streams/readable:234:10) | |
| at TCP.onStreamRead (node:internal/stream_base_commons:190:23) { | |
| length: 122, | |
| severity: 'ERROR', | |
| code: '08P01', | |
| detail: undefined, | |
| hint: undefined, | |
| position: undefined, | |
| internalPosition: undefined, | |
| internalQuery: undefined, | |
| where: undefined, | |
| schema: undefined, | |
| table: undefined, | |
| column: undefined, | |
| dataType: undefined, | |
| constraint: undefined, | |
| file: 'postgres.c', | |
| line: '1666', | |
| routine: 'exec_bind_message' | |
| }, | |
| length: 122, | |
| severity: 'ERROR', | |
| code: '08P01', | |
| detail: undefined, | |
| hint: undefined, | |
| position: undefined, | |
| internalPosition: undefined, | |
| internalQuery: undefined, | |
| where: undefined, | |
| schema: undefined, | |
| table: undefined, | |
| column: undefined, | |
| dataType: undefined, | |
| constraint: undefined, | |
| file: 'postgres.c', | |
| line: '1666', | |
| routine: 'exec_bind_message' | |
| } | |
| WARN 1 [api] SLOW API CALL DETECTED: i/notifications (4849.911375001073ms) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment