Skip to content

Resolve "Remove ` index_users_with_static_object_token`"

What does this MR do and why?

We have introduced the index index_users_with_static_object_tokento help the performance of the EncryptStaticObjectToken background migration. This background migration was introduced in 2021.

Since we have already finished this background migrations, we don't need to have this index anymore.

Merge request where we introduced the index: !76684 (merged)

Index statement:

CREATE INDEX index_users_with_static_object_token ON users USING btree (id) WHERE ((static_object_token IS NOT NULL) AND (static_object_token_encrypted IS NULL));

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.

Related to #429091 (closed)

Edited by Diogo Frazão

Merge request reports