API for fetching data for a given revision

RESOLVED FIXED

Status

Webtools Graveyard
Graph Server
RESOLVED FIXED
7 years ago
a year ago

People

(Reporter: catlee, Unassigned)

Tracking

Details

Attachments

(1 attachment, 1 obsolete attachment)

(Reporter)

Description

7 years ago
It would be great to have an API that fetched the performance data for a given revision.

Something like

http://graphs.mozilla.org/api/test/runs/info/?rev=abcd1234&rev=efab5678

and returns JSON like

{
  'stat': 'ok',
  'revisions': {
    'abcd1234': [
        {'name': 'Ts',
        'runs': [
                [98, [23, '2007072704', '572a00c0e251'], 1208830929, 92.4, [['Something happened here', 988740]]],
                [99, [23, '2007072704', '572a00c0e251'], 1208834503, 87.3]
                ]
        },
        {'name': 'Tshutdown',
         'runs': [ ... ]
        }
    ],
     'efab5678': [ ... ],
    }
}
(Reporter)

Comment 1

7 years ago
Created attachment 432053 [details] [diff] [review]
Implement /api/test/runs/revisions

This will produce JSON like this (pretty-printed for readability):

Better to group by test type, as I've done here, or by build id?

{
  "stat": "ok", 
  "revisions": {
    "ff4937cb937d": {
      "refcnt_leaks": {
        "test_runs": [
          [
            4461, 
            20090205223423, 
            1233902035, 
            0.0
          ], 
          [
            4473, 
            20090205223604, 
            1233902109, 
            0.0
          ], 
          [
            4517, 
            20090205232757, 
            1233904569, 
            0.0
          ]
        ], 
        "name": "Refcnt Leaks", 
        "id": 23
      }, 
      "trace_malloc_maxheap": {
        "test_runs": [
          [
            4463, 
            20090205223423, 
            1233902035, 
            26977000.0
          ], 
          [
            4475, 
            20090205223604, 
            1233902109, 
            27301900.0
          ], 
          [
            4527, 
            20090205232757, 
            1233904569, 
            15438900.0
          ]
        ], 
        "name": "Trace Malloc MaxHeap", 
        "id": 25
      }, 
      "codesighs": {
        "test_runs": [
          [
            4471, 
            20090205222432, 
            1233901408, 
            17067600.0
          ], 
          [
            4518, 
            20090205233722, 
            1233905812, 
            19567000.0
          ]
        ], 
        "name": "Codesighs", 
        "id": 27
      }, 
      "tp_memset": {
        "test_runs": [
          [
            4584, 
            20090205235833, 
            1233907080, 
            70352100.0
          ]
        ], 
        "name": "Tp3 (Memset)", 
        "id": 9
      }, 
      "tsspider": {
        "test_runs": [
          [
            4505, 
            20090205222339, 
            1233901380, 
            100.84
          ], 
          [
            4511, 
            20090205222339, 
            1233901380, 
            102.84
          ], 
          [
            4579, 
            20090205235833, 
            1233907080, 
            81.719999999999999
          ]
        ], 
        "name": "SunSpider", 
        "id": 21
      }, 
      "tp_pbytes": {
        "test_runs": [
          [
            4510, 
            20090205222339, 
            1233901380, 
            370572000.0
          ], 
          [
            4516, 
            20090205222339, 
            1233901380, 
            368243000.0
          ]
        ], 
        "name": "Tp3 (Private Bytes)", 
        "id": 3
      }, 
      "ts": {
        "test_runs": [
          [
            4507, 
            20090205222339, 
            1233901380, 
            1968.4200000000001
          ], 
          [
            4513, 
            20090205222339, 
            1233901380, 
            1458.26
          ], 
          [
            4581, 
            20090205235833, 
            1233907080, 
            524.52599999999995
          ]
        ], 
        "name": "Ts", 
        "id": 12
      }, 
      "tp": {
        "test_runs": [
          [
            4508, 
            20090205222339, 
            1233901380, 
            339.61200000000002
          ], 
          [
            4514, 
            20090205222339, 
            1233901380, 
            343.96699999999998
          ], 
          [
            4582, 
            20090205235833, 
            1233907080, 
            188.46700000000001
          ]
        ], 
        "name": "Tp3", 
        "id": 2
      }, 
      "trace_malloc_allocs": {
        "test_runs": [
          [
            4464, 
            20090205223423, 
            1233902035, 
            671465.0
          ], 
          [
            4476, 
            20090205223604, 
            1233902109, 
            915570.0
          ], 
          [
            4528, 
            20090205232757, 
            1233904569, 
            498009.0
          ]
        ], 
        "name": "Trace Malloc Allocs", 
        "id": 26
      }, 
      "trace_malloc_leaks": {
        "test_runs": [
          [
            4462, 
            20090205223423, 
            1233902035, 
            908817.0
          ], 
          [
            4474, 
            20090205223604, 
            1233902109, 
            2313850.0
          ], 
          [
            4526, 
            20090205232757, 
            1233904569, 
            105950.0
          ]
        ], 
        "name": "Trace Malloc Leaks", 
        "id": 24
      }, 
      "tdhtml": {
        "test_runs": [
          [
            4506, 
            20090205222339, 
            1233901380, 
            941.41200000000003
          ], 
          [
            4512, 
            20090205222339, 
            1233901380, 
            934.29399999999998
          ], 
          [
            4580, 
            20090205235833, 
            1233907080, 
            1101.24
          ]
        ], 
        "name": "DHTML", 
        "id": 14
      }, 
      "tp_rss": {
        "test_runs": [
          [
            4509, 
            20090205222339, 
            1233901380, 
            92469100.0
          ], 
          [
            4515, 
            20090205222339, 
            1233901380, 
            87750500.0
          ], 
          [
            4583, 
            20090205235833, 
            1233907080, 
            76360900.0
          ]
        ], 
        "name": "Tp3 (RSS)", 
        "id": 5
      }
    }, 
    "fd042e69eb9f": {
      "tp_pbytes": {
        "test_runs": [
          [
            1983, 
            20090131210228, 
            1233464520, 
            371372000.0
          ], 
          [
            1989, 
            20090131210228, 
            1233464520, 
            368693000.0
          ], 
          [
            2007, 
            20090131230227, 
            1233471720, 
            371141000.0
          ], 
          [
            2013, 
            20090131230227, 
            1233471720, 
            368766000.0
          ]
        ], 
        "name": "Tp3 (Private Bytes)", 
        "id": 3
      }, 
      "tp_memset": {
        "test_runs": [
          [
            2025, 
            20090131222356, 
            1233469380, 
            70956700.0
          ], 
          [
            2031, 
            20090131222356, 
            1233469380, 
            65316700.0
          ], 
          [
            2073, 
            20090201003630, 
            1233477360, 
            71059000.0
          ], 
          [
            2079, 
            20090201003630, 
            1233477360, 
            64657200.0
          ]
        ], 
        "name": "Tp3 (Memset)", 
        "id": 9
      }, 
      "tsspider": {
        "test_runs": [
          [
            1978, 
            20090131210228, 
            1233464520, 
            100.64
          ], 
          [
            1984, 
            20090131210228, 
            1233464520, 
            102.52
          ], 
          [
            2002, 
            20090131230227, 
            1233471720, 
            100.64
          ], 
          [
            2008, 
            20090131230227, 
            1233471720, 
            102.64
          ], 
          [
            2020, 
            20090131222356, 
            1233469380, 
            81.040000000000006
          ], 
          [
            2026, 
            20090131222356, 
            1233469380, 
            83.480000000000004
          ], 
          [
            2068, 
            20090201003630, 
            1233477360, 
            81.280000000000001
          ], 
          [
            2074, 
            20090201003630, 
            1233477360, 
            83.400000000000006
          ]
        ], 
        "name": "SunSpider", 
        "id": 21
      }, 
      "ts": {
        "test_runs": [
          [
            1980, 
            20090131210228, 
            1233464520, 
            2056.0500000000002
          ], 
          [
            1986, 
            20090131210228, 
            1233464520, 
            1415.6300000000001
          ], 
          [
            2004, 
            20090131230227, 
            1233471720, 
            2104.1599999999999
          ], 
          [
            2010, 
            20090131230227, 
            1233471720, 
            1416.95
          ], 
          [
            2022, 
            20090131222356, 
            1233469380, 
            519.47400000000005
          ], 
          [
            2028, 
            20090131222356, 
            1233469380, 
            657.73699999999997
          ], 
          [
            2070, 
            20090201003630, 
            1233477360, 
            518.21100000000001
          ], 
          [
            2076, 
            20090201003630, 
            1233477360, 
            749.15800000000002
          ]
        ], 
        "name": "Ts", 
        "id": 12
      }, 
      "tp": {
        "test_runs": [
          [
            1981, 
            20090131210228, 
            1233464520, 
            333.875
          ], 
          [
            1987, 
            20090131210228, 
            1233464520, 
            350.77300000000002
          ], 
          [
            2005, 
            20090131230227, 
            1233471720, 
            337.21699999999998
          ], 
          [
            2011, 
            20090131230227, 
            1233471720, 
            352.06099999999998
          ], 
          [
            2023, 
            20090131222356, 
            1233469380, 
            183.40100000000001
          ], 
          [
            2029, 
            20090131222356, 
            1233469380, 
            364.495
          ], 
          [
            2071, 
            20090201003630, 
            1233477360, 
            182.48699999999999
          ], 
          [
            2077, 
            20090201003630, 
            1233477360, 
            372.36700000000002
          ]
        ], 
        "name": "Tp3", 
        "id": 2
      }, 
      "tdhtml": {
        "test_runs": [
          [
            1979, 
            20090131210228, 
            1233464520, 
            942.11800000000005
          ], 
          [
            1985, 
            20090131210228, 
            1233464520, 
            944.76499999999999
          ], 
          [
            2003, 
            20090131230227, 
            1233471720, 
            937.29399999999998
          ], 
          [
            2009, 
            20090131230227, 
            1233471720, 
            941.471
          ], 
          [
            2021, 
            20090131222356, 
            1233469380, 
            1094.0599999999999
          ], 
          [
            2027, 
            20090131222356, 
            1233469380, 
            766.58799999999997
          ], 
          [
            2069, 
            20090201003630, 
            1233477360, 
            1093.1800000000001
          ], 
          [
            2075, 
            20090201003630, 
            1233477360, 
            767.41200000000003
          ]
        ], 
        "name": "DHTML", 
        "id": 14
      }, 
      "tp_rss": {
        "test_runs": [
          [
            1982, 
            20090131210228, 
            1233464520, 
            94170300.0
          ], 
          [
            1988, 
            20090131210228, 
            1233464520, 
            88590100.0
          ], 
          [
            2006, 
            20090131230227, 
            1233471720, 
            93683600.0
          ], 
          [
            2012, 
            20090131230227, 
            1233471720, 
            88591600.0
          ], 
          [
            2024, 
            20090131222356, 
            1233469380, 
            77022500.0
          ], 
          [
            2030, 
            20090131222356, 
            1233469380, 
            77542900.0
          ], 
          [
            2072, 
            20090201003630, 
            1233477360, 
            76895500.0
          ], 
          [
            2078, 
            20090201003630, 
            1233477360, 
            78187200.0
          ]
        ], 
        "name": "Tp3 (RSS)", 
        "id": 5
      }
    }
  }
}
Attachment #432053 - Flags: feedback?(justdave)
Attachment #432053 - Flags: feedback?(jmuizelaar)
Attachment #432053 - Flags: feedback?(anodelman)
(Reporter)

