Page MenuHomePhabricator

Add missing indexes to DrydockRepositoryOperation
ClosedPublic

Authored by epriestley on Sep 17 2020, 7:08 PM.
Tags
None
Referenced Files
F17756202: D21465.id51093.diff
Tue, Jul 22, 1:51 PM
F17756201: D21465.id51092.diff
Tue, Jul 22, 1:51 PM
F17756013: D21465.id.diff
Tue, Jul 22, 1:32 PM
F17732044: D21465.diff
Sun, Jul 20, 3:51 AM
Unknown Object (File)
Wed, Jul 2, 7:33 PM
Unknown Object (File)
Apr 27 2025, 8:17 PM
Unknown Object (File)
Apr 27 2025, 9:11 AM
Unknown Object (File)
Apr 26 2025, 10:32 PM
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
Lint
Lint Not Applicable
Unit
Tests Not Applicable

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.