Site LogoSite Logo
  • 🗃️ read_me
  • backend
    • api
    • canal
    • data-systems
    • databases
      • elasticsearch
        • elasticsearch_aggregations
        • elasticsearch_analyzer_configuration
        • elasticsearch_analyzers
        • elasticsearch_book_chapter_3
        • elasticsearch_cluster
        • elasticsearch_scoring_relevance
        • elasticsearch_text_searches
        • elasticsearch_types
        • es_api_cheatsheet
        • es_expensive_queries
        • es_ngram
        • es_query_dsl
        • es_realtime_search
        • es_search_after
        • n_gram
        • prefix_vs_match_phrase_prefix
        • vector_search
      • fundamentals
      • mysql
      • redis
    • frameworks
    • hologres
    • integration
    • languages
    • media
    • os
    • sql
    • streaming
  • concepts
  • dump
  • finance
  • frontend
  • infrastructure
  • skating
  • backend
  • databases
  • elasticsearch
  • es_expensive_queries

🗓️ 23052024 1433

ES EXPENSIVE QUERIES
  • Generally execute slowly
  • Can affect cluster

Linear scans to identify matches​

  • script
  • queries on certain fields of types that are not indexed but have doc values enabled
    • boolean
    • numberic
    • date
    • ip
    • geo_point
    • keyword

High upfront cost​

  • fuzzy queries
  • regexp queries
  • prefix queries
  • wildcard queries
  • range queries on text / keyword fields

Joining queries​

...


References​

  • https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl.html
Previous
es_api_cheatsheet
Next
es_ngram
  • Linear scans to identify matches
  • High upfront cost
  • Joining queries
  • References