Add synchronous index on environments.updated_at for stopping state
Why
See #428069 (closed)
We want to add this index so that we can continue working on a bug fix for environments that get stuck in a stopping state for too long. The work will require some queries that need this index to perform sufficiently.
What
Add synchronous index
This is the counterpart to the async index addition in the following link:
Screenshots or screen recordings
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
Before | After |
---|---|
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.