Skip to content

Instantly share code, notes, and snippets.

@mattcollier

mattcollier/README.md Secret

Last active January 5, 2020 23:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattcollier/1ad440b669e365957dd3dc7f4a392134 to your computer and use it in GitHub Desktop.
Save mattcollier/1ad440b669e365957dd3dc7f4a392134 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
README.md

There is a partial {'meta.continuity2017.type': 'm'} compound index:

  • meta.continuity2017.type
  • meta.continuity2017.creator
  • meta.continuity2017.generation
  • meta.consensus
  • meta.eventHash

The covered query version completes in approx 30ms.

The aggregate completes in around 500ms.

Raw
aggregate_terrible.js
let z = await collection.aggregate([
{"$match": {"meta.continuity2017.type": "m"}},
{"$group": {
"_id": "$meta.continuity2017.creator",
"maxGeneration": {"$max": "$meta.continuity2017.generation"}
}},
]).toArray();
Raw
covered.js
let creators = await collection.distinct(
'meta.continuity2017.creator', {'meta.continuity2017.type': 'm'});
// creators = ['a', 'b'];
let z = await Promise.all(creators.map(async c => collection.find(
{
'meta.continuity2017.creator': c,
'meta.continuity2017.type': 'm'
})
.project({
_id: 0,
'meta.continuity2017.generation': 1,
'meta.continuity2017.creator': 1,
})
.sort({'meta.continuity2017.generation': -1})
.limit(1)
.toArray()
// .explain('executionStats')
));
Raw
explain_covered.json
[
{
"queryPlanner": {
"plannerVersion": 1,
"namespace": "bedrock_ledger_continuity_test.23e69dea-2a28-4022-aaf6-ecfdb63d61b9-event",
"indexFilterSet": false,
"parsedQuery": {
"$and": [
{
"meta.continuity2017.creator": {
"$eq": "https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkii2JiMVK61m3hZc4bX48dRkfjjZ8Q3gCQ8mC69WikGZu"
}
},
{
"meta.continuity2017.type": {
"$eq": "m"
}
}
]
},
"winningPlan": {
"stage": "LIMIT",
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkii2JiMVK61m3hZc4bX48dRkfjjZ8Q3gCQ8mC69WikGZu\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkii2JiMVK61m3hZc4bX48dRkfjjZ8Q3gCQ8mC69WikGZu\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
}
}
}
},
"rejectedPlans": []
},
"executionStats": {
"executionSuccess": true,
"nReturned": 1,
"executionTimeMillis": 0,
"totalKeysExamined": 1,
"totalDocsExamined": 0,
"executionStages": {
"stage": "LIMIT",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 2,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 1,
"invalidates": 0,
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkii2JiMVK61m3hZc4bX48dRkfjjZ8Q3gCQ8mC69WikGZu\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkii2JiMVK61m3hZc4bX48dRkfjjZ8Q3gCQ8mC69WikGZu\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
},
"keysExamined": 1,
"seeks": 1,
"dupsTested": 0,
"dupsDropped": 0,
"seenInvalidated": 0
}
}
},
"allPlansExecution": []
},
"serverInfo": {
"host": "108e074af976",
"port": 27017,
"version": "4.0.13",
"gitVersion": "bda366f0b0e432ca143bc41da54d8732bd8d03c0"
},
"ok": 1
},
{
"queryPlanner": {
"plannerVersion": 1,
"namespace": "bedrock_ledger_continuity_test.23e69dea-2a28-4022-aaf6-ecfdb63d61b9-event",
"indexFilterSet": false,
"parsedQuery": {
"$and": [
{
"meta.continuity2017.creator": {
"$eq": "https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MktB4x8t2wfmaEjgr2nUbERNgoa1SzMhVXwcUULhMYVGxs"
}
},
{
"meta.continuity2017.type": {
"$eq": "m"
}
}
]
},
"winningPlan": {
"stage": "LIMIT",
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MktB4x8t2wfmaEjgr2nUbERNgoa1SzMhVXwcUULhMYVGxs\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MktB4x8t2wfmaEjgr2nUbERNgoa1SzMhVXwcUULhMYVGxs\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
}
}
}
},
"rejectedPlans": []
},
"executionStats": {
"executionSuccess": true,
"nReturned": 1,
"executionTimeMillis": 0,
"totalKeysExamined": 1,
"totalDocsExamined": 0,
"executionStages": {
"stage": "LIMIT",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 2,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 1,
"invalidates": 0,
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MktB4x8t2wfmaEjgr2nUbERNgoa1SzMhVXwcUULhMYVGxs\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MktB4x8t2wfmaEjgr2nUbERNgoa1SzMhVXwcUULhMYVGxs\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
},
"keysExamined": 1,
"seeks": 1,
"dupsTested": 0,
"dupsDropped": 0,
"seenInvalidated": 0
}
}
},
"allPlansExecution": []
},
"serverInfo": {
"host": "108e074af976",
"port": 27017,
"version": "4.0.13",
"gitVersion": "bda366f0b0e432ca143bc41da54d8732bd8d03c0"
},
"ok": 1
},
{
"queryPlanner": {
"plannerVersion": 1,
"namespace": "bedrock_ledger_continuity_test.23e69dea-2a28-4022-aaf6-ecfdb63d61b9-event",
"indexFilterSet": false,
"parsedQuery": {
"$and": [
{
"meta.continuity2017.creator": {
"$eq": "https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkw3PA7LEHxGUJbMyMWA5oma9bkKJ7rFxrebwjqXgwuDEk"
}
},
{
"meta.continuity2017.type": {
"$eq": "m"
}
}
]
},
"winningPlan": {
"stage": "LIMIT",
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkw3PA7LEHxGUJbMyMWA5oma9bkKJ7rFxrebwjqXgwuDEk\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkw3PA7LEHxGUJbMyMWA5oma9bkKJ7rFxrebwjqXgwuDEk\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
}
}
}
},
"rejectedPlans": []
},
"executionStats": {
"executionSuccess": true,
"nReturned": 1,
"executionTimeMillis": 0,
"totalKeysExamined": 1,
"totalDocsExamined": 0,
"executionStages": {
"stage": "LIMIT",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 2,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 1,
"invalidates": 0,
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkw3PA7LEHxGUJbMyMWA5oma9bkKJ7rFxrebwjqXgwuDEk\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkw3PA7LEHxGUJbMyMWA5oma9bkKJ7rFxrebwjqXgwuDEk\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
},
"keysExamined": 1,
"seeks": 1,
"dupsTested": 0,
"dupsDropped": 0,
"seenInvalidated": 0
}
}
},
"allPlansExecution": []
},
"serverInfo": {
"host": "108e074af976",
"port": 27017,
"version": "4.0.13",
"gitVersion": "bda366f0b0e432ca143bc41da54d8732bd8d03c0"
},
"ok": 1
},
{
"queryPlanner": {
"plannerVersion": 1,
"namespace": "bedrock_ledger_continuity_test.23e69dea-2a28-4022-aaf6-ecfdb63d61b9-event",
"indexFilterSet": false,
"parsedQuery": {
"$and": [
{
"meta.continuity2017.creator": {
"$eq": "https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwYShZNYbEAiqouCkRBZepPXYNa3okhLZwXdScBUNWpzt"
}
},
{
"meta.continuity2017.type": {
"$eq": "m"
}
}
]
},
"winningPlan": {
"stage": "LIMIT",
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwYShZNYbEAiqouCkRBZepPXYNa3okhLZwXdScBUNWpzt\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwYShZNYbEAiqouCkRBZepPXYNa3okhLZwXdScBUNWpzt\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
}
}
}
},
"rejectedPlans": []
},
"executionStats": {
"executionSuccess": true,
"nReturned": 1,
"executionTimeMillis": 0,
"totalKeysExamined": 1,
"totalDocsExamined": 0,
"executionStages": {
"stage": "LIMIT",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 2,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 1,
"invalidates": 0,
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwYShZNYbEAiqouCkRBZepPXYNa3okhLZwXdScBUNWpzt\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwYShZNYbEAiqouCkRBZepPXYNa3okhLZwXdScBUNWpzt\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
},
"keysExamined": 1,
"seeks": 1,
"dupsTested": 0,
"dupsDropped": 0,
"seenInvalidated": 0
}
}
},
"allPlansExecution": []
},
"serverInfo": {
"host": "108e074af976",
"port": 27017,
"version": "4.0.13",
"gitVersion": "bda366f0b0e432ca143bc41da54d8732bd8d03c0"
},
"ok": 1
},
{
"queryPlanner": {
"plannerVersion": 1,
"namespace": "bedrock_ledger_continuity_test.23e69dea-2a28-4022-aaf6-ecfdb63d61b9-event",
"indexFilterSet": false,
"parsedQuery": {
"$and": [
{
"meta.continuity2017.creator": {
"$eq": "https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkwaqiarx6nknLJJBkUpkvnFW7L4KWctTH12dq2eXfeGaT"
}
},
{
"meta.continuity2017.type": {
"$eq": "m"
}
}
]
},
"winningPlan": {
"stage": "LIMIT",
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkwaqiarx6nknLJJBkUpkvnFW7L4KWctTH12dq2eXfeGaT\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkwaqiarx6nknLJJBkUpkvnFW7L4KWctTH12dq2eXfeGaT\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
}
}
}
},
"rejectedPlans": []
},
"executionStats": {
"executionSuccess": true,
"nReturned": 1,
"executionTimeMillis": 0,
"totalKeysExamined": 1,
"totalDocsExamined": 0,
"executionStages": {
"stage": "LIMIT",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 2,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 1,
"invalidates": 0,
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkwaqiarx6nknLJJBkUpkvnFW7L4KWctTH12dq2eXfeGaT\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6Mkwaqiarx6nknLJJBkUpkvnFW7L4KWctTH12dq2eXfeGaT\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
},
"keysExamined": 1,
"seeks": 1,
"dupsTested": 0,
"dupsDropped": 0,
"seenInvalidated": 0
}
}
},
"allPlansExecution": []
},
"serverInfo": {
"host": "108e074af976",
"port": 27017,
"version": "4.0.13",
"gitVersion": "bda366f0b0e432ca143bc41da54d8732bd8d03c0"
},
"ok": 1
},
{
"queryPlanner": {
"plannerVersion": 1,
"namespace": "bedrock_ledger_continuity_test.23e69dea-2a28-4022-aaf6-ecfdb63d61b9-event",
"indexFilterSet": false,
"parsedQuery": {
"$and": [
{
"meta.continuity2017.creator": {
"$eq": "https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwfEAk2NDYhzJzbrZab1LPc81wpNYzHDRDV1TdZb3smWM"
}
},
{
"meta.continuity2017.type": {
"$eq": "m"
}
}
]
},
"winningPlan": {
"stage": "LIMIT",
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwfEAk2NDYhzJzbrZab1LPc81wpNYzHDRDV1TdZb3smWM\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwfEAk2NDYhzJzbrZab1LPc81wpNYzHDRDV1TdZb3smWM\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
}
}
}
},
"rejectedPlans": []
},
"executionStats": {
"executionSuccess": true,
"nReturned": 1,
"executionTimeMillis": 0,
"totalKeysExamined": 1,
"totalDocsExamined": 0,
"executionStages": {
"stage": "LIMIT",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 2,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 1,
"invalidates": 0,
"limitAmount": 1,
"inputStage": {
"stage": "PROJECTION",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"transformBy": {
"_id": 0,
"meta.continuity2017.generation": 1,
"meta.continuity2017.creator": 1
},
"inputStage": {
"stage": "IXSCAN",
"nReturned": 1,
"executionTimeMillisEstimate": 0,
"works": 1,
"advanced": 1,
"needTime": 0,
"needYield": 0,
"saveState": 0,
"restoreState": 0,
"isEOF": 0,
"invalidates": 0,
"keyPattern": {
"meta.continuity2017.type": 1,
"meta.continuity2017.creator": 1,
"meta.continuity2017.generation": 1,
"meta.consensus": 1,
"meta.eventHash": 1
},
"indexName": "event.continuity2017.type.1",
"isMultiKey": false,
"multiKeyPaths": {
"meta.continuity2017.type": [],
"meta.continuity2017.creator": [],
"meta.continuity2017.generation": [],
"meta.consensus": [],
"meta.eventHash": []
},
"isUnique": true,
"isSparse": false,
"isPartial": true,
"indexVersion": 2,
"direction": "backward",
"indexBounds": {
"meta.continuity2017.type": [
"[\"m\", \"m\"]"
],
"meta.continuity2017.creator": [
"[\"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwfEAk2NDYhzJzbrZab1LPc81wpNYzHDRDV1TdZb3smWM\", \"https://bedrock.localhost:18443/consensus/continuity2017/voters/z6MkwfEAk2NDYhzJzbrZab1LPc81wpNYzHDRDV1TdZb3smWM\"]"
],
"meta.continuity2017.generation": [
"[MaxKey, MinKey]"
],
"meta.consensus": [
"[MaxKey, MinKey]"
],
"meta.eventHash": [
"[MaxKey, MinKey]"
]
},
"keysExamined": 1,
"seeks": 1,
"dupsTested": 0,
"dupsDropped": 0,
"seenInvalidated": 0
}
}
},
"allPlansExecution": []
},
"serverInfo": {
"host": "108e074af976",
"port": 27017,
"version": "4.0.13",
"gitVersion": "bda366f0b0e432ca143bc41da54d8732bd8d03c0"
},
"ok": 1
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment