Hi there, Enterprise Edition v10.5.1 (90531) with the following additional plugins: Checkstyle 10.17.0 Dependency-Check 5.0.0 Groovy 1.8 OpenID Connect Authentication for SonarQube 2.1.1 YAML Analyzer 1.9.1 Custom Docker image (JDK 17) Database PostgreSQL 16 We monitor the JRE metrics in Kubern…

Have you run a VACUUM FULL ANALYZE against the Postgres database? [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 database…

Thanks @Colin for the suggestion (and the link). Funnily that came to my mind shortly before you replied. I will take a look whether it gets better and come back with results. The DB lookos ± idle, though.

Yesterday I just executed VACUUM ANALZYE, I now see that you suggested a FULL vacuum. Will try that today after office hours.

I think, we have another issue. Before we had SonarQube within a single node Kubernetes K3S running on a dedicated KVM under our control, the DB was already the same. Now we moved to a managed company K8S cluster so the data directory used for e.g. ES8 storage is not a host directory anymore but CE…

We still had the VMs we used before and setup our QA instance again there instead of running on K8S. No real difference so it is definitely the major update from SQ 9 LTS to 10.6 which makes the difference. As said the background task took one minute for a bigger project and now takes between 6 and…

I now created a small python-script which extracts times and sorts them (times < 1 second are not shown): Result for Java multi-module project with 140k LOC: ❯ ./log-analyzer.py xxxx-master-sq9.log time=1.0s, message=Index analysis time=1.1s, message=Extract report time=1.9s, message=Persist sou…

Hi @Colin , sorry for addressing you directly: It looks like the all the steps are taking up to 4 times longer with SonarQube 10. The DB is the same as before. Any hints are appreciated.

Hey @mfriedenhagen Sorry for the late response. A few points: We have had a few reports of background task slowness after upgrading from 9.9 (possibly related to the introduction of new metrics), but nothing we could reproduce ourselves. SONAR-21949 We intend to specifically improve the performan…

Hello @Colin , I’m a colleague of @mfriedenhagen - I think we can rule out network and disk latency. After the problems appeared in Kubernetes we installed SonarQube 10 for testing on the same machine where we did run SonarQube 9 without problems and even there it was slow like in the Kubernetes Clu…

Hey @fuvo and @mfriedenhagen I don’t have any more advice right now. However, I am collecting a few different data points (across community, our enterprise support channels) to provide a consolidated report of these reports to our PMs/Devs. Stay tuned.

Server side analysis slow after update from v9.9.1 LTS to v10.5.1 (Enterprise)

SonarQube Server / Community Build

Colin (Colin) January 7, 2025, 9:13am 15

Another update:

Topic		Replies	Views
Slow analysis after SonarQube upgrade SonarQube Server / Community Build sonarqube , bump	25	983	January 8, 2025
Sonarqube analysis taking 1+hr after DB upgrade to postgres10 SonarQube Server / Community Build sonarqube , postgres	3	810	January 14, 2021
Slow analysis of Code after upgrade SonarQube Server / Community Build 8-9-lts-upgrade	12	4045	June 10, 2021
Analysis report processing takes too long for some projects SonarQube Server / Community Build	6	451	May 9, 2023
Very slow analysis after 8.1 -> 8.8 upgrade SonarQube Server / Community Build sonarqube , performance	5	3295	June 3, 2021

Server side analysis slow after update from v9.9.1 LTS to v10.5.1 (Enterprise)

Related topics