The following revision refers to this bug:
  https://chromium.googlesource.com/infra/infra.git/+/0539a5da9122baf2b74dd6ea7684d9121e3f8b2b

commit 0539a5da9122baf2b74dd6ea7684d9121e3f8b2b
Author: lijeffrey <lijeffrey@chromium.org>
Date: Fri Jun 17 01:39:14 2016

[Findit] Adding script for custom try job queries

BUG= 619637 

Usage:

python try_job_data_metrics.py [args] where args can be:
-t: Separates try job by type (compile, test).
-m: Aggregates data by each master (chromium.chrome, chromium.linux, etc)
-b: Aggregates data by master and builder. Note passing this argument has the effect of breaking down by master first, then by builder.
-r: Whether or not heuristic results were used to guide the try job
-c: Whether or not compile targets were identified to speed up compile

For example:

python try_job_data_metrics.py
try_jobs_per_day: ...
average_regression_range_size: ...
average_execution_time: ...
average_commits_analyzed: ...
longest_execution_time: ...
shortest_execution_time: ...
number_of_try_jobs: ...
detection_rate: ...
error_rate: ...
time_per_revision: ...
under_five_minutes_rate: ...
under_fifteen_minutes_rate: ...
under_thirty_minutes_rate: ...
over_thirty_minutes_rate: ...

python try_job_metrics.py -t
Compile:
  <stats ...>
Test:
  <stats ...>

python try_job_metrics.py -t -m
Compile:
  chromium.chrome:
    <stats ...>
  chromium.linux:
    <stats ...>
  ...
Test:
  chromium.chrome:
    <stats ...>
  ...

Review-Url: https://codereview.chromium.org/2056623002

[add] https://crrev.com/0539a5da9122baf2b74dd6ea7684d9121e3f8b2b/appengine/findit/util_scripts/remote_queries/try_job_data_metrics.py