1*c8dee2aaSAndroid Build Coastguard Worker# Job Analysis 2*c8dee2aaSAndroid Build Coastguard Worker 3*c8dee2aaSAndroid Build Coastguard WorkerA set of scripts that analyzes `jobs.json` to look for possible holes in our 4*c8dee2aaSAndroid Build Coastguard Workertesting. 5*c8dee2aaSAndroid Build Coastguard Worker 6*c8dee2aaSAndroid Build Coastguard Worker## Requirements 7*c8dee2aaSAndroid Build Coastguard Worker 8*c8dee2aaSAndroid Build Coastguard WorkerTo run the scripts you need to have both `jq` and `mlr` installed on your 9*c8dee2aaSAndroid Build Coastguard Workermachine. 10*c8dee2aaSAndroid Build Coastguard Worker 11*c8dee2aaSAndroid Build Coastguard Worker $ sudo apt install jq miller 12*c8dee2aaSAndroid Build Coastguard Worker 13*c8dee2aaSAndroid Build Coastguard Worker## Running 14*c8dee2aaSAndroid Build Coastguard Worker 15*c8dee2aaSAndroid Build Coastguard WorkerThe Makefile contains common queries that can be run against the data. 16*c8dee2aaSAndroid Build Coastguard Worker 17*c8dee2aaSAndroid Build Coastguard WorkerFor example, to find all cpu_or_gpu_values that we currently don't run Perf 18*c8dee2aaSAndroid Build Coastguard Workertests on you would run: 19*c8dee2aaSAndroid Build Coastguard Worker 20*c8dee2aaSAndroid Build Coastguard Worker $ make missing_perf_jobs 21*c8dee2aaSAndroid Build Coastguard Worker 22*c8dee2aaSAndroid Build Coastguard WorkerSee https://miller.readthedocs.io/en/latest/reference-dsl.html more details on 23*c8dee2aaSAndroid Build Coastguard Workerthe the kinds of queries that can be done against CSV files. 24