We want to add the following indexes to the heartbeat answer table: * country * locale * received_ts * channel This will speed up the queries that Gregg is doing.
This is an easy fix so I'm making it a 1 pointer. Grabbing it now to do.
Assignee: nobody → willkg
Status: NEW → ASSIGNED
Whiteboard: u=gregg c=heartbeat p=1 s=input.2015q3
Thanks! This will speed up a lot of interactive queries.
Landed in master in https://github.com/mozilla/fjord/commit/067efdd56788a5349cbb01dabd4825223708d997 I'm going to push this to -stage and then -prod. It's possible that the migration will take too long to run in prod in which case we'll have to do the "disable hb" dance. We'll see.
Pushed the code changes, but forgot the migration. Boo. Migration in a PR: https://github.com/mozilla/fjord/pull/629
Migration landed in https://github.com/mozilla/fjord/commit/0476cb930839f22524b9ddf1bd8368e8f7bd44d0 Pushing again now.
Pushed to prod. Seems like it all went well. Gregg: Are queries that would use these indexes faster now?
Same query at least 3x faster, and it used the `received_ts` index. ACCEPTED.
Status: ASSIGNED → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.