Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-89578

Distinguish between cluster vs db vs collection level change stream in $queryStats

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Integration

      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?

            Assignee:
            chris.wolff@mongodb.com Chris Wolff
            Reporter:
            colby.ing@mongodb.com Colby Ing
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: