Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "clusteredType" : "ParallelSort",
- "shards" : {
- "production_0/ip-11.domain:27000,ip_2-11.domain:27000" : [
- {
- "queryPlanner" : {
- "plannerVersion" : NumberInt(1),
- "namespace" : "liverpool.playlists",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "isPublic" : {
- "$eq" : true
- }
- },
- {
- "tracks._id" : {
- "$in": ["中略"]
- }
- }
- ]
- },
- "winningPlan" : {
- "stage" : "SHARDING_FILTER",
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- }
- }
- }
- },
- "rejectedPlans" : [
- ]
- },
- "executionStats" : {
- "executionSuccess" : true,
- "nReturned" : NumberInt(7395),
- "executionTimeMillis" : NumberInt(1578),
- "totalKeysExamined" : NumberInt(91353),
- "totalDocsExamined" : NumberInt(91353),
- "executionStages" : {
- "stage" : "SHARDING_FILTER",
- "nReturned" : NumberInt(7395),
- "executionTimeMillisEstimate" : NumberInt(1530),
- "works" : NumberInt(91354),
- "advanced" : NumberInt(7395),
- "needTime" : NumberInt(83958),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(713),
- "restoreState" : NumberInt(713),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "chunkSkips" : NumberInt(0),
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "nReturned" : NumberInt(7395),
- "executionTimeMillisEstimate" : NumberInt(1490),
- "works" : NumberInt(91353),
- "advanced" : NumberInt(7395),
- "needTime" : NumberInt(83958),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(713),
- "restoreState" : NumberInt(713),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "docsExamined" : NumberInt(91353),
- "alreadyHasObj" : NumberInt(0),
- "inputStage" : {
- "stage" : "IXSCAN",
- "nReturned" : NumberInt(91353),
- "executionTimeMillisEstimate" : NumberInt(120),
- "works" : NumberInt(91353),
- "advanced" : NumberInt(91353),
- "needTime" : NumberInt(0),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(713),
- "restoreState" : NumberInt(713),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- },
- "keysExamined" : NumberInt(91353),
- "dupsTested" : NumberInt(0),
- "dupsDropped" : NumberInt(0),
- "seenInvalidated" : NumberInt(0),
- "matchTested" : NumberInt(0)
- }
- }
- },
- "allPlansExecution" : [
- ]
- },
- "serverInfo" : {
- "host" : "ip-11",
- "port" : NumberInt(27000),
- "version" : "3.0.11",
- "gitVersion" : "48f8b49dc30cc2485c6c1f3db31b723258fcbf39"
- }
- }
- ],
- "production_1/ip-12.domain:27000,ip_2-12.domain:27000" : [
- {
- "queryPlanner" : {
- "plannerVersion" : NumberInt(1),
- "namespace" : "liverpool.playlists",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "isPublic" : {
- "$eq" : true
- }
- },
- {
- "tracks._id" : {
- "$in": ["中略"]
- }
- }
- ]
- },
- "winningPlan" : {
- "stage" : "SHARDING_FILTER",
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- }
- }
- }
- },
- "rejectedPlans" : [
- ]
- },
- "executionStats" : {
- "executionSuccess" : true,
- "nReturned" : NumberInt(6320),
- "executionTimeMillis" : NumberInt(1290),
- "totalKeysExamined" : NumberInt(80047),
- "totalDocsExamined" : NumberInt(80047),
- "executionStages" : {
- "stage" : "SHARDING_FILTER",
- "nReturned" : NumberInt(6320),
- "executionTimeMillisEstimate" : NumberInt(1250),
- "works" : NumberInt(80048),
- "advanced" : NumberInt(6320),
- "needTime" : NumberInt(73727),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(625),
- "restoreState" : NumberInt(625),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "chunkSkips" : NumberInt(0),
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "nReturned" : NumberInt(6320),
- "executionTimeMillisEstimate" : NumberInt(1240),
- "works" : NumberInt(80047),
- "advanced" : NumberInt(6320),
- "needTime" : NumberInt(73727),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(625),
- "restoreState" : NumberInt(625),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "docsExamined" : NumberInt(80047),
- "alreadyHasObj" : NumberInt(0),
- "inputStage" : {
- "stage" : "IXSCAN",
- "nReturned" : NumberInt(80047),
- "executionTimeMillisEstimate" : NumberInt(40),
- "works" : NumberInt(80047),
- "advanced" : NumberInt(80047),
- "needTime" : NumberInt(0),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(625),
- "restoreState" : NumberInt(625),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- },
- "keysExamined" : NumberInt(80047),
- "dupsTested" : NumberInt(0),
- "dupsDropped" : NumberInt(0),
- "seenInvalidated" : NumberInt(0),
- "matchTested" : NumberInt(0)
- }
- }
- },
- "allPlansExecution" : [
- ]
- },
- "serverInfo" : {
- "host" : "ip-12",
- "port" : NumberInt(27000),
- "version" : "3.0.11",
- "gitVersion" : "48f8b49dc30cc2485c6c1f3db31b723258fcbf39"
- }
- }
- ],
- "production_2/ip-13.domain:27000,ip_2-13.domain:27000" : [
- {
- "queryPlanner" : {
- "plannerVersion" : NumberInt(1),
- "namespace" : "liverpool.playlists",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "isPublic" : {
- "$eq" : true
- }
- },
- {
- "tracks._id" : {
- "$in": ["中略"]
- }
- }
- ]
- },
- "winningPlan" : {
- "stage" : "SHARDING_FILTER",
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- }
- }
- }
- },
- "rejectedPlans" : [
- ]
- },
- "executionStats" : {
- "executionSuccess" : true,
- "nReturned" : NumberInt(6473),
- "executionTimeMillis" : NumberInt(1373),
- "totalKeysExamined" : NumberInt(86490),
- "totalDocsExamined" : NumberInt(86490),
- "executionStages" : {
- "stage" : "SHARDING_FILTER",
- "nReturned" : NumberInt(6473),
- "executionTimeMillisEstimate" : NumberInt(1340),
- "works" : NumberInt(86491),
- "advanced" : NumberInt(6473),
- "needTime" : NumberInt(80017),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(675),
- "restoreState" : NumberInt(675),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "chunkSkips" : NumberInt(0),
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "nReturned" : NumberInt(6473),
- "executionTimeMillisEstimate" : NumberInt(1330),
- "works" : NumberInt(86490),
- "advanced" : NumberInt(6473),
- "needTime" : NumberInt(80017),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(675),
- "restoreState" : NumberInt(675),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "docsExamined" : NumberInt(86490),
- "alreadyHasObj" : NumberInt(0),
- "inputStage" : {
- "stage" : "IXSCAN",
- "nReturned" : NumberInt(86490),
- "executionTimeMillisEstimate" : NumberInt(60),
- "works" : NumberInt(86490),
- "advanced" : NumberInt(86490),
- "needTime" : NumberInt(0),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(675),
- "restoreState" : NumberInt(675),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- },
- "keysExamined" : NumberInt(86490),
- "dupsTested" : NumberInt(0),
- "dupsDropped" : NumberInt(0),
- "seenInvalidated" : NumberInt(0),
- "matchTested" : NumberInt(0)
- }
- }
- },
- "allPlansExecution" : [
- ]
- },
- "serverInfo" : {
- "host" : "ip-13",
- "port" : NumberInt(27000),
- "version" : "3.0.11",
- "gitVersion" : "48f8b49dc30cc2485c6c1f3db31b723258fcbf39"
- }
- }
- ],
- "production_3/ip-14.domain:27000,ip_2-14.domain:27000" : [
- {
- "queryPlanner" : {
- "plannerVersion" : NumberInt(1),
- "namespace" : "liverpool.playlists",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "isPublic" : {
- "$eq" : true
- }
- },
- {
- "tracks._id" : {
- "$in": ["中略"]
- }
- }
- ]
- },
- "winningPlan" : {
- "stage" : "SHARDING_FILTER",
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- }
- }
- }
- },
- "rejectedPlans" : [
- ]
- },
- "executionStats" : {
- "executionSuccess" : true,
- "nReturned" : NumberInt(5605),
- "executionTimeMillis" : NumberInt(1200),
- "totalKeysExamined" : NumberInt(69901),
- "totalDocsExamined" : NumberInt(69901),
- "executionStages" : {
- "stage" : "SHARDING_FILTER",
- "nReturned" : NumberInt(5605),
- "executionTimeMillisEstimate" : NumberInt(1120),
- "works" : NumberInt(69902),
- "advanced" : NumberInt(5605),
- "needTime" : NumberInt(64296),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(546),
- "restoreState" : NumberInt(546),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "chunkSkips" : NumberInt(0),
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "nReturned" : NumberInt(5605),
- "executionTimeMillisEstimate" : NumberInt(1110),
- "works" : NumberInt(69901),
- "advanced" : NumberInt(5605),
- "needTime" : NumberInt(64296),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(546),
- "restoreState" : NumberInt(546),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "docsExamined" : NumberInt(69901),
- "alreadyHasObj" : NumberInt(0),
- "inputStage" : {
- "stage" : "IXSCAN",
- "nReturned" : NumberInt(69901),
- "executionTimeMillisEstimate" : NumberInt(50),
- "works" : NumberInt(69901),
- "advanced" : NumberInt(69901),
- "needTime" : NumberInt(0),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(546),
- "restoreState" : NumberInt(546),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- },
- "keysExamined" : NumberInt(69901),
- "dupsTested" : NumberInt(0),
- "dupsDropped" : NumberInt(0),
- "seenInvalidated" : NumberInt(0),
- "matchTested" : NumberInt(0)
- }
- }
- },
- "allPlansExecution" : [
- ]
- },
- "serverInfo" : {
- "host" : "ip-14",
- "port" : NumberInt(27000),
- "version" : "3.0.11",
- "gitVersion" : "48f8b49dc30cc2485c6c1f3db31b723258fcbf39"
- }
- }
- ],
- "production_4/ip-15.domain:27000,ip_2-15.domain:27000" : [
- {
- "queryPlanner" : {
- "plannerVersion" : NumberInt(1),
- "namespace" : "liverpool.playlists",
- "indexFilterSet" : false,
- "parsedQuery" : {
- "$and" : [
- {
- "isPublic" : {
- "$eq" : true
- }
- },
- {
- "tracks._id" : {
- "$in": ["中略"]
- }
- }
- ]
- },
- "winningPlan" : {
- "stage" : "SHARDING_FILTER",
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "inputStage" : {
- "stage" : "IXSCAN",
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- }
- }
- }
- },
- "rejectedPlans" : [
- ]
- },
- "executionStats" : {
- "executionSuccess" : true,
- "nReturned" : NumberInt(6541),
- "executionTimeMillis" : NumberInt(1231),
- "totalKeysExamined" : NumberInt(85076),
- "totalDocsExamined" : NumberInt(85076),
- "executionStages" : {
- "stage" : "SHARDING_FILTER",
- "nReturned" : NumberInt(6541),
- "executionTimeMillisEstimate" : NumberInt(1200),
- "works" : NumberInt(85077),
- "advanced" : NumberInt(6541),
- "needTime" : NumberInt(78535),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(664),
- "restoreState" : NumberInt(664),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "chunkSkips" : NumberInt(0),
- "inputStage" : {
- "stage" : "FETCH",
- "filter" : {
- "tracks._id" : {
- "$in": ["中略"]
- }
- },
- "nReturned" : NumberInt(6541),
- "executionTimeMillisEstimate" : NumberInt(1190),
- "works" : NumberInt(85076),
- "advanced" : NumberInt(6541),
- "needTime" : NumberInt(78535),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(664),
- "restoreState" : NumberInt(664),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "docsExamined" : NumberInt(85076),
- "alreadyHasObj" : NumberInt(0),
- "inputStage" : {
- "stage" : "IXSCAN",
- "nReturned" : NumberInt(85076),
- "executionTimeMillisEstimate" : NumberInt(100),
- "works" : NumberInt(85076),
- "advanced" : NumberInt(85076),
- "needTime" : NumberInt(0),
- "needFetch" : NumberInt(0),
- "saveState" : NumberInt(664),
- "restoreState" : NumberInt(664),
- "isEOF" : NumberInt(1),
- "invalidates" : NumberInt(0),
- "keyPattern" : {
- "isPublic" : 1.0,
- "active" : 1.0,
- "updatedAt" : -1.0
- },
- "indexName" : "isPublic_1_active_1_updatedAt_-1",
- "isMultiKey" : false,
- "direction" : "forward",
- "indexBounds" : {
- "isPublic" : [
- "[true, true]"
- ],
- "active" : [
- "[MinKey, MaxKey]"
- ],
- "updatedAt" : [
- "[MaxKey, MinKey]"
- ]
- },
- "keysExamined" : NumberInt(85076),
- "dupsTested" : NumberInt(0),
- "dupsDropped" : NumberInt(0),
- "seenInvalidated" : NumberInt(0),
- "matchTested" : NumberInt(0)
- }
- }
- },
- "allPlansExecution" : [
- ]
- },
- "serverInfo" : {
- "host" : "ip-15",
- "port" : NumberInt(27000),
- "version" : "3.0.11",
- "gitVersion" : "48f8b49dc30cc2485c6c1f3db31b723258fcbf39"
- }
- }
- ]
- },
- "n" : NumberInt(32334),
- "nscanned" : NumberInt(412867),
- "nscannedObjects" : NumberInt(412867),
- "millisShardTotal" : NumberInt(6672),
- "millisShardAvg" : NumberInt(1334),
- "numQueries" : NumberInt(5),
- "numShards" : NumberInt(5),
- "executionTimeMillis" : NumberInt(1609)
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement