@lanodan I'm wondering if there's something wrong... Surely it shouldn't take this long should it?

@sjw

I'm quite bad at knowing how much a SQL command takes, I often try normal programming modifications and then EXPLAIN.

@lanodan Well, postgres isn't really using any CPU.

@sjw Does this htop has detailed CPU time? (so you can see iowait)

@lanodan Yeah. I've also got netdata running on the server
https://neckbeard.xyz/netdata/#menu_system;theme=slate;help=true;update_always=true

@lanodan Postgres logs are just filled with stuff about @igel's broken accountJun 10 15:40:43 neckbeard.shittyurl.org postgres[2520292]: 2020-06-10 15:40:43.220 PDT [2520292] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.450 PDT [2809194] ERROR: duplicate key value violates unique constraint "IDX_5deb01ae162d1d70b80d064c27"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.450 PDT [2809194] DETAIL: Key ("usernameLower", host)=(igel, jaeger.website) already exists.
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.450 PDT [2809194] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.612 PDT [2809194] ERROR: duplicate key value violates unique constraint "IDX_5deb01ae162d1d70b80d064c27"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.612 PDT [2809194] DETAIL: Key ("usernameLower", host)=(igel, jaeger.website) already exists.
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2809194]: 2020-06-10 15:42:58.612 PDT [2809194] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2849948]: 2020-06-10 15:42:58.945 PDT [2849948] ERROR: duplicate key value violates unique constraint "IDX_5deb01ae162d1d70b80d064c27"
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2849948]: 2020-06-10 15:42:58.945 PDT [2849948] DETAIL: Key ("usernameLower", host)=(igel, jaeger.website) already exists.
Jun 10 15:42:58 neckbeard.shittyurl.org postgres[2849948]: 2020-06-10 15:42:58.945 PDT [2849948] STATEMENT: INSERT INTO "user"("id", "createdAt", "updatedAt", "lastFetchedAt", "username", "usernameLower", "name", "followersCount", "followingCount", "notesCount", "avatarId", "bannerId", "tags", "avatarUrl", "bannerUrl", "avatarColor", "bannerColor", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis", "host", "inbox", "sharedInbox", "featured", "uri", "token") VALUES ($1, $2, DEFAULT, $3, $4, $5, $6, DEFAULT, DEFAULT, DEFAULT, $7, $8, $9, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, $10, $11, $12, DEFAULT, DEFAULT, DEFAULT, $13, $14, $15, DEFAULT, $16, DEFAULT) RETURNING "followersCount", "followingCount", "notesCount", "tags", "isSuspended", "isSilenced", "isLocked", "isBot", "isCat", "isAdmin", "isModerator", "emojis"

@sjw Might explain few things…

@lanodan I think that's just kinda incoming federation while it's running
https://git.pleroma.social/pleroma/pleroma/-/issues/1716

@lanodan Migration just finished.

@sjw yeah, saw it, OOF at the time it took.

@lanodan Looks like 20200527163635_delete_notifications_from_invisible_users is going to be another 20200602125218_backfill_notification_types

@sjw Ouch, could you report it? (I moved my Sunday to today so dayoff)

@lanodan I'll let it go for at least 30 minutes to be sure it's a long boi

@lanodan Nevermind. Only took 08m34s