Diagnose performance difference between two environments

[Colin]

Hey there.

Ultimately, it’s hard to do a direct comparison since you have some variables (sizing, being located on the same Azure subscription).

However, my first recommendation for any performance issues on a Postgres database would be this:

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…

If that doesn’t help – I would like to know more about the dataset on staging. Is it a clone of production as it is today? Something else?