I've shared the build system's BigQuery dataset for those who want to play.
There are two tables;
Builds -- summary of every build (1.8M and counting)
Spans -- summary of every step of every build (19.8M and counting)
Example queries:
Fastest make.bash by builder in the past two weeks:
SELECT Builder, AVG(Seconds) As AvgSec, COUNT(*) As Count
FROM
[symbolic-datum-552.builds.Spans]
Where
Event = "make"
AND StartTime > DATE_ADD(CURRENT_TIMESTAMP(), -14, "DAY")
AND Error = ""
Group By Builder
Order By AvgSec ;
Trybot builder speeds: (e.g. why are trybots slow?)
SELECT
Builder,
NTH(951, QUANTILES(Seconds, 1001)) as Secs95p,
STDDEV(Seconds) as StdDevSec,
AVG(Seconds) as AverageSec,
COUNT(*) AS count
FROM
builds.Builds
WHERE
Result="ok"
AND istry = TRUE
AND Repo = "go"
AND StartTime > DATE_ADD(CURRENT_TIMESTAMP(), -14, "DAY")
GROUP BY
Builder
ORDER BY
AverageSec DESC;
etc
If you find anything fun or make anything pretty, please share!