Index audits on IP address

Description

Sometimes, a database admin has to look up audits by IP address for the Policy & Abuse committee. Audits aren't currently indexed on IP address (remote_address). Doing so would make this a bit faster.

(This table is managed by a gem, but adding an extra index shouldn't interfere with how it works.)

Because audits is a hefty table, the migration should use pt-online-schema-change in staging/production.

To test, run the migration on staging and make sure it's successful.

relates to

Activity

Show:

Sarken 
July 28, 2021 at 12:31 AM

james_ at 17:34:

james_ 
July 23, 2021 at 7:33 PM

 

 

 

 

 

 

Looks fine

DeployedToBeta

Details

Assignee

Reporter

Roadmap

Admin
Users

Priority

Affects versions

Fix versions

Components

BackEnd

Difficulty

Milestone

Sentry

Created April 26, 2020 at 11:37 PM
Updated July 28, 2021 at 12:31 AM
Resolved July 28, 2021 at 12:30 AM