Matomo On-Premise Scaling

This seems a bit similar to

and

.
But in their cases it was caused by a major Matomo upgrade, while you installed a recent Matomo version freshly, right?
I guess the large amout of sites causes this, but nevertheless this query should not be what causes the major slowdown.