Skip to content

Instantly share code, notes, and snippets.

@jeffeDivert
Last active August 29, 2016 01:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeffeDivert/3b0b878cd4833ca5b0568d78dd68a8ed to your computer and use it in GitHub Desktop.
Save jeffeDivert/3b0b878cd4833ca5b0568d78dd68a8ed to your computer and use it in GitHub Desktop.
GET hbtest03-2016.08.23/logs/_search
{
"took": 106,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"failed": 0
},
"hits": {
"total": 254210,
"max_score": 0,
"hits": []
},
"aggregations": {
"lastheartbeat": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 65227,
"buckets": [
{
"key": "0009",
"doc_count": 24389,
"recent_beats": {
"hits": {
"total": 24389,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558585",
"_score": null,
"_source": {
"index": 558585,
"sn": "0009",
"sql_time": "2016-08-23T23:54:11.000Z",
"debug": {
"count": 94,
"pressure": 341,
"version": "2.3.3"
},
"location_city": "Carlisle",
"@version": "1",
"@timestamp": "2016-08-23T20:01:25.997Z"
},
"sort": [
1471996451000
]
}
]
}
}
},
{
"key": "0006",
"doc_count": 23594,
"recent_beats": {
"hits": {
"total": 23594,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "527203",
"_score": null,
"_source": {
"index": 527203,
"sn": "0006",
"sql_time": "2016-08-12T18:10:05.000Z",
"debug": {
"count": 5,
"version": "2.0.0"
},
"location_city": "Concord",
"@version": "1",
"@timestamp": "2016-08-23T20:01:08.681Z"
},
"sort": [
1471025405000
]
}
]
}
}
},
{
"key": "0011",
"doc_count": 23238,
"recent_beats": {
"hits": {
"total": 23238,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558592",
"_score": null,
"_source": {
"index": 558592,
"sn": "0011",
"sql_time": "2016-08-23T23:58:28.000Z",
"debug": {
"count": 55,
"pressure": 808,
"version": "2.3.3"
},
"location_city": "Carlisle",
"@version": "1",
"@timestamp": "2016-08-23T20:01:26.053Z"
},
"sort": [
1471996708000
]
}
]
}
}
},
{
"key": "0010",
"doc_count": 23019,
"recent_beats": {
"hits": {
"total": 23019,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558584",
"_score": null,
"_source": {
"index": 558584,
"sn": "0010",
"sql_time": "2016-08-23T23:54:11.000Z",
"debug": {
"count": 37,
"pressure": 802,
"version": "2.3.3"
},
"location_city": "Carlisle",
"@version": "1",
"@timestamp": "2016-08-23T20:01:25.999Z"
},
"sort": [
1471996451000
]
}
]
}
}
},
{
"key": "0005",
"doc_count": 18987,
"recent_beats": {
"hits": {
"total": 18987,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558593",
"_score": null,
"_source": {
"index": 558593,
"sn": "0005",
"sql_time": "2016-08-23T23:58:53.000Z",
"debug": {
"count": 17,
"pressure": 1,
"version": "2.3.3"
},
"location_city": "Freetown",
"@version": "1",
"@timestamp": "2016-08-23T20:01:25.991Z"
},
"sort": [
1471996733000
]
}
]
}
}
},
{
"key": "0007",
"doc_count": 17094,
"recent_beats": {
"hits": {
"total": 17094,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558589",
"_score": null,
"_source": {
"index": 558589,
"sn": "0007",
"sql_time": "2016-08-23T23:57:11.000Z",
"debug": {
"count": 116,
"pressure": 414,
"version": "2.3.3"
},
"location_city": "Freetown",
"@version": "1",
"@timestamp": "2016-08-23T20:01:25.994Z"
},
"sort": [
1471996631000
]
}
]
}
}
},
{
"key": "0014",
"doc_count": 16458,
"recent_beats": {
"hits": {
"total": 16458,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558588",
"_score": null,
"_source": {
"index": 558588,
"sn": "0014",
"sql_time": "2016-08-23T23:54:43.000Z",
"debug": {
"count": 544,
"pressure": 162,
"version": "2.3.3"
},
"location_city": "Landover",
"@version": "1",
"@timestamp": "2016-08-23T20:01:26.056Z"
},
"sort": [
1471996483000
]
}
]
}
}
},
{
"key": "0002",
"doc_count": 15412,
"recent_beats": {
"hits": {
"total": 15412,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558583",
"_score": null,
"_source": {
"index": 558583,
"sn": "0002",
"sql_time": "2016-08-23T23:54:06.000Z",
"debug": {
"count": 82,
"pressure": 1296,
"version": "2.3.3"
},
"location_city": "Freetown",
"@version": "1",
"@timestamp": "2016-08-23T20:01:25.938Z"
},
"sort": [
1471996446000
]
}
]
}
}
},
{
"key": "0003",
"doc_count": 14478,
"recent_beats": {
"hits": {
"total": 14478,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558587",
"_score": null,
"_source": {
"index": 558587,
"sn": "0003",
"sql_time": "2016-08-23T23:54:38.000Z",
"debug": {
"count": 2,
"pressure": 0,
"version": "2.3.3"
},
"location_city": "N/A",
"@version": "1",
"@timestamp": "2016-08-23T20:01:25.938Z"
},
"sort": [
1471996478000
]
}
]
}
}
},
{
"key": "0012",
"doc_count": 12312,
"recent_beats": {
"hits": {
"total": 12312,
"max_score": null,
"hits": [
{
"_index": "hbtest03-2016.08.23",
"_type": "logs",
"_id": "558139",
"_score": null,
"_source": {
"index": 558139,
"sn": "0012",
"sql_time": "2016-08-23T19:50:22.000Z",
"debug": {
"count": 39,
"pressure": 0,
"version": "2.3.3"
},
"location_city": "Landover",
"@version": "1",
"@timestamp": "2016-08-23T20:01:25.196Z"
},
"sort": [
1471981822000
]
}
]
}
}
}
]
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment