Type to search.

Expensive queries disabled

ECH

Elastic Cloud Hosted lets you manage and configure one or more deployments of the versioned Elastic Stack, hosted on Elastic Cloud.

Availability

  • Generally available

    This functionality is generally available and ready for production usage.

ECK

Elastic Cloud on Kubernetes extends Kubernetes orchestration capabilities to allow you to deploy and manage components of the Elastic Stack.

Availability

  • Generally available

    This functionality is generally available and ready for production usage.

This documentation corresponds to the latest patch available for each minor version. If you're not using the latest patch, check the release notes for changes.

ECE

Elastic Cloud Enterprise is a self-managed orchestration platform for deploying and managing the Elastic Stack at scale.

Availability

  • Generally available

    This functionality is generally available and ready for production usage.

This documentation corresponds to the latest patch available for each minor version. If you're not using the latest patch, check the release notes for changes.

Self-managed

Self-managed deployments are Elastic Stack deployments managed without the assistance of an orchestrator.

Availability

  • Generally available

    This functionality is generally available and ready for production usage.

This documentation corresponds to the latest patch available for each minor version. If you're not using the latest patch, check the release notes for changes.

search.allow_expensive_queries is false, so expensive query types cannot run. That can protect CPU and heap, and it can break Kibana and Fleet features that need those queries.

Note

For a complete list of insights, refer to AutoOps insights.

Field Value
Component Elasticsearch
Severity Medium
Scope Cluster
Domains performance, search, configuration

The following is an example of what you might see when this insight is triggered. Real insights use live data and links from your deployment or cluster.

search.allow_expensive_queries is false. Expensive query types cannot run (for example fuzzy, regexp, prefix, wildcard, script, and percolate).

Note

AutoOps shows different recommendations depending on how their conditions match your deployment or cluster.

Re-enable expensive queries

Condition: Always shown for this insight.

Set search.allow_expensive_queries to true unless this cluster does not use Kibana or Fleet and you are blocking expensive query types on purpose. False can break alerting, dashboards, saved-object search, and Fleet setup. Use the action below.

JSON
PUT _cluster/settings
{
  "persistent": {
    "search.allow_expensive_queries": "true"
  }
}
Note

Requires the manage cluster privilege. Requires Elasticsearch 8.0.0 or later. This action changes cluster or index configuration.

Elasticsearch treats some Query DSL features as expensive because they can use large amounts of CPU and memory and slow other search and indexing on the same nodes.

The default is true so those query types can run. Kibana (alerting, dashboards, saved objects) and Fleet can fail when the setting is false.

If you turned it off to lock down a cluster that does not use Kibana or Fleet, the restriction might be intentional. On a typical Stack deployment, false is usually an unsafe override of the default.

Elastic Support Hub