Add missing indexes to DrydockRepositoryOperation
ClosedPublic
Actions

Authored by epriestley on Sep 17 2020, 7:08 PM.

Details

Summary

See PHI1885. Repository operations are queryable by state and author, but neither column has a usable key. Add usable keys.

Test Plan

Ran EXPLAIN on a state query. Ran bin/storage upgrade. Ran EXPLAIN again, saw query go from a table scan to a const key lookup.

Repository

rP Phabricator

Lint

Automatic diff as part of commit; lint not applicable.

Unit

Automatic diff as part of commit; unit tests not applicable.

Owners added a subscriber: Restricted Owners Package.Sep 17 2020, 7:08 PM

This revision was not accepted when it landed; it landed in state Needs Review.Sep 17 2020, 7:09 PM

epriestley requested review of this revision.

This revision was automatically updated to reflect the committed changes.

Path

Size

src/

applications/

drydock/

storage/

6 lines