Untitled

mail@pastecode.io avatar
unknown
json
2 years ago
6.1 kB
0
Indexable
Never
{'ok': 1.0,
 'serverInfo': {'gitVersion': '8db30a63db1a9d84bdcad0c83369623f708e0397',
                'host': 'a45c2858bf8b',
                'port': 27017,
                'version': '4.4.4'},
 'stages': [{'$cursor': {'executionStats': {'allPlansExecution': [],
                                            'executionStages': {'advanced': 763,
                                                                'executionTimeMillisEstimate': 24,
                                                                'inputStage': {'advanced': 763,
                                                                               'direction': 'forward',
                                                                               'docsExamined': 43581,
                                                                               'executionTimeMillisEstimate': 19,
                                                                               'filter': {'$and': [{'finishTime': {'$lte': datetime.datetime(2021, 11, 10, 22, 0)}},
                                                                                                   {'finishTime': {'$gte': datetime.datetime(2021, 11, 9, 22, 0)}}]},
                                                                               'isEOF': 1,
                                                                               'nReturned': 763,
                                                                               'needTime': 42819,
                                                                               'needYield': 0,
                                                                               'restoreState': 44,
                                                                               'saveState': 44,
                                                                               'stage': 'COLLSCAN',
                                                                               'works': 43583},
                                                                'isEOF': 1,
                                                                'nReturned': 763,
                                                                'needTime': 42819,
                                                                'needYield': 0,
                                                                'restoreState': 44,
                                                                'saveState': 44,
                                                                'stage': 'PROJECTION_SIMPLE',
                                                                'transformBy': {'_id': True,
                                                                                'finishTime': True,
                                                                                'startTime': True,
                                                                                'taskId': True,
                                                                                'userId': True},
                                                                'works': 43583},
                                            'executionSuccess': True,
                                            'executionTimeMillis': 262,
                                            'nReturned': 763,
                                            'totalDocsExamined': 43581,
                                            'totalKeysExamined': 0},
                         'queryPlanner': {'indexFilterSet': False,
                                          'namespace': 'hubble.tasks_processing_time',
                                          'parsedQuery': {'$and': [{'finishTime': {'$lte': datetime.datetime(2021, 11, 10, 22, 0)}},
                                                                   {'finishTime': {'$gte': datetime.datetime(2021, 11, 9, 22, 0)}}]},
                                          'planCacheKey': 'DF88F3E9',
                                          'plannerVersion': 1,
                                          'queryHash': 'DF88F3E9',
                                          'rejectedPlans': [],
                                          'winningPlan': {'inputStage': {'direction': 'forward',
                                                                         'filter': {'$and': [{'finishTime': {'$lte': datetime.datetime(2021, 11, 10, 22, 0)}},
                                                                                             {'finishTime': {'$gte': datetime.datetime(2021, 11, 9, 22, 0)}}]},
                                                                         'stage': 'COLLSCAN'},
                                                          'stage': 'PROJECTION_SIMPLE',
                                                          'transformBy': {'_id': True,
                                                                          'finishTime': True,
                                                                          'startTime': True,
                                                                          'taskId': True,
                                                                          'userId': True}}}},
             'executionTimeMillisEstimate': 73,
             'nReturned': 763},
            {'$match': {'tasks': {'$not': {'$eq': []}}},
             'executionTimeMillisEstimate': 73,
             'nReturned': 763},
            {'$lookup': {'as': 'tasks_moderated',
                         'from': 'tasks_moderated',
                         'let': {'taskId': '$taskId', 'userId': '$userId'},
                         'pipeline': [{'$match': {'$expr': {'$and': [{'$eq': ['$taskId',
                                                                              '$$taskId']},
                                                                     {'$eq': ['$userId',
                                                                              '$$userId']}]}}}]},
             'executionTimeMillisEstimate': 259,
             'nReturned': 763}]}
GETTING TASKS PROCESSING TIME took ->  0.273975133895874