I'm planning to use Composite Aggregation in one of my projects and wanted to know how expensive these operations are. Specifically, I wanted to see how does the compute and memory cost increase along with following values.
- Total cardinality of the query
- Total number of documents in the cluster/shard/index
- Addition of filters
Is there any downside in using the Composite Aggregation?