We’re on Sonarqube v7.3 (build 15553), running on AWS backed by Postgres db, over the weekend we upgraded the db engine to v13.3, and noticed the task execution became extremely slow, it used to take ~5 seconds, now it took ~35 minutes
We’ve followed the suggestion from this post SonarQube becomes slow after PostgreSQL upgrade and did a vacuum full analyze, I can see it reduced the db size by half. However the task execution time hardly change, well, it drops from ~35 to ~32 minutes.
Looking thru the logs, I noticed the following entries taking the longest time, but not sure what they are:
Persist components | time=993311ms
Build tree of components | components=45 | time=1005998ms
Any suggestion would be welcomed.