Hello, we recently upgraded from SonarQube version 10.3 to 10.6. The SonarQube analysis took much longer that before upgrading. There are huge variations in the “Project Analysis” duration. Before upgrade the worst case was up to ~ 6 minutes, after upgrade 60 minutes. It seems to take far longer…

Hi @Colin , did a first test with sonarqube-25.1.0.102122; times are much better now: Still 13% slower but no more factor 3! Thanks for your support. Günter

Here some strange finding out of our SonarQube docker logs: 2024.07.03 15:56:54 INFO ce[6adffde4-fdbe-4061-8594-e349d4a61a68][o.s.c.t.s.ComputationStepExecutor] Persist live measures | insertsOrUpdates=575506 | status=SUCCESS | time=2276427ms 2024.07.03 15:56:55 INFO ce[6adffde4-fdbe-4061-8594-e…

Hey there. What database are you using behind the scenes? Is it Postgres? [image] SonarQube becomes slow after PostgreSQL upgrade Guides Hello SonarQube Operators! It’s common that after performing an upgrade of PostgreSQL, a SonarQube instance connected to a PostgreSQL…

Good morning, we are using postgres:16.2-alpine as docker container running on the same host as SonarQube.

I’d suggest you make sure you perform the VACUUM FULL ANALYZE (you mentioned VACUUM, but not ANALYZE).

We are currently moving the 10.6 installation onto a sperate (non-productive) VM in order be able to dig-down into the delays. I will post further data when the migration is done. Here our initial finding for the analysis time distribution between 10.3 and 10.6: [image] We will perform a “VACUU…

Hi there. We did a similar thing. We re on MsSql Server. I checked index fragmentation and it was necessay to perform defrag. I did a job to do it every week. it helps a lot but we still have sometimes big lags on UI. After 10.6 install, still same issue.

Hi all, same problem here after moving to 10.6 We are persisting a lot more live measures than before and it takes a lot. The live_measures table is 18GB in size. 2024.07.31 07:07:46 INFO ce[97073282-63ce-4df0-9aa3-7c7ae32f6bbf][o.s.c.t.s.ComputationStepExecutor] Persist live measures | insertsOr…

Hey @justoaguilar What version did you upgrade from, and what database backend are you using? @sczuka Did your investigations turn up anything else? [image] sczuka: Then we will try to swap the productive with the test instance for some days (probably next week) in order have more data.

Colleague of sczuka here, we now retestet 10.6.0 after VACUUM FULL ANALYZE, unfortunately to no avail, or maybe a tiny little bit. However it is still the case that analysis max time goes from around 15 min to 50 min and more, and in general it seems that the average analysis time for all builds and…

Hello Sonarqube team; Any news on the topic, we are facing the same issue after upgrading from the LTS 9.9.5 to 10.6.0 . Any workarround or solution ? Thanks in advance

Slow analysis after SonarQube upgrade

SonarQube Server / Community Build

Colin (Colin) July 4, 2024, 7:10am 3

Hey there.

What database are you using behind the scenes? Is it Postgres?

Topic		Replies	Views
Server side analysis slow after update from v9.9.1 LTS to v10.5.1 (Enterprise) SonarQube Server / Community Build	16	573	January 8, 2025
Very slow analysis after 8.1 -> 8.8 upgrade SonarQube Server / Community Build sonarqube , performance	5	3322	June 3, 2021
Sonarqube analysis taking 1+hr after DB upgrade to postgres10 SonarQube Server / Community Build sonarqube , postgres	2	833	January 14, 2021
Analysis times almost doubled SonarQube Server / Community Build database	6	1523	July 27, 2020
Sonarqube Scan increased from seconds to hours after upgrade SonarQube Server / Community Build sonarqube , scanner	6	918	February 13, 2023

Slow analysis after SonarQube upgrade

Related topics