Hi,
Here is the slow query stack https://www.dropbox.com/s/tlkszw2onskzsqb/Messages%20Image%283149322874%29.jpg?dl=0
We moved from v7 to 7.2, and we have already configured XML sitemap not to include media etc, the problem that was escalated couple of weeks ago, so there were no changes in configuration on our side.
But after the update these queries were generated on a massive scale.
We turned off the plugin, removed couple of things from XML sitemap, link counters, etc, and now is everything normal. But we still have more than 80k records as I mentioned.
We have more than 300k posts, just to be clear.
Thank you.