Re: Suggestions to improve Star queries latencies

Do you really have 96 separate disks and memory for each shard? They seemed a bit small and numerous to me, unless you are trying to fit every shard into memory of separate nodes and have the hardware resources for it — > On 19 Apr 2023, at 05:43, Rajani Maski wrote: > > It is a query with po

Re: Suggestions to improve Star queries latencies

Hello, Rajani. I meant [SOLR-14765] optimize DocList creation by skipping sort for sort-irrelevant cases - ASF JIRA (apache.org) On Wed, Apr 19, 2023 at 4:05 AM Rajani Maski wrote: > Hi Mikhail, > >Yes, 9.1.1, that should be helpful, can you

Debug time spent in aggregating the search results

Hi Solr Users, Is there a metric endpoint or a debug/explain type query param that returns average time spent in aggregating the search results from shards? Thanks, Rajani

Re: Suggestions to improve Star queries latencies

Thank you, Mikhail. On Wed, Apr 19, 2023 at 7:59 AM Mikhail Khludnev wrote: > Hello, Rajani. > I meant [SOLR-14765] optimize DocList creation by skipping sort for > sort-irrelevant cases - ASF JIRA (apache.org) > > > On Wed, Apr 19, 2023 at 4:0

Re: Suggestions to improve Star queries latencies

You're hunting for a bottleneck. Here is how I would go about finding it: First I would run the query on a single shard and see how long it takes. If the single shard is slow you've found your bottleneck. If its fast then try the same query on each shard, one of the shards might be slow and you've

Re: Suggestions to improve Star queries latencies

To send the query to a single shard you can add the parameter "distrib=false" to the query and it will stay on that shard. Joel Bernstein http://joelsolr.blogspot.com/ On Wed, Apr 19, 2023 at 5:21 PM Joel Bernstein wrote: > You're hunting for a bottleneck. Here is how I would go about finding

Re: Debug time spent in aggregating the search results

: Hi Solr Users, : : Is there a metric endpoint or a debug/explain type query param that : returns average time spent in aggregating the search results from shards? Sort of? Metrics like "QUERY./select.distrib.requestTimes" tell you the stats on handling a "distributed" request -- which is when