Hi Israel.
Thank you for your reply.
Tried deactivating modules and checked my hosts memory and storage.
The load time is the same. Is the problem here that the plugin is not designed for the size of database we are running? Or do you have any other suggestions?
I also tried to copy the SQL from query monitor and execute that in phpmyadmin. The query is still slow but a little better (+150 secs).