Monday 8 February 2016

Mongo DB Best Practices from recent usage - .explain()

Some practical tips from recent usage - .explain()

dt1_1_EXPLAIN = db.col1.find({"created_at": {"$gte":dt1_1 , "$lt": dt1_2}}).explain()
    print " Tweets Slot -1 :",dt1_1_EXPLAIN
    print #

 Tweets Slot -1 : {u'executionStats': {u'executionTimeMillis': 219, u'nReturned': 334, u'totalKeysExamined': 0, u'allPlansExecution': [], u'executionSuccess': True, u'executionStages': {u'needYield': 0, u'direction': u'forward', u'saveState': 47, u'restoreState': 47, u'isEOF': 1, u'docsExamined': 6015, u'nReturned': 334, u'needTime': 5682, u'filter': {u'$and': [{u'created_at': {u'$lt': datetime.datetime(2016, 2, 1, 6, 0)}}, {u'created_at': {u'$gte': datetime.datetime(2016, 2, 1, 1, 0)}}]}, u'executionTimeMillisEstimate': 0, u'invalidates': 0, u'works': 6017, u'advanced': 334, u'stage': u'COLLSCAN'}, u'totalDocsExamined': 6015}, u'queryPlanner': {u'parsedQuery': {u'$and': [{u'created_at': {u'$lt': datetime.datetime(2016, 2, 1, 6, 0)}}, {u'created_at': {u'$gte': datetime.datetime(2016, 2, 1, 1, 0)}}]}, u'rejectedPlans': [], u'namespace': u'db1.col1', u'winningPlan': {u'filter': {u'$and': [{u'created_at': {u'$lt': datetime.datetime(2016, 2, 1, 6, 0)}}, {u'created_at': {u'$gte': datetime.datetime(2016, 2, 1, 1, 0)}}]}, u'direction': u'forward', u'stage': u'COLLSCAN'}, u'indexFilterSet': False, u'plannerVersion': 1}, u'ok': 1.0, u'serverInfo': {u'host': u'Rohit-VAIO', u'version': u'3.2.1', u'port': 27017, u'gitVersion': u'a14d55980c2cdc565d4704a7e3ad37e4e535c1b2'}}


No comments:

Post a Comment