### Description

Tracking total hits sometimes has a non-negligible impact on performance. We should disable it when not strictly required.
x-pack/plugin/sql/src/main/java/org/elasticsearch/xpack/sql/execution/search/Querier.java
return new CompositeKeyExtractor(r.key(), r.property(), cfg.zoneId(), r.dataType());
            }
            if (ref instanceof MetricAggRef r) {
                return new MetricAggExtractor(r.name(), r.property(), r.innerKey(), cfg.zoneId(), r.dataType());
            }
            if (ref instanceof TopHitsAggRef r) {
                return new TopHitsAggExtractor(r.name(), r.fieldDataType(), cfg.zoneId());
            }
            if (ref instanceof PivotColumnRef r) {
                return new PivotExtractor(createExtractor(r.pivot(), totalCount), createExtractor(r.agg(), totalCount), r.value());
            }
            if (ref == GlobalCountRef.INSTANCE) {
                return totalCount;
            }
            if (ref instanceof ComputedRef computedRef) {
                Pipe proc = computedRef.processor();
                
                proc = proc.transformDown(AggPathInput.class, l -> {
                    BucketExtractor be = createExtractor(l.context(), totalCount);
                    return new AggExtractorInput(l.source(), l.expression(), l.action(), be);
                });
                return new ComputingExtractor(proc.asProcessor());
            }
            throw new SqlIllegalArgumentException("Unexpected value reference {}", ref.getClass());
        }
    }
    /**
     * Dedicated listener for column retrieval/non-grouped queries (search hits).
     */
    static class SearchHitActionListener extends BaseActionListener {