jq

Key and values

Extract keys

Extract keys

$ echo '{ "a": 1, "b": 2, "c": 3 }' | jq keys
[
  "a",
  "b",
  "c"
]

$ echo '{ "a": 1, "b": 2, "c": 3, "d": { "aaa": 11 } }' | jq '.d | keys'
[
  "aaa"
]

Demo: https://jqplay.org/s/D3L0oGVSq3

You can quickly create filters to return a particular metric of the JSON file.

jq '. | select(.type=="Point" and .metric == "http_req_duration" and .data.tags.status >= "200")' myscript-output.json

And calculate an aggregated value of any metric.

// average
jq '. | select(.type=="Point" and .metric == "http_req_duration" and .data.tags.status >= "200") | .data.value' myscript-output.json | jq -s 'add/length'

// min
jq '. | select(.type=="Point" and .metric == "http_req_duration" and .data.tags.status >= "200") | .data.value' myscript-output.json | jq -s min

// max
jq '. | select(.type=="Point" and .metric == "http_req_duration" and .data.tags.status >= "200") | .data.value' myscript-output.json | jq -s max