index country, locale, received_ts and channel in heartbeat answer table

RESOLVED FIXED

Status

Input
General
RESOLVED FIXED
3 years ago
3 years ago

People

(Reporter: willkg, Assigned: willkg)

Tracking

Details

(Whiteboard: u=gregg c=heartbeat p=1 s=input.2015q3)

(Assignee)

Description

3 years ago
edwin-input
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
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.