# Really bad post\_filter performance
**URL:** https://discuss.elastic.co/t/really-bad-post-filter-performance/16729
**Category:** Elasticsearch
**Created:** [March 31, 2014, 11:33pm UTC](https://discuss.elastic.co/t/really-bad-post-filter-performance/16729 "2014-03-31T23:33:18Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@daveey](https://discuss.elastic.co/u/daveey)
#### Post date: [March 31, 2014, 11:33pm UTC](https://discuss.elastic.co/t/really-bad-post-filter-performance/16729/1 "2014-03-31T23:33:18Z")
I just upgraded to ES 1.0.1 from ES 0.9.2 and am seeing huge performance
problems.
I traced them to what I think is the post\_filter.
Here is the query that we used to run against ES 0.9.2
{
filter": {
"and": [
{
"terms": {
"index\_ids": [
2134616789944
]
}
},
{
"or": [
{
"term": {
"trashed\_at": 0
}
},
{
"not": {
"exists": {
"field": "trashed\_at"
}
}
}
]
}
]
}
}
This used to take the 0.9 cluster about 150ms to execute
The same query takes about 2.5s for the 1.0 cluster.
I rewrote it to conform to my understanding of the changes in 1.0, using a
filtered query, however, that didn't help.
I then tried to figure out which parts were slow. I now have the following
query
{
"query": {
"filtered": {
"query": {
"match\_all": {}
},
"filter": {
"terms": {
"index\_ids": [
2134616789944
]}
}
}
},
"post\_filter": {
"or": [
{"term": {"trashed\_at": 0}},
{"not": {"exists": {"field": "trashed\_at"}}}
]}
}
It takes 2.5 s and returns 34 hits. However, removing the "post\_filter"
clause:
{
"query": {
"filtered": {
"query": {
"match\_all": {}
},
"filter": {
"terms": {
"index\_ids": [
2134616789944
]
}
}
}
}
}
Makes it take 50ms and return 34 results.
My conclusion is that it's taking 2.5 seconds to filter 34 results, and
that's confusing.
The cluster uses 3 machines, 50 shards, 2 replicas per shard. This means
that each machine has the entire copy of the index. We use the ?routing=
parameter, and are always hitting a single shard for the query.
Help?
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/cd5b6bb1-7fce-4688-84cb-4ec6d0db8f93%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/cd5b6bb1-7fce-4688-84cb-4ec6d0db8f93%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:39am UTC](https://discuss.elastic.co/t/really-bad-post-filter-performance/16729/2 "2017-07-06T01:39:09Z")