Comment 2

7 years ago
Whoops, just realized that the results need to be broken up by platform as well.
(Reporter)

Comment 3

7 years ago
Created attachment 432073 [details] [diff] [review]
Implement /api/test/runs/revisions

Now with platforms!

{
  "stat": "ok", 
  "revisions": {
    "ff4937cb937d": {
      "refcnt_leaks": {
        "test_runs": {
          "MacOSX 10.5.2": [
            [
              4473, 
              20090205223604, 
              1233902109, 
              0.0
            ]
          ], 
          "CentOS release 5 (Final)": [
            [
              4461, 
              20090205223423, 
              1233902035, 
              0.0
            ]
          ], 
          "WINNT 5.2": [
            [
              4517, 
              20090205232757, 
              1233904569, 
              0.0
            ]
          ]
        }, 
        "name": "Refcnt Leaks", 
        "id": 23
      }, 
      "trace_malloc_maxheap": {
        "test_runs": {
          "MacOSX 10.5.2": [
            [
              4475, 
              20090205223604, 
              1233902109, 
              27301900.0
            ]
          ], 
          "CentOS release 5 (Final)": [
            [
              4463, 
              20090205223423, 
              1233902035, 
              26977000.0
            ]
          ], 
          "WINNT 5.2": [
            [
              4527, 
              20090205232757, 
              1233904569, 
              15438900.0
            ]
          ]
        }, 
        "name": "Trace Malloc MaxHeap", 
        "id": 25
      }, 
      "codesighs": {
        "test_runs": {
          "MacOSX 10.5.2": [
            [
              4518, 
              20090205233722, 
              1233905812, 
              19567000.0
            ]
          ], 
          "CentOS release 5 (Final)": [
            [
              4471, 
              20090205222432, 
              1233901408, 
              17067600.0
            ]
          ]
        }, 
        "name": "Codesighs", 
        "id": 27
      }, 
      "tp_memset": {
        "test_runs": {
          "WINNT 5.1": [
            [
              4584, 
              20090205235833, 
              1233907080, 
              70352100.0
            ]
          ]
        }, 
        "name": "Tp3 (Memset)", 
        "id": 9
      }, 
      "tsspider": {
        "test_runs": {
          "MacOSX Darwin 9.2.2": [
            [
              4505, 
              20090205222339, 
              1233901380, 
              100.84
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              4511, 
              20090205222339, 
              1233901380, 
              102.84
            ]
          ], 
          "WINNT 5.1": [
            [
              4579, 
              20090205235833, 
              1233907080, 
              81.719999999999999
            ]
          ]
        }, 
        "name": "SunSpider", 
        "id": 21
      }, 
      "tp_pbytes": {
        "test_runs": {
          "MacOSX Darwin 9.2.2": [
            [
              4510, 
              20090205222339, 
              1233901380, 
              370572000.0
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              4516, 
              20090205222339, 
              1233901380, 
              368243000.0
            ]
          ]
        }, 
        "name": "Tp3 (Private Bytes)", 
        "id": 3
      }, 
      "ts": {
        "test_runs": {
          "MacOSX Darwin 9.2.2": [
            [
              4507, 
              20090205222339, 
              1233901380, 
              1968.4200000000001
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              4513, 
              20090205222339, 
              1233901380, 
              1458.26
            ]
          ], 
          "WINNT 5.1": [
            [
              4581, 
              20090205235833, 
              1233907080, 
              524.52599999999995
            ]
          ]
        }, 
        "name": "Ts", 
        "id": 12
      }, 
      "tp": {
        "test_runs": {
          "MacOSX Darwin 9.2.2": [
            [
              4508, 
              20090205222339, 
              1233901380, 
              339.61200000000002
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              4514, 
              20090205222339, 
              1233901380, 
              343.96699999999998
            ]
          ], 
          "WINNT 5.1": [
            [
              4582, 
              20090205235833, 
              1233907080, 
              188.46700000000001
            ]
          ]
        }, 
        "name": "Tp3", 
        "id": 2
      }, 
      "trace_malloc_allocs": {
        "test_runs": {
          "MacOSX 10.5.2": [
            [
              4476, 
              20090205223604, 
              1233902109, 
              915570.0
            ]
          ], 
          "CentOS release 5 (Final)": [
            [
              4464, 
              20090205223423, 
              1233902035, 
              671465.0
            ]
          ], 
          "WINNT 5.2": [
            [
              4528, 
              20090205232757, 
              1233904569, 
              498009.0
            ]
          ]
        }, 
        "name": "Trace Malloc Allocs", 
        "id": 26
      }, 
      "trace_malloc_leaks": {
        "test_runs": {
          "MacOSX 10.5.2": [
            [
              4474, 
              20090205223604, 
              1233902109, 
              2313850.0
            ]
          ], 
          "CentOS release 5 (Final)": [
            [
              4462, 
              20090205223423, 
              1233902035, 
              908817.0
            ]
          ], 
          "WINNT 5.2": [
            [
              4526, 
              20090205232757, 
              1233904569, 
              105950.0
            ]
          ]
        }, 
        "name": "Trace Malloc Leaks", 
        "id": 24
      }, 
      "tdhtml": {
        "test_runs": {
          "MacOSX Darwin 9.2.2": [
            [
              4506, 
              20090205222339, 
              1233901380, 
              941.41200000000003
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              4512, 
              20090205222339, 
              1233901380, 
              934.29399999999998
            ]
          ], 
          "WINNT 5.1": [
            [
              4580, 
              20090205235833, 
              1233907080, 
              1101.24
            ]
          ]
        }, 
        "name": "DHTML", 
        "id": 14
      }, 
      "tp_rss": {
        "test_runs": {
          "MacOSX Darwin 9.2.2": [
            [
              4509, 
              20090205222339, 
              1233901380, 
              92469100.0
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              4515, 
              20090205222339, 
              1233901380, 
              87750500.0
            ]
          ], 
          "WINNT 5.1": [
            [
              4583, 
              20090205235833, 
              1233907080, 
              76360900.0
            ]
          ]
        }, 
        "name": "Tp3 (RSS)", 
        "id": 5
      }
    }, 
    "fd042e69eb9f": {
      "tp_pbytes": {
        "test_runs": {
          "MacOSX Darwin 9.2.2": [
            [
              1983, 
              20090131210228, 
              1233464520, 
              371372000.0
            ], 
            [
              2007, 
              20090131230227, 
              1233471720, 
              371141000.0
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              1989, 
              20090131210228, 
              1233464520, 
              368693000.0
            ], 
            [
              2013, 
              20090131230227, 
              1233471720, 
              368766000.0
            ]
          ]
        }, 
        "name": "Tp3 (Private Bytes)", 
        "id": 3
      }, 
      "tp_memset": {
        "test_runs": {
          "WINNT 6.0": [
            [
              2031, 
              20090131222356, 
              1233469380, 
              65316700.0
            ], 
            [
              2079, 
              20090201003630, 
              1233477360, 
              64657200.0
            ]
          ], 
          "WINNT 5.1": [
            [
              2025, 
              20090131222356, 
              1233469380, 
              70956700.0
            ], 
            [
              2073, 
              20090201003630, 
              1233477360, 
              71059000.0
            ]
          ]
        }, 
        "name": "Tp3 (Memset)", 
        "id": 9
      }, 
      "tsspider": {
        "test_runs": {
          "WINNT 6.0": [
            [
              2026, 
              20090131222356, 
              1233469380, 
              83.480000000000004
            ], 
            [
              2074, 
              20090201003630, 
              1233477360, 
              83.400000000000006
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              1984, 
              20090131210228, 
              1233464520, 
              102.52
            ], 
            [
              2008, 
              20090131230227, 
              1233471720, 
              102.64
            ]
          ], 
          "MacOSX Darwin 9.2.2": [
            [
              1978, 
              20090131210228, 
              1233464520, 
              100.64
            ], 
            [
              2002, 
              20090131230227, 
              1233471720, 
              100.64
            ]
          ], 
          "WINNT 5.1": [
            [
              2020, 
              20090131222356, 
              1233469380, 
              81.040000000000006
            ], 
            [
              2068, 
              20090201003630, 
              1233477360, 
              81.280000000000001
            ]
          ]
        }, 
        "name": "SunSpider", 
        "id": 21
      }, 
      "ts": {
        "test_runs": {
          "WINNT 6.0": [
            [
              2028, 
              20090131222356, 
              1233469380, 
              657.73699999999997
            ], 
            [
              2076, 
              20090201003630, 
              1233477360, 
              749.15800000000002
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              1986, 
              20090131210228, 
              1233464520, 
              1415.6300000000001
            ], 
            [
              2010, 
              20090131230227, 
              1233471720, 
              1416.95
            ]
          ], 
          "MacOSX Darwin 9.2.2": [
            [
              1980, 
              20090131210228, 
              1233464520, 
              2056.0500000000002
            ], 
            [
              2004, 
              20090131230227, 
              1233471720, 
              2104.1599999999999
            ]
          ], 
          "WINNT 5.1": [
            [
              2022, 
              20090131222356, 
              1233469380, 
              519.47400000000005
            ], 
            [
              2070, 
              20090201003630, 
              1233477360, 
              518.21100000000001
            ]
          ]
        }, 
        "name": "Ts", 
        "id": 12
      }, 
      "tp": {
        "test_runs": {
          "WINNT 6.0": [
            [
              2029, 
              20090131222356, 
              1233469380, 
              364.495
            ], 
            [
              2077, 
              20090201003630, 
              1233477360, 
              372.36700000000002
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              1987, 
              20090131210228, 
              1233464520, 
              350.77300000000002
            ], 
            [
              2011, 
              20090131230227, 
              1233471720, 
              352.06099999999998
            ]
          ], 
          "MacOSX Darwin 9.2.2": [
            [
              1981, 
              20090131210228, 
              1233464520, 
              333.875
            ], 
            [
              2005, 
              20090131230227, 
              1233471720, 
              337.21699999999998
            ]
          ], 
          "WINNT 5.1": [
            [
              2023, 
              20090131222356, 
              1233469380, 
              183.40100000000001
            ], 
            [
              2071, 
              20090201003630, 
              1233477360, 
              182.48699999999999
            ]
          ]
        }, 
        "name": "Tp3", 
        "id": 2
      }, 
      "tdhtml": {
        "test_runs": {
          "WINNT 6.0": [
            [
              2027, 
              20090131222356, 
              1233469380, 
              766.58799999999997
            ], 
            [
              2075, 
              20090201003630, 
              1233477360, 
              767.41200000000003
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              1985, 
              20090131210228, 
              1233464520, 
              944.76499999999999
            ], 
            [
              2009, 
              20090131230227, 
              1233471720, 
              941.471
            ]
          ], 
          "MacOSX Darwin 9.2.2": [
            [
              1979, 
              20090131210228, 
              1233464520, 
              942.11800000000005
            ], 
            [
              2003, 
              20090131230227, 
              1233471720, 
              937.29399999999998
            ]
          ], 
          "WINNT 5.1": [
            [
              2021, 
              20090131222356, 
              1233469380, 
              1094.0599999999999
            ], 
            [
              2069, 
              20090201003630, 
              1233477360, 
              1093.1800000000001
            ]
          ]
        }, 
        "name": "DHTML", 
        "id": 14
      }, 
      "tp_rss": {
        "test_runs": {
          "WINNT 6.0": [
            [
              2030, 
              20090131222356, 
              1233469380, 
              77542900.0
            ], 
            [
              2078, 
              20090201003630, 
              1233477360, 
              78187200.0
            ]
          ], 
          "MacOSX Darwin 8.8.1": [
            [
              1988, 
              20090131210228, 
              1233464520, 
              88590100.0
            ], 
            [
              2012, 
              20090131230227, 
              1233471720, 
              88591600.0
            ]
          ], 
          "MacOSX Darwin 9.2.2": [
            [
              1982, 
              20090131210228, 
              1233464520, 
              94170300.0
            ], 
            [
              2006, 
              20090131230227, 
              1233471720, 
              93683600.0
            ]
          ], 
          "WINNT 5.1": [
            [
              2024, 
              20090131222356, 
              1233469380, 
              77022500.0
            ], 
            [
              2072, 
              20090201003630, 
              1233477360, 
              76895500.0
            ]
          ]
        }, 
        "name": "Tp3 (RSS)", 
        "id": 5
      }
    }
  }
}
Attachment #432053 - Attachment is obsolete: true
Attachment #432073 - Flags: feedback?(justdave)
Attachment #432073 - Flags: feedback?(jmuizelaar)
Attachment #432073 - Flags: feedback?(anodelman)
Attachment #432053 - Flags: feedback?(justdave)
Attachment #432053 - Flags: feedback?(jmuizelaar)
Attachment #432053 - Flags: feedback?(anodelman)
Attachment #432073 - Flags: feedback?(jmuizelaar) → feedback+
(Reporter)

