pymongodb-explain

    '''nReturned和totalDocsExamined最好接近，查询效率更优'''
    qp = {'executionStats': {'allPlansExecution': [],
                             'executionStages': {'advanced': 16591,
                                                 'executionTimeMillisEstimate': 4,
                                                 'inputStage': {'advanced': 16591,
                                                                'alreadyHasObj': 0,
                                                                'docsExamined': 24886,  # 指定在查询执行阶段扫描的文档数。
                                                                'executionTimeMillisEstimate': 3,
                                                                'filter': {'$or': [{'room_num': {'$eq': 2}},
                                                                                   {'room_num': {'$eq': 1}}]},
                                                                'inputStage': {'advanced': 24886,
                                                                               'direction': 'forward',
                                                                               'dupsDropped': 0,
                                                                               'dupsTested': 0,
                                                                               'executionTimeMillisEstimate': 0,
                                                                               'indexBounds': {'created': ['[new '
                                                                                                           'Date(1603065600000), '
                                                                                                           'new '
                                                                                                           'Date(1603149780000)]']},
                                                                               'indexName': 'created_1',
                                                                               'indexVersion': 2,
                                                                               'invalidates': 0,
                                                                               'isEOF': 1,
                                                                               'isMultiKey': False,
                                                                               'isPartial': False,
                                                                               'isSparse': False,
                                                                               'isUnique': False,
                                                                               'keyPattern': {'created': 1},
                                                                               'keysExamined': 24886,
                                                                               'multiKeyPaths': {'created': []},
                                                                               'nReturned': 24886,
                                                                               'needTime': 0,
                                                                               'needYield': 0,
                                                                               'restoreState': 194,
                                                                               'saveState': 194,
                                                                               'seeks': 1,
                                                                               'seenInvalidated': 0,
                                                                               'stage': 'IXSCAN',
                                                                               'works': 24887},
                                                                'invalidates': 0,
                                                                'isEOF': 1,
                                                                'nReturned': 16591,
                                                                'needTime': 8295,
                                                                'needYield': 0,
                                                                'restoreState': 194,
                                                                'saveState': 194,
                                                                'stage': 'FETCH',
                                                                'works': 24887},
                                                 'invalidates': 0,
                                                 'isEOF': 1,
                                                 'nReturned': 16591,
                                                 'needTime': 8295,
                                                 'needYield': 0,
                                                 'restoreState': 194,
                                                 'saveState': 194,
                                                 'stage': 'SUBPLAN',
                                                 'works': 24887},
                             'executionSuccess': True,
                             'executionTimeMillis': 79,  # 选择查询计划和执行查询所需的总时间（以毫秒为单位）
                             'nReturned': 16591,  # 符合查询条件的文档数。
                             'totalDocsExamined': 24886,  # 查询执行期间检查的文档数。
                             'totalKeysExamined': 24886},  # 扫描的索引条目数。
          'ok': 1.0,
          'queryPlanner': {'indexFilterSet': False,  # 一个布尔值，指定MongoDB是否对查询应用了索引过滤器。
                           'namespace': 'yq_info.monitor',  # 一个字符串，它指定<database>.<collection>要对其运行查询的集合名称
                           'parsedQuery': {'$or': [{'$and': [{'room_num': {'$eq': 1}},
                                                             {'created': {
                                                                 '$lte': datetime.datetime(2020, 10, 19, 23, 23)}},
                                                             {'created': {
                                                                 '$gte': datetime.datetime(2020, 10, 19, 0, 0)}}]},
                                                   {'$and': [{'room_num': {'$eq': 2}},
                                                             {'created': {
                                                                 '$lte': datetime.datetime(2020, 10, 19, 23, 23)}},
                                                             {'created': {
                                                                 '$gte': datetime.datetime(2020, 10, 19, 0, 0)}}]}]},
                           'plannerVersion': 1,
                           'rejectedPlans': [],
                           'winningPlan': {'inputStage': {'filter': {'$or': [{'room_num': {'$eq': 2}},
                                                                             {'room_num': {'$eq': 1}}]},
                                                          'inputStage': {'direction': 'forward',
                                                                         'indexBounds': {'created': ['[new '
                                                                                                     'Date(1603065600000), '
                                                                                                     'new '
                                                                                                     'Date(1603149780000)]']},
                                                                         'indexName': 'created_1',
                                                                         'indexVersion': 2,
                                                                         'isMultiKey': False,
                                                                         'isPartial': False,
                                                                         'isSparse': False,
                                                                         'isUnique': False,
                                                                         'keyPattern': {'created': 1},
                                                                         'multiKeyPaths': {'created': []},
                                                                         'stage': 'IXSCAN'},
                                                          'stage': 'FETCH'},
                                           'stage': 'SUBPLAN'}},
          'serverInfo': {'gitVersion': '7e28f4296a04d858a2e3dd84a1e79c9ba59a9568',
                         'host': '0.0.0.0',
                         'port': 27017,
                         'version': '4.0.19'}}