Page MenuHomePhabricator

Add missing indexes to DrydockRepositoryOperation
ClosedPublic

Authored by epriestley on Sep 17 2020, 7:08 PM.
Tags
None
Referenced Files
F15456122: D21465.diff
Sun, Mar 30, 7:12 AM
F15446445: D21465.id51092.diff
Thu, Mar 27, 7:07 PM
F15444545: D21465.id51093.diff
Thu, Mar 27, 10:00 AM
F15442869: D21465.id.diff
Thu, Mar 27, 12:56 AM
F15437099: D21465.diff
Tue, Mar 25, 5:34 PM
F15433791: D21465.diff
Tue, Mar 25, 12:39 AM
F15404918: D21465.id51093.diff
Tue, Mar 18, 9:39 AM
F15395337: D21465.id51093.diff
Sun, Mar 16, 5:56 AM
Subscribers
Restricted Owners Package

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.

Diff Detail

Repository
rP Phabricator
Branch
drydock1
Lint
Lint Passed
Unit
Tests Passed
Build Status
Buildable 24907
Build 34362: Run Core Tests
Build 34361: arc lint + arc unit

Event Timeline

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.