Skip to content

Instantly share code, notes, and snippets.

@rmchale
Created June 12, 2015 15:10
Show Gist options
  • Save rmchale/b024ebbb315a8634062f to your computer and use it in GitHub Desktop.
Save rmchale/b024ebbb315a8634062f to your computer and use it in GitHub Desktop.
2015-03-30 14:57:00,065 INFO [][89f0ee6696] com.networkedinsights.rest.search.elasticsearch.SearchExecution$QueryLogger - Query for cluster esdev_aud_vert on indices [[media_2015_05, media_2015_07, media_2015_06, media_2015_08]]:{
"size" : 0,
"query" : {
"query_string" : {
"query" : "smartwatch,
"default_field" : "all"
}
},
"filter" : {
"bool" : {
"must" : [ {
"term" : {
"ni.language" : "en"
}
}, {
"term" : {
"dataview" : "7777"
}
}, {
"range" : {
"ni.authored_date" : {
"from" : "2015-02-01T00:00:00",
"to" : "2015-02-17T00:00:00",
"include_lower" : true,
"include_upper" : false
}
}
} ]
}
},
"facets" : {
"posts_by_date" : {
"date_histogram" : {
"field" : "authored_date",
"interval" : "day"
},
"facet_filter" : {
"bool" : {
"must" : [ {
"term" : {
"ni.language" : "en"
}
}, {
"term" : {
"dataview" : "7777"
}
}, {
"range" : {
"ni.authored_date" : {
"from" : "2015-02-01T00:00:00",
"to" : "2015-02-17T00:00:00",
"include_lower" : true,
"include_upper" : false
}
}
} ]
}
}
},
"gender" : {
"terms" : {
"field" : "gender",
"size" : 100
},
"facet_filter" : {
"bool" : {
"must" : [ {
"term" : {
"ni.language" : "en"
}
}, {
"term" : {
"dataview" : "7777"
}
}, {
"range" : {
"ni.authored_date" : {
"from" : "2015-02-01T00:00:00",
"to" : "2015-02-17T00:00:00",
"include_lower" : true,
"include_upper" : false
}
}
} ]
}
}
}
}
}
2015-03-30 14:57:00,067 INFO [][89f0ee6696] com.networkedinsights.rest.search.elasticsearch.SearchExecution$QueryLogger - Query for cluster esdev_decahose on indices [[media_2015_05, media_2015_07, media_2015_06, media_2015_08]]:{
"size" : 0,
"query" : {
"query_string" : {
"query" : "smartwatch",
"default_field" : "all"
}
},
"filter" : {
"bool" : {
"must" : [ {
"term" : {
"ni.language" : "en"
}
}, {
"term" : {
"dataview" : "7777"
}
}, {
"range" : {
"ni.authored_date" : {
"from" : "2015-02-01T00:00:00",
"to" : "2015-02-17T00:00:00",
"include_lower" : true,
"include_upper" : false
}
}
} ]
}
},
"facets" : {
"posts_by_date" : {
"date_histogram" : {
"field" : "authored_date",
"interval" : "day"
},
"facet_filter" : {
"bool" : {
"must" : [ {
"term" : {
"ni.language" : "en"
}
}, {
"term" : {
"dataview" : "7777"
}
}, {
"range" : {
"ni.authored_date" : {
"from" : "2015-02-01T00:00:00",
"to" : "2015-02-17T00:00:00",
"include_lower" : true,
"include_upper" : false
}
}
} ]
}
}
},
"gender" : {
"terms" : {
"field" : "gender",
"size" : 100
},
"facet_filter" : {
"bool" : {
"must" : [ {
"term" : {
"ni.language" : "en"
}
}, {
"term" : {
"dataview" : "7777"
}
}, {
"range" : {
"ni.authored_date" : {
"from" : "2015-02-01T00:00:00",
"to" : "2015-02-17T00:00:00",
"include_lower" : true,
"include_upper" : false
}
}
} ]
}
}
}
}
}
2015-03-30 14:57:00,133 INFO [][89f0ee6696] com.networkedinsights.rest.search.elasticsearch.SearchExecution$QueryLogger - Response for cluster esdev_decahose: {
"took" : 31,
"timed_out" : false,
"_shards" : {
"total" : 8,
"successful" : 8,
"failed" : 0
},
"hits" : {
"total" : 9,
"max_score" : 4.2796235,
"hits" : [ ]
},
"facets" : {
"posts_by_date" : {
"_type" : "date_histogram",
"entries" : [ {
"time" : 1422835200000,
"count" : 1
}, {
"time" : 1422921600000,
"count" : 1
}, {
"time" : 1423008000000,
"count" : 4
}, {
"time" : 1423094400000,
"count" : 1
}, {
"time" : 1423180800000,
"count" : 1
}, {
"time" : 1423440000000,
"count" : 1
} ]
},
"gender" : {
"_type" : "terms",
"missing" : 0,
"total" : 9,
"other" : 0,
"terms" : [ {
"term" : "unknown",
"count" : 7
}, {
"term" : "male",
"count" : 1
}, {
"term" : "female",
"count" : 1
} ]
}
}
}
2015-03-30 14:57:00,135 INFO [][89f0ee6696] com.networkedinsights.rest.search.elasticsearch.SearchExecution$QueryLogger - Response for cluster esdev_aud_vert: {
"took" : 30,
"timed_out" : false,
"_shards" : {
"total" : 4,
"successful" : 4,
"failed" : 0
},
"hits" : {
"total" : 14,
"max_score" : 2.034069,
"hits" : [ ]
},
"facets" : {
"posts_by_date" : {
"_type" : "date_histogram",
"entries" : [ {
"time" : 1422748800000,
"count" : 2
}, {
"time" : 1422921600000,
"count" : 6
}, {
"time" : 1423008000000,
"count" : 3
}, {
"time" : 1423094400000,
"count" : 2
}, {
"time" : 1423353600000,
"count" : 1
} ]
},
"gender" : {
"_type" : "terms",
"missing" : 0,
"total" : 14,
"other" : 0,
"terms" : [ {
"term" : "male",
"count" : 10
}, {
"term" : "female",
"count" : 3
}, {
"term" : "unknown",
"count" : 1
} ]
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment