Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.8.0-rc0
    • Component/s: Querying
    • Labels:
      None
    • Backwards Compatibility:
      Minor Change
    • Epic Link:
    • Sprint:
      Query 2.7.8

      Description

      Provide new explain format with debugging information and both runtime stats and static query information.

      Deprecate inapplicable old format.

        Issue Links

        Progress
        Resolved Sub-Tasks

        Sub-Tasks

          Activity

          Hide
          david.hows David Hows added a comment -

          Hi Kulathur,

          Thanks for the feedback. We are always looking for ways to improve our user experience, especially for power users.

          To that end, can you give some detail about which specific parts of the explain() are unclear or confusing? And what about those parts is not confusing.

          If we know specifically which parts are confusing, we can address those directly and have a more profound impact on usability going forward.

          Thanks,
          David

          Show
          david.hows David Hows added a comment - Hi Kulathur, Thanks for the feedback. We are always looking for ways to improve our user experience, especially for power users. To that end, can you give some detail about which specific parts of the explain() are unclear or confusing? And what about those parts is not confusing. If we know specifically which parts are confusing, we can address those directly and have a more profound impact on usability going forward. Thanks, David
          Hide
          kraja05 kulathur rajasethupathy added a comment -

          well.

          some example outputs of explain() could be:

          was an index used: yes/no:
          if yes what is name of the index used:
          was an index used for query match only: yes/no
          was an index used for sort only: yes/no
          was an index used for both query match and sort: yes/no

          number of documents returned:
          number of documents scanned:
          number of indexes scanned:

          was a scan done before sort: yes/no
          was a sort done before scan: yes/no

          hope it helps.

          Show
          kraja05 kulathur rajasethupathy added a comment - well. some example outputs of explain() could be: was an index used: yes/no: if yes what is name of the index used: was an index used for query match only: yes/no was an index used for sort only: yes/no was an index used for both query match and sort: yes/no number of documents returned: number of documents scanned: number of indexes scanned: was a scan done before sort: yes/no was a sort done before scan: yes/no hope it helps.
          Hide
          xgen-internal-githook Githook User added a comment -

          Author:

          {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'}

          Message: SERVER-10448 fix candidate deletion in multi plan stage
          Branch: master
          https://github.com/mongodb/mongo/commit/17a35699a9d760965e22e1d3f7ffc813e4edb658

          Show
          xgen-internal-githook Githook User added a comment - Author: {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'} Message: SERVER-10448 fix candidate deletion in multi plan stage Branch: master https://github.com/mongodb/mongo/commit/17a35699a9d760965e22e1d3f7ffc813e4edb658
          Hide
          xgen-internal-githook Githook User added a comment -

          Author:

          {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'}

          Message: SERVER-10448 migrate code out of explain_plan.cpp
          Branch: master
          https://github.com/mongodb/mongo/commit/b494ade9a9461d16ab3812640ca72ee9c9e4345c

          Show
          xgen-internal-githook Githook User added a comment - Author: {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'} Message: SERVER-10448 migrate code out of explain_plan.cpp Branch: master https://github.com/mongodb/mongo/commit/b494ade9a9461d16ab3812640ca72ee9c9e4345c
          Hide
          xgen-internal-githook Githook User added a comment -

          Author:

          {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'}

          Message: SERVER-10448 change default explain mode from queryPlanner to executionStats
          Branch: master
          https://github.com/mongodb/mongo/commit/27000b67341e508294e37082bc05a0705e4f6b69

          Show
          xgen-internal-githook Githook User added a comment - Author: {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'} Message: SERVER-10448 change default explain mode from queryPlanner to executionStats Branch: master https://github.com/mongodb/mongo/commit/27000b67341e508294e37082bc05a0705e4f6b69
          Hide
          xgen-internal-githook Githook User added a comment -

          Author:

          {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'}

          Message: SERVER-10448 explained operations should not use the plan cache
          Branch: master
          https://github.com/mongodb/mongo/commit/95c3ccb36529db9841abd3a7e876ea66aac69420

          Show
          xgen-internal-githook Githook User added a comment - Author: {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'} Message: SERVER-10448 explained operations should not use the plan cache Branch: master https://github.com/mongodb/mongo/commit/95c3ccb36529db9841abd3a7e876ea66aac69420

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                  Agile