The web API api/issues/do_transition is too slow. It's 1.5 second long on SonarCloud on the sonarqube project. (EDIT: Up to 45s on Peach)
The hotspot is this SQL request, which takes 980ms:
Query stats confirms longer SQL request (5 calls for 1.39s)
Rest of SQL or ES calls is marginal.