Updated

7 years ago
Attachment #432073 - Flags: review?(rdoherty)
Attachment #432073 - Flags: review?(justdave)
Attachment #432073 - Flags: feedback?(justdave)
Attachment #432073 - Flags: feedback?(anodelman)
Attachment #432073 - Flags: review?(rdoherty) → review+
Here's the EXPLAIN for the query you're adding:

> +----+-------------+-----------+--------+-----------------------------+---------------+---------+------------------------------------------------------------------+------+-------------+
> | id | select_type | table     | type   | possible_keys               | key           | key_len | ref                                                              | rows | Extra       |
> +----+-------------+-----------+--------+-----------------------------+---------------+---------+------------------------------------------------------------------+------+-------------+
> |  1 | SIMPLE      | builds    | ref    | PRIMARY,ref_changeset       | ref_changeset | 768     | const                                                            |    6 | Using where | 
> |  1 | SIMPLE      | tests     | ALL    | PRIMARY                     | NULL          | NULL    | NULL                                                             |   71 |             | 
> |  1 | SIMPLE      | test_runs | ref    | test_id,test_id_2,test_id_3 | test_id       | 7       | graphs_mozilla_org_new.tests.id,graphs_mozilla_org_new.builds.id |    1 |             | 
> |  1 | SIMPLE      | machines  | eq_ref | PRIMARY                     | PRIMARY       | 2       | graphs_mozilla_org_new.test_runs.machine_id                      |    1 |             | 
> |  1 | SIMPLE      | os_list   | eq_ref | PRIMARY                     | PRIMARY       | 1       | graphs_mozilla_org_new.machines.os_id                            |    1 | Using where | 
> +----+-------------+-----------+--------+-----------------------------+---------------+---------+------------------------------------------------------------------+------+-------------+

