mongo-query-log

gistfile1.js

> db.tasks.find({"deleted_at" : null, "worker_id": ObjectId("52fb3ee0863a995e8d004bac"), "completed_at":{"$gte":ISODate("2014-04-11 00:00:00.000Z"), "$lte":ISODate("2014-07-13 23:59:59.999Z")}, "status":"completed"}).hint({deleted_at: 1, worker_id: 1, completed_at: 1, status: 1}).explain()

{
  "cursor" : "BtreeCursor deleted_at_1_worker_id_1_completed_at_1_status_1",
  "isMultiKey" : false,
  "n" : 5035,
  "nscannedObjects" : 5035,
  "nscanned" : 6228,
  "nscannedObjectsAllPlans" : 5035,
  "nscannedAllPlans" : 6228,
  "scanAndOrder" : false,
  "indexOnly" : false,
  "nYields" : 0,
  "nChunkSkips" : 0,
  "millis" : 40,
  "indexBounds" : {
    "deleted_at" : [
      [
        null,
        null
      ]
    ],
    "worker_id" : [
      [
        ObjectId("52fb3ee0863a995e8d004bac"),
        ObjectId("52fb3ee0863a995e8d004bac")
      ]
    ],
    "completed_at" : [
      [
        ISODate("2014-04-11T00:00:00Z"),
        ISODate("2014-07-13T23:59:59.999Z")
      ]
    ],
    "status" : [
      [
        "completed",
        "completed"
      ]
    ]
  },
  "server" : "wp-prod-mongo2:27017"
}

> db.tasks.find({"deleted_at" : null, "worker_id": ObjectId("52fb3ee0863a995e8d004bac"), "completed_at":{"$gte":ISODate("2014-04-11 00:00:00.000Z"), "$lte":ISODate("2014-07-13 23:59:59.999Z")}, "status":"completed"}).explain()
{
  "cursor" : "BtreeCursor deleted_at_1_worker_id_1_status_1",
  "isMultiKey" : false,
  "n" : 5035,
  "nscannedObjects" : 7381,
  "nscanned" : 7381,
  "nscannedObjectsAllPlans" : 7684,
  "nscannedAllPlans" : 7684,
  "scanAndOrder" : false,
  "indexOnly" : false,
  "nYields" : 0,
  "nChunkSkips" : 0,
  "millis" : 61,
  "indexBounds" : {
    "deleted_at" : [
      [
        null,
        null
      ]
    ],
    "worker_id" : [
      [
        ObjectId("52fb3ee0863a995e8d004bac"),
        ObjectId("52fb3ee0863a995e8d004bac")
      ]
    ],
    "status" : [
      [
        "completed",
        "completed"
      ]
    ]
  },
  "server" : "wp-prod-mongo2:27017"
}