Skip to content

Create index for deployment_approvals on created_at and id

Ahmed Hemdan requested to merge create-composite-index-for-deployment-approvals into master

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.

Edited by Ahmed Hemdan

Merge request reports