For tests over 1M document collection add versions of the queries for smaller collection sizes (100 and 10K documents).
We have wide $and and $or queries with many terms on a single level. In Genny:
MatchOrWithManyChildClausesTemplate: runs $or with 50, 100, and 200 clauses, 1M documents.
MatchAndWithManyChildClausesTemplate: runs $and with 50, 100, and 200 terms over the same array field, equalities, 1M documents.
There are few queries with DNF and mixed predicates, up to 3 levels, 1M documents:
MatchExpressionDeepPredicate
MatchExpressionMixedPredicate
Recently MatchWithLargeExpression added DNF queries with 2 levels and up to 50000 clauses, 10 documents.
There are several queries with $elemMatch:
MatchElemMatchObject: $or with 4 terms, 1M documents
MatchElemMatchObjectWide: $or with 28 terms, 1M documents
- is depended on by
-
SERVER-83894 Collscan benchmarks - complex queries in DNF, CNF, and mixed expressions
- Closed
-
SERVER-83898 Collscan benchmarks - complex $elemMatch predicates
- Closed
-
SERVER-84088 Tag new collscan workloads and add them to the Bonsai dashboard
- Closed