Nothing's jumping out at me as a missing index or anything, so probably all set on that front.
(Reporter)

Comment 5

7 years ago
Dave, ping?  Anything else you're wanting to do here?
(Reporter)

Comment 6

7 years ago
This is currently running on graphs-stage.  Not all of the data will be available here, but it should be useful for testing.

E.g.

http://graphs-stage.mozilla.org/api/test/runs/revisions?revision=10d2046d2b64
(In reply to comment #6)
> This is currently running on graphs-stage.  Not all of the data will be
> available here, but it should be useful for testing.

I was thinking about porting Jeff's talos comparison script based on the graph-stage API to tbpl.  What portion of data is currently available on graphs-stage?  What is the time frame for getting the new API on graphs?
(Reporter)

Comment 8

7 years ago
(In reply to comment #7)
> (In reply to comment #6)
> > This is currently running on graphs-stage.  Not all of the data will be
> > available here, but it should be useful for testing.
> 
> I was thinking about porting Jeff's talos comparison script based on the
> graph-stage API to tbpl.  What portion of data is currently available on
> graphs-stage?  

Whatever our staging machines happen to test.  It's a much more limited set of data to be sure, but should be enough to for testing.

> What is the time frame for getting the new API on graphs?

As soon as Jeff (and others?) can verify that the output is giving the required information.
Blocks: 558855
(In reply to comment #8)
> (In reply to comment #7)
> > (In reply to comment #6)
> > > This is currently running on graphs-stage.  Not all of the data will be
> > > available here, but it should be useful for testing.
> > 
> > I was thinking about porting Jeff's talos comparison script based on the
> > graph-stage API to tbpl.

This is bug 558855, BTW.

> >  What portion of data is currently available on
> > graphs-stage?  
> 
> Whatever our staging machines happen to test.  It's a much more limited set of
> data to be sure, but should be enough to for testing.

Hmm, I'm not sure how to interpret this.  Which subset of talos runs are processed by the staging machines?  I'd like us to be able to use it on mozilla-central and try at least.

> > What is the time frame for getting the new API on graphs?
> 
> As soon as Jeff (and others?) can verify that the output is giving the required
> information.

I think at its current stage, the output is giving us a lot of good information, if not all we need.  We can always extend the API to return new information, right?
No longer blocks: 558855
(Reporter)

Updated

7 years ago
Depends on: 560850
(Reporter)

Updated

7 years ago
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
(Reporter)

Updated

7 years ago
Attachment #432073 - Flags: review?(justdave)
(Assignee)

Updated

a year ago
Product: Webtools → Webtools Graveyard
You need to log in before you can comment on or make changes to this bug.