Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('56541658551adb1dfc0053ee')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>2,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>4,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541658551adb1dfc0053ee'), ObjectId('56541658551adb1dfc0053ee')]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('5654142b551adb1dfc000760')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>2,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>4,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654142b551adb1dfc000760'), ObjectId('5654142b551adb1dfc000760')]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('5654150b551adb1dfc002862')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>0,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>2,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('5654150b551adb1dfc002862'), ObjectId('5654150b551adb1dfc002862')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('56541696551adb1dfc005cda')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>2,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>4,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>2,
- "totalDocsExamined"=>2,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>2,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>2,
- "executionTimeMillisEstimate"=>0,
- "works"=>3,
- "advanced"=>2,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cda'), ObjectId('56541696551adb1dfc005cda')]"]},
- "keysExamined"=>2,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('56541696551adb1dfc005cf0')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>0,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>2,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541696551adb1dfc005cf0'), ObjectId('56541696551adb1dfc005cf0')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('56541546551adb1dfc0030b4')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>0,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>2,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541546551adb1dfc0030b4'), ObjectId('56541546551adb1dfc0030b4')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('565416d6551adb1dfc00659d')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>0,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>2,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416d6551adb1dfc00659d'), ObjectId('565416d6551adb1dfc00659d')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('565416e2551adb1dfc006781')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>0,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>2,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565416e2551adb1dfc006781'), ObjectId('565416e2551adb1dfc006781')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('565414c5551adb1dfc001d20')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>0,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>2,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('565414c5551adb1dfc001d20'), ObjectId('565414c5551adb1dfc001d20')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
- {"queryPlanner"=>
- {"plannerVersion"=>1,
- "namespace"=>"mongoid_flioz_backend_development.daily_data",
- "indexFilterSet"=>false,
- "parsedQuery"=>
- {"stock_id"=>{"$eq"=>BSON::ObjectId('56541578551adb1dfc003838')}},
- "winningPlan"=>
- {"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"]}}},
- "rejectedPlans"=>
- [{"stage"=>"FETCH",
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"],
- "datetime"=>["[MinKey, MaxKey]"]}}}]},
- "executionStats"=>
- {"executionSuccess"=>true,
- "nReturned"=>0,
- "executionTimeMillis"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>2,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}},
- "allPlansExecution"=>
- [{"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1, "datetime"=>1},
- "indexName"=>"stock_id_1_datetime_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"],
- "datetime"=>["[MinKey, MaxKey]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}},
- {"nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "totalKeysExamined"=>0,
- "totalDocsExamined"=>0,
- "executionStages"=>
- {"stage"=>"FETCH",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "docsExamined"=>0,
- "alreadyHasObj"=>0,
- "inputStage"=>
- {"stage"=>"IXSCAN",
- "nReturned"=>0,
- "executionTimeMillisEstimate"=>0,
- "works"=>1,
- "advanced"=>0,
- "needTime"=>0,
- "needFetch"=>0,
- "saveState"=>0,
- "restoreState"=>0,
- "isEOF"=>1,
- "invalidates"=>0,
- "keyPattern"=>{"stock_id"=>1},
- "indexName"=>"stock_id_1",
- "isMultiKey"=>false,
- "direction"=>"forward",
- "indexBounds"=>
- {"stock_id"=>
- ["[ObjectId('56541578551adb1dfc003838'), ObjectId('56541578551adb1dfc003838')]"]},
- "keysExamined"=>0,
- "dupsTested"=>0,
- "dupsDropped"=>0,
- "seenInvalidated"=>0,
- "matchTested"=>0}}}]},
- "serverInfo"=>
- {"host"=>"Jegan.local",
- "port"=>27017,
- "version"=>"3.0.7",
- "gitVersion"=>"nogitversion"}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement