:bucket: Making Commonwealth Scalable

[timolegros]

Description

The scope of this bucket includes all work whose primary focus is to increase Commonwealth scalability, performance, and stability/reliability.

Database Optimization

• [ ] https://github.com/hicommonwealth/commonwealth/issues/8005
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8016
• [x] https://github.com/hicommonwealth/commonwealth/issues/8006
• [ ] https://github.com/hicommonwealth/commonwealth/issues/7372
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8001
• [x] https://github.com/hicommonwealth/commonwealth/issues/8657
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8661

App Optimization

• [ ] https://github.com/hicommonwealth/commonwealth/issues/8007
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8017

Load Testing

• [x] https://github.com/hicommonwealth/commonwealth/issues/8063
• [x] https://github.com/hicommonwealth/commonwealth/issues/8064
• [x] https://github.com/hicommonwealth/commonwealth/issues/8418
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8067
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8068
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8065
• [ ] https://github.com/hicommonwealth/commonwealth/issues/8012

Monitoring

• [x] https://github.com/hicommonwealth/commonwealth/issues/8000
• [x] https://github.com/hicommonwealth/commonwealth/issues/8004
• [x] https://github.com/hicommonwealth/commonwealth/issues/7359

Additional Context

• [ ] User the Heroku PG Extras CLI Plugin to view Postgres metrics quickly and efficiently
• [ ] Use https://explain.dalibo.com/ to visualize query plans produced by Postgres.

[ForestMars]

TImothee owns sub-tasks here, adding Jake to bucket for visibility.