Create index for deployment_approvals on created_at and id
What does this MR do and why?
This merge request adds a composite index to the deployment_approvals
table on created_at
and id
to ensure we don't do sequential scans when counting rows of the table as it the case in the instrumentation introduced in #361809 (closed).
Please refer to this discussion for more information.
Resolves #363739 (closed).
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.
Edited by Ahmed Hemdan