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

Status: RESOLVED FIXED

(Input :: General, defect)

Description

[Will Kahn-Greene [:willkg] ET needinfo? me]

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.

Comment 1

[Will Kahn-Greene [:willkg] ET needinfo? me]

This is an easy fix so I'm making it a 1 pointer.

Grabbing it now to do.

Comment 2

[Gregg Lind (Fx Strategy and Insights - Shield - Heartbeat )]

Thanks!  This will speed up a lot of interactive queries.

Comment 3

[Will Kahn-Greene [:willkg] ET needinfo? me]

In a PR: https://github.com/mozilla/fjord/pull/628

Comment 4

[Will Kahn-Greene [:willkg] ET needinfo? me]

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.

Comment 5

[Will Kahn-Greene [:willkg] ET needinfo? me]

Pushed the code changes, but forgot the migration. Boo.

Migration in a PR: https://github.com/mozilla/fjord/pull/629

Comment 6

[Will Kahn-Greene [:willkg] ET needinfo? me]

Migration landed in https://github.com/mozilla/fjord/commit/0476cb930839f22524b9ddf1bd8368e8f7bd44d0

Pushing again now.

Comment 7

[Will Kahn-Greene [:willkg] ET needinfo? me]

Pushed to prod. Seems like it all went well.

Gregg: Are queries that would use these indexes faster now?

Comment 8

[Gregg Lind (Fx Strategy and Insights - Shield - Heartbeat )]

Same query at least 3x faster, and it used the `received_ts` index.  

ACCEPTED.