Drop index_events_for_group_activity asynchronously

Description

The events table has many indexes. We have found some, including index_events_for_group_activity, that are not used. This issue is to remove that index from the database.

Reference: https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#drop-indexes-asynchronously

Related to #415089 (closed).