we are running self hosted SonarQube Developer Edition - Version 9.9 (build 65466). After recent upgrade from 9.5 we see dramatic increase of background time taken by analysis. Before it was about 1-2 seconds, now it’s 1-20 minutes.
Snapshot of background tasks log from 23.3.2023 when it was upgraded:
My first recommendation would be that you make sure you’ve run database maintenance (that is typically automated in big setups) such as refreshing database statistics and the indexes of each table. A lot of data shifts around during upgrades, which means up-to-date statistics and indexes are important for performance.