-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Catalog and Routing
-
Fully Compatible
-
ALL
-
v9.0, v8.3, v8.0
-
CAR Team 2026-11-09
-
None
-
None
-
None
-
None
-
None
-
None
-
None
The current $shardedDataDistribution performs a $lookup operation on config.chunks to determine which shards contain chunks for each sharded collection.
The observed execution plan used the {uuid: 1, min: 1} index instead of the existing {uuid: 1, shard: 1, min: 1} index. Therefore, it examines every chunk document matching the collection's UUID to collect the distinct shards ids.
Consequently, the work grows with the total number of chunks across the collections being processed.