Missing database index deleted_at column

[masterpe]

We are using Openstack Train

When using the command

./nova-manage db archive_deleted_rows --all-cells --verbose --before 2021-05-01 --max_rows 1000 --purge

This run takes 19 minutes, without the --before option, this command gets down to seconds.

It turns out when I look into the indexes of the tables I'm missing a index on the deleted_at column.

For example when I use the SQL command:
SHOW INDEX FROM nova.instances;
I'm missing the index.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/nova/+/792989