Skip to content

Instantly share code, notes, and snippets.

@jaydanielian

jaydanielian/gist:e374a401560f3e3b1812

Created June 5, 2015 14:43
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 jaydanielian/e374a401560f3e3b1812 to your computer and use it in GitHub Desktop.
Save jaydanielian/e374a401560f3e3b1812 to your computer and use it in GitHub Desktop.
Download ZIP
sample syntax of slow query from slow log
Raw
gistfile1.txt
[2015-06-05 14:12:07,206][INFO ][index.search.slowlog.query] [siq-prod-es05] [011-20150521][3] took[8.5s], took_millis[8587], types[indexed_entity], stats[], search_type[QUERY_AND_FETCH], total_shards[1], source[{"size":10,"sort":[{"entity_rank":"desc"}],"query":{"constant_score":{"query":{"bool":{"should":[{"nested":{"path":"indexed_entity.terms.emails","query":{"bool":{"must":{"terms":{"eh":["2185297396a9bb84b2908d559d347470"]}}}}}},{"nested":{"path":"indexed_entity.terms.phone_numbers","query":{"bool":{"must":{"terms":{"dh":["25b7fde1e280ea367474ce8f8d7242ee"]}}}}}}],"must":{"nested":{"path":"indexed_entity.terms.names","query":{"bool":{"must":{"terms":{"ln_h":["e5d7cd196fdd8d6490e8da5f788f5c74"],"fn_h":["2b877b4b825b48a9a0950dd5bd1f264d"]}}}}}},"minimum_number_should_match":1}}}},"post_filter":{"range":{"conf_v2":{"gte":0.85},"_cache":false}}}], extra_source[]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment