Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2014
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. > db.tf.find( { "transforms.header.stamp": { $lt: new Date(1396512603500), $gte: new Date(1396512602000) } } ).explain()
  2. {
  3. "cursor" : "BtreeCursor transforms.header.stamp_1",
  4. "isMultiKey" : false,
  5. "n" : 49,
  6. "nscannedObjects" : 49,
  7. "nscanned" : 49,
  8. ....
  9. "millis" : 3,
  10. "indexBounds" : {
  11. "transforms.header.stamp" : [
  12. [
  13. ISODate("2014-04-03T08:10:02Z"),
  14. ISODate("2014-04-03T08:10:03.500Z")
  15. ]
  16. ]
  17. }
  18. ....
  19. }
  20.  
  21. > db.tf.find( { "transforms.header.stamp": { $lt: new Date(1396512603500), $gte: new Date(1396512602000) } } ).explain()
  22. {
  23. "cursor" : "BtreeCursor transforms.header.stamp_1",
  24. "isMultiKey" : true,
  25. "n" : 49,
  26. "nscannedObjects" : 20489,
  27. "nscanned" : 20489,
  28. ....
  29. "millis" : 645,
  30. "indexBounds" : {
  31. "transforms.header.stamp" : [
  32. [
  33. true,
  34. ISODate("2014-04-03T08:10:03.500Z")
  35. ]
  36. ]
  37. }
  38. ....
  39. }
  40.  
  41. > db.tf.find( { "transforms.header.stamp": { $type: 4 } } ).count()
  42. 0
  43.  
  44. > db.tf.find( { "transforms.header.stamp": { $type: 9 } } ).count()
  45. 554672
  46.  
  47. > db.tf.find( { "transforms.header.stamp": { $type: 17 } } ).count()
  48. Mon Dec 22 11:53:19 uncaught exception: count failed: {
  49. "code" : 13111,
  50. "ok" : 0,
  51. "errmsg" : "13111 wrong type for field () 17 != 9"
  52. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement