- 
    Type:
Improvement
 - 
    Resolution: Unresolved
 - 
    Priority:
Major - P3
 - 
    None
 - 
    Affects Version/s: None
 - 
    Component/s: None
 
- 
        Query Integration
 - 
        None
 
- 
        None
 - 
        None
 - 
        None
 - 
        None
 - 
        None
 - 
        None
 
From kateryna.kamenieva@mongodb.com over slack
I want to file a request to have ability to clearly distinguish cluster vs db vs collection change stream in DW.
So far I figured out how to tell the difference between cluster vs db vs collection change stream in $queryStats output. * cluster-level: “_internalChangeStreamTransform” stage contains “allChangesForCluster”, {{"key.queryShape.cmdNs": { db: 'admin', coll: '$cmd.aggregate' }}}
- db-level: no mention of “allChangesForCluster”, {{"key.queryShape.cmdNs": { db: <non-admin-db>, coll: '$cmd.aggregate' }}}
 - collection-level: no “allChangesForCluster”; {{"key.queryShape.cmdNs": { db: <non-admin-db>, coll: <user-collection> }}}
 But once data is hashed, I cannot rely on the namespace, so can’t distinguish db vs coll-level change stream in the DW.
How should I file my request? For Query team to output something from the $queryStats or to Cloud InTel to add to output something based on what’s known before output is hashed, smth else?
- is duplicated by
 - 
                    
SERVER-91274 Add change stream type to query shape
-         
 - Closed
 
 -         
 
- is related to
 - 
                    
SERVER-89489 Internal change stream stages should not be serialized for query stats
-         
 - Closed
 
 -