Last Comment Bug 551732 - API for fetching data for a given revision
: API for fetching data for a given revision
Status: RESOLVED FIXED
:
Product: Webtools Graveyard
Classification: Graveyard
Component: Graph Server (show other bugs)
: Trunk
: x86 Linux
: -- normal (vote)
: ---
Assigned To: Nobody; OK to take it and work on it
:
Mentors:
Depends on: 560850
Blocks:
  Show dependency treegraph
 
Reported: 2010-03-11 10:59 PST by Chris AtLee [:catlee]
Modified: 2016-06-21 13:37 PDT (History)
3 users (show)
See Also:
QA Whiteboard:
Iteration: ---
Points: ---


Attachments
Implement /api/test/runs/revisions (3.65 KB, patch)
2010-03-11 19:26 PST, Chris AtLee [:catlee]
no flags Details | Diff | Splinter Review
Implement /api/test/runs/revisions (3.88 KB, patch)
2010-03-11 21:26 PST, Chris AtLee [:catlee]
ryan.doherty: review+
jmuizelaar: feedback+
Details | Diff | Splinter Review

Description Chris AtLee [:catlee] 2010-03-11 10:59:07 PST
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': [ ... ],
    }
}
Comment 1 Chris AtLee [:catlee] 2010-03-11 19:26:20 PST
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
      }
    }
  }
}
Comment 2 Chris AtLee [:catlee] 2010-03-11 20:42:56 PST
Whoops, just realized that the results need to be broken up by platform as well.
Comment 3 Chris AtLee [:catlee] 2010-03-11 21:26:30 PST
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
      }
    }
  }
}
Comment 4 Dave Miller [:justdave] (justdave@bugzilla.org) 2010-03-30 09:59:09 PDT
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.
Comment 5 Chris AtLee [:catlee] 2010-04-05 07:26:08 PDT
Dave, ping?  Anything else you're wanting to do here?
Comment 6 Chris AtLee [:catlee] 2010-04-07 16:51:04 PDT
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
Comment 7 :Ehsan Akhgari 2010-04-12 12:24:22 PDT
(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?
Comment 8 Chris AtLee [:catlee] 2010-04-12 12:29:46 PDT
(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.
Comment 9 :Ehsan Akhgari 2010-04-12 12:32:59 PDT
(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?

Note You need to log in before you can comment on or make changes to this bug.