Sonarqube Scan increased from seconds to hours after upgrade

[Colin]

Hey there.

SonarQube v9.4 is already several versions behind (and EOL). It’s not an LTS version – which means you should move to v9.7 as soon as possible (v9.8 due out next week or the week after).

I would also recommend performing a VACUUM FULL ANALYZE

SonarQube becomes slow after PostgreSQL upgrade

Hello SonarQube Operators! It’s common that after performing an upgrade of PostgreSQL, a SonarQube instance connected to a PostgreSQL database can become painfully slow. Thankfully, we know how the issue can usually be addressed (it works almost every time!): by executing the following command against your Postgres database. VACUUM FULL ANALYZE For a PostgreSQL database, a VACUUM FULL command reclaims unused storage, while the ANALYZE command updates statistics used by the planner to determi…