Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db.listings.count({
- dated: {
- $in: [ISODate("2018-02-17T00:00:00Z"), ISODate("2018-02-16T00:00:00Z"),ISODate("2018-02-10T00:00:00Z")]
- },
- causelist_type: {$ne: -1}
- })
- {
- "plannerVersion" : 1,
- "namespace" : "provakil.listings",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "dated" : {
- "$in" : [
- ISODate("2018-02-10T00:00:00Z"),
- ISODate("2018-02-16T00:00:00Z"),
- ISODate("2018-02-17T00:00:00Z")
- ]
- }
- },
- {
- "$nor" : [{
- "causelist_type" : {
- "$eq" : -1
- }
- }]
- }
- ]
- },
- "winningPlan" : {
- "stage" : "FETCH",
- "filter" : {
- "$nor" : [{
- "causelist_type" : {
- "$eq" : -1
- }
- }]
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "dated" : 1
- },
- "indexName" : "dated_1",
- "isMultiKey" : false,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "dated" : [
- "[new Date(1518220800000), new Date(1518220800000)]",
- "[new Date(1518739200000), new Date(1518739200000)]",
- "[new Date(1518825600000), new Date(1518825600000)]"
- ]
- }
- }
- },
- "rejectedPlans" : [{
- "stage" : "FETCH",
- "filter" : {
- "dated" : {
- "$in" : [
- ISODate("2018-02-10T00:00:00Z"),
- ISODate("2018-02-16T00:00:00Z"),
- ISODate("2018-02-17T00:00:00Z")
- ]
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "causelist_type" : 1
- },
- "indexName" : "causelist_type_1",
- "isMultiKey" : false,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "causelist_type" : [
- "[MinKey, -1.0)",
- "(-1.0, MaxKey]"
- ]
- }
- }
- }]
- }
- {
- "plannerVersion" : 1,
- "namespace" : "provakil.listings",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "dated" : {
- "$in" : [
- ISODate("2018-02-10T00:00:00Z"),
- ISODate("2018-02-16T00:00:00Z"),
- ISODate("2018-02-17T00:00:00Z")
- ]
- }
- },
- "winningPlan" : {
- "stage" : "COUNT",
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "dated" : 1
- },
- "indexName" : "dated_1",
- "isMultiKey" : false,
- "isUnique" : false,
- "isSparse" : false,
- "isPartial" : false,
- "indexVersion" : 1,
- "direction" : "forward",
- "indexBounds" : {
- "dated" : [
- "[new Date(1518220800000), new Date(1518220800000)]",
- "[new Date(1518739200000), new Date(1518739200000)]",
- "[new Date(1518825600000), new Date(1518825600000)]"
- ]
- }
- }
- },
- "rejectedPlans" : [ ]
- }
Add Comment
Please, Sign In to add comment