You can now enable "aggressive deploy request cutover" from the database settings page under "Advanced settings". This feature is available to database administrators only.
When enabled, this setting forces schema migration cutover operations to complete immediately by killing any queries or transactions that are blocking the operation. This is useful when you receive "Migration delayed due to long-running transactions" notices or when your application has slow queries that prevent migrations from completing.
Important: This setting applies to all future deploy requests once enabled, and killed queries will need to be retried by your application.
For more information, see the Aggressive cutover documentation.