The LemmyNSFW is basically just eating up all the resources it can at this point, at first I thought it was just postgrea and the main server, but pictrs is also doing it.
I have stopped lemmynsfw processes on the server, but my VPS provider has limited performance on the server, so Fedinsfw will most likely be very very slow for a week :( sorry for the inconvenience guys.
I would suggest using an account from another instance to access the communities, federation is working, the ui is just very very slow