Hi Pierre,
I was trying to narrow down the problem to a specific change and all the indicators at the moment are pointing to the upgrade from Sonar 9.x to Postgres 11.1
After this observation my colleague, pointed to [RESOLVED] Sonarqube is slow since update to 8.4.1 and now we want to try that too, specifically the VACUUM FULL command.
Write IOPS was maximum at 600 and then it averaged 300
Read IOPS was averaging 200