Skip to content

Instantly share code, notes, and snippets.

@smortex
Created July 1, 2022 02:24
Show Gist options
  • Save smortex/d80358a1b8d474a79c9981871a3eb3de to your computer and use it in GitHub Desktop.
Save smortex/d80358a1b8d474a79c9981871a3eb3de to your computer and use it in GitHub Desktop.
{
"request": {
"url": "api/datasources/proxy/1/_msearch",
"method": "POST",
"data": "{\"search_type\":\"query_then_fetch\",\"ignore_unavailable\":true,\"index\":\"samplerr-*\"}\n{\"size\":0,\"query\":{\"bool\":{\"filter\":[{\"range\":{\"@timestamp\":{\"gte\":1656640431659,\"lte\":1656642231660,\"format\":\"epoch_millis\"}}},{\"query_string\":{\"analyze_wildcard\":true,\"query\":\"service:\\\"memory\\\" AND host.keyword:(\\\"vps278346.vittoria.pro\\\") AND cfunc.keyword:\\\"avg\\\"\"}}]}},\"aggs\":{\"3\":{\"terms\":{\"field\":\"host.keyword\",\"size\":10,\"order\":{\"_key\":\"desc\"},\"min_doc_count\":1},\"aggs\":{\"2\":{\"date_histogram\":{\"field\":\"@timestamp\",\"min_doc_count\":0,\"extended_bounds\":{\"min\":1656640431659,\"max\":1656642231660},\"format\":\"epoch_millis\",\"interval\":\"20s\"},\"aggs\":{\"1\":{\"avg\":{\"field\":\"metric\"}}}}}}}}\n",
"hideFromInspector": false
},
"response": {
"responses": [
{
"took": 7,
"timed_out": false,
"_shards": {
"total": 7,
"successful": 7,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 76,
"max_score": 0,
"hits": []
},
"aggregations": {
"3": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"2": {
"buckets": [
{
"1": {
"value": null
},
"key_as_string": "1656640420000",
"key": 1656640420000,
"doc_count": 0
},
{
"1": {
"value": 0.21764123439788818
},
"key_as_string": "1656640440000",
"key": 1656640440000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656640460000",
"key": 1656640460000,
"doc_count": 0
},
{
"1": {
"value": 0.2176283448934555
},
"key_as_string": "1656640480000",
"key": 1656640480000,
"doc_count": 1
},
{
"1": {
"value": 0.21761365234851837
},
"key_as_string": "1656640500000",
"key": 1656640500000,
"doc_count": 1
},
{
"1": {
"value": 0.2176368087530136
},
"key_as_string": "1656640520000",
"key": 1656640520000,
"doc_count": 1
},
{
"1": {
"value": 0.21763546764850616
},
"key_as_string": "1656640540000",
"key": 1656640540000,
"doc_count": 1
},
{
"1": {
"value": 0.21762841939926147
},
"key_as_string": "1656640560000",
"key": 1656640560000,
"doc_count": 1
},
{
"1": {
"value": 0.2176322489976883
},
"key_as_string": "1656640580000",
"key": 1656640580000,
"doc_count": 1
},
{
"1": {
"value": 0.21514788269996643
},
"key_as_string": "1656640600000",
"key": 1656640600000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656640620000",
"key": 1656640620000,
"doc_count": 0
},
{
"1": {
"value": 0.21449795365333557
},
"key_as_string": "1656640640000",
"key": 1656640640000,
"doc_count": 1
},
{
"1": {
"value": 0.21450583636760712
},
"key_as_string": "1656640660000",
"key": 1656640660000,
"doc_count": 1
},
{
"1": {
"value": 0.2145092934370041
},
"key_as_string": "1656640680000",
"key": 1656640680000,
"doc_count": 1
},
{
"1": {
"value": 0.21449661254882812
},
"key_as_string": "1656640700000",
"key": 1656640700000,
"doc_count": 1
},
{
"1": {
"value": 0.2145029902458191
},
"key_as_string": "1656640720000",
"key": 1656640720000,
"doc_count": 1
},
{
"1": {
"value": 0.2145129293203354
},
"key_as_string": "1656640740000",
"key": 1656640740000,
"doc_count": 1
},
{
"1": {
"value": 0.21553635597229004
},
"key_as_string": "1656640760000",
"key": 1656640760000,
"doc_count": 1
},
{
"1": {
"value": 0.2164400815963745
},
"key_as_string": "1656640780000",
"key": 1656640780000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656640800000",
"key": 1656640800000,
"doc_count": 0
},
{
"1": {
"value": 0.21642880141735077
},
"key_as_string": "1656640820000",
"key": 1656640820000,
"doc_count": 1
},
{
"1": {
"value": 0.2164314240217209
},
"key_as_string": "1656640840000",
"key": 1656640840000,
"doc_count": 1
},
{
"1": {
"value": 0.21632987260818481
},
"key_as_string": "1656640860000",
"key": 1656640860000,
"doc_count": 1
},
{
"1": {
"value": 0.21631628274917603
},
"key_as_string": "1656640880000",
"key": 1656640880000,
"doc_count": 1
},
{
"1": {
"value": 0.2163870483636856
},
"key_as_string": "1656640900000",
"key": 1656640900000,
"doc_count": 1
},
{
"1": {
"value": 0.2164240926504135
},
"key_as_string": "1656640920000",
"key": 1656640920000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656640940000",
"key": 1656640940000,
"doc_count": 0
},
{
"1": {
"value": 0.21642006933689117
},
"key_as_string": "1656640960000",
"key": 1656640960000,
"doc_count": 1
},
{
"1": {
"value": 0.2164318859577179
},
"key_as_string": "1656640980000",
"key": 1656640980000,
"doc_count": 1
},
{
"1": {
"value": 0.216432586312294
},
"key_as_string": "1656641000000",
"key": 1656641000000,
"doc_count": 1
},
{
"1": {
"value": 0.2166355699300766
},
"key_as_string": "1656641020000",
"key": 1656641020000,
"doc_count": 1
},
{
"1": {
"value": 0.2143881916999817
},
"key_as_string": "1656641040000",
"key": 1656641040000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656641060000",
"key": 1656641060000,
"doc_count": 0
},
{
"1": {
"value": 0.21437744796276093
},
"key_as_string": "1656641080000",
"key": 1656641080000,
"doc_count": 1
},
{
"1": {
"value": 0.2143724113702774
},
"key_as_string": "1656641100000",
"key": 1656641100000,
"doc_count": 1
},
{
"1": {
"value": 0.2143818736076355
},
"key_as_string": "1656641120000",
"key": 1656641120000,
"doc_count": 1
},
{
"1": {
"value": 0.21437643468379974
},
"key_as_string": "1656641140000",
"key": 1656641140000,
"doc_count": 1
},
{
"1": {
"value": 0.214364692568779
},
"key_as_string": "1656641160000",
"key": 1656641160000,
"doc_count": 1
},
{
"1": {
"value": 0.21438725292682648
},
"key_as_string": "1656641180000",
"key": 1656641180000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656641200000",
"key": 1656641200000,
"doc_count": 0
},
{
"1": {
"value": 0.21437913179397583
},
"key_as_string": "1656641220000",
"key": 1656641220000,
"doc_count": 1
},
{
"1": {
"value": 0.21437107026576996
},
"key_as_string": "1656641240000",
"key": 1656641240000,
"doc_count": 1
},
{
"1": {
"value": 0.21437643468379974
},
"key_as_string": "1656641260000",
"key": 1656641260000,
"doc_count": 1
},
{
"1": {
"value": 0.21438147127628326
},
"key_as_string": "1656641280000",
"key": 1656641280000,
"doc_count": 1
},
{
"1": {
"value": 0.21437375247478485
},
"key_as_string": "1656641300000",
"key": 1656641300000,
"doc_count": 1
},
{
"1": {
"value": 0.21436496078968048
},
"key_as_string": "1656641320000",
"key": 1656641320000,
"doc_count": 1
},
{
"1": {
"value": 0.2144029587507248
},
"key_as_string": "1656641340000",
"key": 1656641340000,
"doc_count": 1
},
{
"1": {
"value": 0.2143915444612503
},
"key_as_string": "1656641360000",
"key": 1656641360000,
"doc_count": 1
},
{
"1": {
"value": 0.21437959372997284
},
"key_as_string": "1656641380000",
"key": 1656641380000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656641400000",
"key": 1656641400000,
"doc_count": 0
},
{
"1": {
"value": 0.21439409255981445
},
"key_as_string": "1656641420000",
"key": 1656641420000,
"doc_count": 1
},
{
"1": {
"value": 0.21439556777477264
},
"key_as_string": "1656641440000",
"key": 1656641440000,
"doc_count": 1
},
{
"1": {
"value": 0.21438366174697876
},
"key_as_string": "1656641460000",
"key": 1656641460000,
"doc_count": 1
},
{
"1": {
"value": 0.214375838637352
},
"key_as_string": "1656641480000",
"key": 1656641480000,
"doc_count": 1
},
{
"1": {
"value": 0.2144024521112442
},
"key_as_string": "1656641500000",
"key": 1656641500000,
"doc_count": 1
},
{
"1": {
"value": 0.2143951654434204
},
"key_as_string": "1656641520000",
"key": 1656641520000,
"doc_count": 1
},
{
"1": {
"value": 0.2143850028514862
},
"key_as_string": "1656641540000",
"key": 1656641540000,
"doc_count": 1
},
{
"1": {
"value": 0.21438872814178467
},
"key_as_string": "1656641560000",
"key": 1656641560000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656641580000",
"key": 1656641580000,
"doc_count": 0
},
{
"1": {
"value": 0.21439732611179352
},
"key_as_string": "1656641600000",
"key": 1656641600000,
"doc_count": 1
},
{
"1": {
"value": 0.21438634395599365
},
"key_as_string": "1656641620000",
"key": 1656641620000,
"doc_count": 1
},
{
"1": {
"value": 0.21711745858192444
},
"key_as_string": "1656641640000",
"key": 1656641640000,
"doc_count": 1
},
{
"1": {
"value": 0.21438738703727722
},
"key_as_string": "1656641660000",
"key": 1656641660000,
"doc_count": 1
},
{
"1": {
"value": 0.21439315378665924
},
"key_as_string": "1656641680000",
"key": 1656641680000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656641700000",
"key": 1656641700000,
"doc_count": 0
},
{
"1": {
"value": 0.21438248455524445
},
"key_as_string": "1656641720000",
"key": 1656641720000,
"doc_count": 1
},
{
"1": {
"value": 0.21437308192253113
},
"key_as_string": "1656641740000",
"key": 1656641740000,
"doc_count": 1
},
{
"1": {
"value": 0.2143951654434204
},
"key_as_string": "1656641760000",
"key": 1656641760000,
"doc_count": 1
},
{
"1": {
"value": 0.21438650786876678
},
"key_as_string": "1656641780000",
"key": 1656641780000,
"doc_count": 1
},
{
"1": {
"value": 0.2243359535932541
},
"key_as_string": "1656641800000",
"key": 1656641800000,
"doc_count": 1
},
{
"1": {
"value": 0.22106105089187622
},
"key_as_string": "1656641820000",
"key": 1656641820000,
"doc_count": 1
},
{
"1": {
"value": 0.2144198715686798
},
"key_as_string": "1656641840000",
"key": 1656641840000,
"doc_count": 1
},
{
"1": {
"value": 0.21441759169101715
},
"key_as_string": "1656641860000",
"key": 1656641860000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656641880000",
"key": 1656641880000,
"doc_count": 0
},
{
"1": {
"value": 0.21439826488494873
},
"key_as_string": "1656641900000",
"key": 1656641900000,
"doc_count": 1
},
{
"1": {
"value": 0.21439674496650696
},
"key_as_string": "1656641920000",
"key": 1656641920000,
"doc_count": 1
},
{
"1": {
"value": 0.21441303193569183
},
"key_as_string": "1656641940000",
"key": 1656641940000,
"doc_count": 1
},
{
"1": {
"value": 0.21438980102539062
},
"key_as_string": "1656641960000",
"key": 1656641960000,
"doc_count": 1
},
{
"1": {
"value": 0.21439003944396973
},
"key_as_string": "1656641980000",
"key": 1656641980000,
"doc_count": 1
},
{
"1": {
"value": 0.21440403163433075
},
"key_as_string": "1656642000000",
"key": 1656642000000,
"doc_count": 1
},
{
"1": {
"value": 0.21440067887306213
},
"key_as_string": "1656642020000",
"key": 1656642020000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656642040000",
"key": 1656642040000,
"doc_count": 0
},
{
"1": {
"value": 0.2143951654434204
},
"key_as_string": "1656642060000",
"key": 1656642060000,
"doc_count": 1
},
{
"1": {
"value": 0.21440362930297852
},
"key_as_string": "1656642080000",
"key": 1656642080000,
"doc_count": 1
},
{
"1": {
"value": 0.21440497040748596
},
"key_as_string": "1656642100000",
"key": 1656642100000,
"doc_count": 1
},
{
"1": {
"value": 0.21438567340373993
},
"key_as_string": "1656642120000",
"key": 1656642120000,
"doc_count": 1
},
{
"1": {
"value": 0.21438618004322052
},
"key_as_string": "1656642140000",
"key": 1656642140000,
"doc_count": 1
},
{
"1": {
"value": 0.21440094709396362
},
"key_as_string": "1656642160000",
"key": 1656642160000,
"doc_count": 1
},
{
"1": {
"value": null
},
"key_as_string": "1656642180000",
"key": 1656642180000,
"doc_count": 0
},
{
"1": {
"value": null
},
"key_as_string": "1656642200000",
"key": 1656642200000,
"doc_count": 0
},
{
"1": {
"value": null
},
"key_as_string": "1656642220000",
"key": 1656642220000,
"doc_count": 0
}
]
},
"key": "vps278346.vittoria.pro",
"doc_count": 76
}
]
}
},
"status": 200
}
],
"$$config": {
"url": "api/datasources/proxy/1/_msearch",
"method": "POST",
"data": "{\"search_type\":\"query_then_fetch\",\"ignore_unavailable\":true,\"index\":\"samplerr-*\"}\n{\"size\":0,\"query\":{\"bool\":{\"filter\":[{\"range\":{\"@timestamp\":{\"gte\":1656640431659,\"lte\":1656642231660,\"format\":\"epoch_millis\"}}},{\"query_string\":{\"analyze_wildcard\":true,\"query\":\"service:\\\"memory\\\" AND host.keyword:(\\\"vps278346.vittoria.pro\\\") AND cfunc.keyword:\\\"avg\\\"\"}}]}},\"aggs\":{\"3\":{\"terms\":{\"field\":\"host.keyword\",\"size\":10,\"order\":{\"_key\":\"desc\"},\"min_doc_count\":1},\"aggs\":{\"2\":{\"date_histogram\":{\"field\":\"@timestamp\",\"min_doc_count\":0,\"extended_bounds\":{\"min\":1656640431659,\"max\":1656642231660},\"format\":\"epoch_millis\",\"interval\":\"20s\"},\"aggs\":{\"1\":{\"avg\":{\"field\":\"metric\"}}}}}}}}\n",
"hideFromInspector": false
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment