1831941 - Add a subtable to hold the replicates from performance data

Status: RESOLVED FIXED

(Tree Management :: Perfherder, task, P1)

Description

[Greg Mierzwinski [:sparky]]

This bug is for adding a subtable to hold the replicates from performance data. Currently, we only store the overall value of the subtest, but not the individual trials.

We'll make a table that has a auto increment primary key, a foreign key to the performance_datum object it relates to, and the value. This ingestion should only happen for try runs to begin with, and we'll expand from there once we're sure it won't cause any unexpected issues like overall slowdowns in queries.

Comment 1

[Greg Mierzwinski [:sparky]]

PR: https://github.com/mozilla/treeherder/pull/7693

Comment 2

[Greg Mierzwinski [:sparky]]

PR is reviewed, and will be pushed to staging. Next week we'll look into pushing it to master/prod.

Comment 3

[Greg Mierzwinski [:sparky]]

This is complete now, and we're monitoring the new table here: https://sql.telemetry.mozilla.org/dashboard/performance_datum_replicate-monitoring