Untitled
unknown
json
3 years ago
6.1 kB
3
Indexable
{'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
Editor is loading...