Created
November 20, 2025 10:06
-
-
Save saurabh2590/fee14b04aba76102559401f92345cafa to your computer and use it in GitHub Desktop.
Atlas Index Recommendation Response
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "clusterId": null, | |
| "collectedIndexes": [ | |
| { | |
| "accessCount": 219, | |
| "index": [ | |
| { | |
| "user_id": 1 | |
| }, | |
| { | |
| "reporting_content_id": 1 | |
| }, | |
| { | |
| "timestamp": 1 | |
| } | |
| ], | |
| "name": "user_id_1_reporting_content_id_1_timestamp_1", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "shards": null, | |
| "since": "2025-11-20T08:57:24Z", | |
| "sizeBytes": 67235840 | |
| }, | |
| { | |
| "accessCount": 0, | |
| "index": [ | |
| { | |
| "event_type": 1 | |
| }, | |
| { | |
| "timestamp": 1 | |
| } | |
| ], | |
| "name": "event_type_1_timestamp_1", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "shards": null, | |
| "since": "2025-11-20T08:57:24Z", | |
| "sizeBytes": 50946048 | |
| }, | |
| { | |
| "accessCount": 7373, | |
| "index": [ | |
| { | |
| "user_id": 1 | |
| }, | |
| { | |
| "event_type": 1 | |
| }, | |
| { | |
| "timestamp": 1 | |
| } | |
| ], | |
| "name": "user_id_1_event_type_1_timestamp_1", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "shards": null, | |
| "since": "2025-11-20T08:57:24Z", | |
| "sizeBytes": 71516160 | |
| }, | |
| { | |
| "accessCount": 2107, | |
| "index": [ | |
| { | |
| "group_id": 1 | |
| }, | |
| { | |
| "event_type": 1 | |
| }, | |
| { | |
| "timestamp": 1 | |
| } | |
| ], | |
| "name": "group_id_1_event_type_1_timestamp_1", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "shards": null, | |
| "since": "2025-11-20T08:57:24Z", | |
| "sizeBytes": 55500800 | |
| }, | |
| { | |
| "accessCount": 813, | |
| "index": [ | |
| { | |
| "user_id": 1 | |
| }, | |
| { | |
| "series_id": 1 | |
| }, | |
| { | |
| "event_type": 1 | |
| }, | |
| { | |
| "timestamp": 1 | |
| } | |
| ], | |
| "name": "user_id_1_series_id_1_event_type_1_timestamp_1", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "shards": null, | |
| "since": "2025-11-20T08:57:24Z", | |
| "sizeBytes": 21065728 | |
| }, | |
| { | |
| "accessCount": 2, | |
| "index": [ | |
| { | |
| "unique_key": 1 | |
| }, | |
| { | |
| "event_type": 1 | |
| } | |
| ], | |
| "name": "unique_key_1_event_type_1", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "shards": null, | |
| "since": "2025-11-20T08:57:24Z", | |
| "sizeBytes": 1630208 | |
| }, | |
| { | |
| "accessCount": 6, | |
| "index": [ | |
| { | |
| "_id": 1 | |
| } | |
| ], | |
| "name": "_id_", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "shards": null, | |
| "since": "2025-11-20T08:57:24Z", | |
| "sizeBytes": 67518464 | |
| } | |
| ], | |
| "dismissedRecommendations": null, | |
| "feedback": [], | |
| "metadata": { | |
| "reachedMaxLogLineSize": {}, | |
| "reachedMaxLogLines": {} | |
| }, | |
| "namespaces": [ | |
| "backend.event_AT_bettermarks" | |
| ], | |
| "replSetId": "64a522cb0bf6250985b3f4c0", | |
| "runId": "691ee78c73b2257ec38fab57", | |
| "shapes": [ | |
| { | |
| "avgMs": 59, | |
| "avgNReturned": 0, | |
| "avgNScanned": 1037, | |
| "count": 3, | |
| "fromCountOrDistinct": false, | |
| "id": "691ee78b73b2257ec38fa5b3", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "operations": [ | |
| { | |
| "predicates": [ | |
| { | |
| "aggregate": [ | |
| { | |
| "$match": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": null | |
| } | |
| }, | |
| { | |
| "$count": "count" | |
| } | |
| ] | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:40:09.736+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35555\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"aggregate\":\"event_AT_bettermarks\",\"pipeline\":[{\"$match\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":null}},{\"$count\":\"count\"}],\"cursor\":{},\"maxTimeMS\":5000,\"lsid\":{\"id\":{\"$uuid\":\"01d6bdbe-a712-417a-80e3-e3254c10e661\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566809,\"i\":164}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"yQI3TGTcTY9a5jctu1I3W2VKIqg=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":171,\"keysExamined\":1037,\"docsExamined\":1037,\"cursorExhausted\":true,\"numYields\":5,\"nreturned\":0,\"queryHash\":\"AE96A15E\",\"planCacheKey\":\"0A93922D\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":7}},\"Global\":{\"acquireCount\":{\"r\":7}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"writeConcern\":{\"w\":\"majority\",\"wtimeout\":0,\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":73150559,\"timeReadingMicros\":8773}},\"cpuNanos\":66169682,\"remote\":\"3.122.44.223:55815\",\"protocol\":\"op_msg\",\"durationMillis\":66}}", | |
| "stats": { | |
| "ms": 66, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566809873 | |
| } | |
| }, | |
| { | |
| "predicates": [ | |
| { | |
| "aggregate": [ | |
| { | |
| "$match": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": { | |
| "$numberInt": "1" | |
| } | |
| } | |
| }, | |
| { | |
| "$count": "count" | |
| } | |
| ] | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:36:05.276+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35471\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"aggregate\":\"event_AT_bettermarks\",\"pipeline\":[{\"$match\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":1}},{\"$count\":\"count\"}],\"cursor\":{},\"maxTimeMS\":5000,\"lsid\":{\"id\":{\"$uuid\":\"79524227-731d-4997-9f97-efad8a29b511\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566547,\"i\":35}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"3ry7xMwWNf0wIP7BqrjXsyPKGBI=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":140,\"keysExamined\":1037,\"docsExamined\":1037,\"cursorExhausted\":true,\"numYields\":5,\"nreturned\":1,\"queryHash\":\"AE96A15E\",\"planCacheKey\":\"0A93922D\",\"queryFramework\":\"classic\",\"reslen\":261,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":7}},\"Global\":{\"acquireCount\":{\"r\":7}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"writeConcern\":{\"w\":\"majority\",\"wtimeout\":0,\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":67039888,\"timeReadingMicros\":7412}},\"cpuNanos\":60563609,\"remote\":\"3.122.44.223:63945\",\"protocol\":\"op_msg\",\"durationMillis\":60}}", | |
| "stats": { | |
| "ms": 60, | |
| "nReturned": 1, | |
| "nScanned": 1037, | |
| "ts": 1763566565413 | |
| } | |
| }, | |
| { | |
| "predicates": [ | |
| { | |
| "aggregate": [ | |
| { | |
| "$match": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": null | |
| } | |
| }, | |
| { | |
| "$count": "count" | |
| } | |
| ] | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:39:16.851+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35540\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"aggregate\":\"event_AT_bettermarks\",\"pipeline\":[{\"$match\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":null}},{\"$count\":\"count\"}],\"cursor\":{},\"maxTimeMS\":5000,\"lsid\":{\"id\":{\"$uuid\":\"d6d99d74-2c74-437b-884c-812574e7a2b3\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566756,\"i\":20}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"CGXIrts9dz2m3Wtthkxd6E2/G4k=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":136,\"keysExamined\":1037,\"docsExamined\":1037,\"cursorExhausted\":true,\"numYields\":4,\"nreturned\":0,\"queryHash\":\"AE96A15E\",\"planCacheKey\":\"0A93922D\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":6}},\"Global\":{\"acquireCount\":{\"r\":6}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"writeConcern\":{\"w\":\"majority\",\"wtimeout\":0,\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":56824703,\"timeReadingMicros\":6800}},\"cpuNanos\":52245719,\"remote\":\"3.122.44.223:22957\",\"protocol\":\"op_msg\",\"durationMillis\":52}}", | |
| "stats": { | |
| "ms": 52, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566756988 | |
| } | |
| } | |
| ], | |
| "predicateHashes": [ | |
| "8253145079777675089" | |
| ], | |
| "queryShapeHashes": [], | |
| "queryShapes": [], | |
| "queryTargeting": 1037 | |
| }, | |
| { | |
| "avgMs": 67, | |
| "avgNReturned": 0, | |
| "avgNScanned": 1037, | |
| "count": 2, | |
| "fromCountOrDistinct": false, | |
| "id": "691ee78b73b2257ec38fa5a7", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "operations": [ | |
| { | |
| "predicates": [ | |
| { | |
| "aggregate": [ | |
| { | |
| "$match": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": { | |
| "$eq": null | |
| } | |
| } | |
| }, | |
| { | |
| "$count": "count" | |
| } | |
| ] | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:36:35.565+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35471\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"aggregate\":\"event_AT_bettermarks\",\"pipeline\":[{\"$match\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":{\"$eq\":null}}},{\"$count\":\"count\"}],\"cursor\":{},\"maxTimeMS\":5000,\"lsid\":{\"id\":{\"$uuid\":\"75b82884-412e-4f54-acd5-14f1783df6ff\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566565,\"i\":20}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"bYvNLrRBM3bv6qT6WENYtro6c3w=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":139,\"keysExamined\":1037,\"docsExamined\":1037,\"cursorExhausted\":true,\"numYields\":5,\"nreturned\":0,\"queryHash\":\"AE96A15E\",\"planCacheKey\":\"0A93922D\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":7}},\"Global\":{\"acquireCount\":{\"r\":7}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"writeConcern\":{\"w\":\"majority\",\"wtimeout\":0,\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":46698091,\"timeReadingMicros\":5687}},\"cpuNanos\":45379295,\"remote\":\"3.122.44.223:63945\",\"protocol\":\"op_msg\",\"durationMillis\":70}}", | |
| "stats": { | |
| "ms": 70, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566595702 | |
| } | |
| }, | |
| { | |
| "predicates": [ | |
| { | |
| "find": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": { | |
| "$eq": null | |
| } | |
| } | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:36:35.566+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35474\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"find\":\"event_AT_bettermarks\",\"filter\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":{\"$eq\":null}},\"projection\":{\"_id\":0,\"__doc\":\"$$ROOT\",\"__size\":{\"$bsonSize\":\"$$ROOT\"}},\"skip\":0,\"limit\":100,\"maxTimeMS\":60000,\"lsid\":{\"id\":{\"$uuid\":\"f7d2d2c7-688a-44b7-af4b-46dc2f43e125\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566565,\"i\":20}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"bYvNLrRBM3bv6qT6WENYtro6c3w=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":261,\"keysExamined\":1037,\"docsExamined\":1037,\"nBatches\":1,\"cursorExhausted\":true,\"numYields\":4,\"nreturned\":0,\"queryHash\":\"AE96A15E\",\"planCacheKey\":\"0A93922D\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":5}},\"Global\":{\"acquireCount\":{\"r\":5}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":29256280,\"timeReadingMicros\":3947}},\"cpuNanos\":31426978,\"remote\":\"3.127.55.6:42670\",\"protocol\":\"op_msg\",\"durationMillis\":63}}", | |
| "stats": { | |
| "ms": 63, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566595703 | |
| } | |
| } | |
| ], | |
| "predicateHashes": [ | |
| "7851624768391871818" | |
| ], | |
| "queryShapeHashes": [], | |
| "queryShapes": [], | |
| "queryTargeting": 1037 | |
| }, | |
| { | |
| "avgMs": 38, | |
| "avgNReturned": 0, | |
| "avgNScanned": 1037, | |
| "count": 2, | |
| "fromCountOrDistinct": false, | |
| "id": "691ee78b73b2257ec38fa5b5", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "operations": [ | |
| { | |
| "predicates": [ | |
| { | |
| "aggregate": [ | |
| { | |
| "$match": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": { | |
| "$type": "null" | |
| } | |
| } | |
| }, | |
| { | |
| "$count": "count" | |
| } | |
| ] | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:39:35.647+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35541\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"aggregate\":\"event_AT_bettermarks\",\"pipeline\":[{\"$match\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":{\"$type\":\"null\"}}},{\"$count\":\"count\"}],\"cursor\":{},\"maxTimeMS\":5000,\"lsid\":{\"id\":{\"$uuid\":\"a3ba3f63-710b-488c-8dee-4eb1a348e0b6\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566757,\"i\":35}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"LB6sIsmeLXVolkaAkTRpFw1XGhM=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":173,\"keysExamined\":1037,\"docsExamined\":1037,\"cursorExhausted\":true,\"numYields\":3,\"nreturned\":0,\"queryHash\":\"7B234FFB\",\"planCacheKey\":\"6766F52C\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":5}},\"Global\":{\"acquireCount\":{\"r\":5}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"writeConcern\":{\"w\":\"majority\",\"wtimeout\":0,\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":6194554,\"timeReadingMicros\":591}},\"cpuNanos\":10445340,\"remote\":\"3.122.44.223:49468\",\"protocol\":\"op_msg\",\"durationMillis\":36}}", | |
| "stats": { | |
| "ms": 36, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566775784 | |
| } | |
| }, | |
| { | |
| "predicates": [ | |
| { | |
| "find": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": { | |
| "$type": "null" | |
| } | |
| } | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:39:35.647+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35539\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"find\":\"event_AT_bettermarks\",\"filter\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":{\"$type\":\"null\"}},\"projection\":{\"_id\":0,\"__doc\":\"$$ROOT\",\"__size\":{\"$bsonSize\":\"$$ROOT\"}},\"skip\":0,\"limit\":100,\"maxTimeMS\":60000,\"lsid\":{\"id\":{\"$uuid\":\"c7f76f6a-95e1-4cf0-97b6-508b998006f1\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566756,\"i\":3}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"CGXIrts9dz2m3Wtthkxd6E2/G4k=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":265,\"keysExamined\":1037,\"docsExamined\":1037,\"nBatches\":1,\"cursorExhausted\":true,\"numYields\":3,\"nreturned\":0,\"queryHash\":\"7B234FFB\",\"planCacheKey\":\"6766F52C\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":4}},\"Global\":{\"acquireCount\":{\"r\":4}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":35709213,\"timeReadingMicros\":5896}},\"cpuNanos\":33468142,\"remote\":\"3.127.55.6:62021\",\"protocol\":\"op_msg\",\"durationMillis\":40}}", | |
| "stats": { | |
| "ms": 40, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566775784 | |
| } | |
| } | |
| ], | |
| "predicateHashes": [ | |
| "5356958717698746845" | |
| ], | |
| "queryShapeHashes": [], | |
| "queryShapes": [], | |
| "queryTargeting": 1037 | |
| }, | |
| { | |
| "avgMs": 97, | |
| "avgNReturned": 0, | |
| "avgNScanned": 1037, | |
| "count": 1, | |
| "fromCountOrDistinct": false, | |
| "id": "691ee78b73b2257ec38fa5c2", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "operations": [ | |
| { | |
| "predicates": [ | |
| { | |
| "aggregate": [ | |
| { | |
| "$match": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata.device_pixel_ratio": { | |
| "$exists": false | |
| } | |
| } | |
| }, | |
| { | |
| "$count": "count" | |
| } | |
| ] | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:38:33.472+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35529\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"aggregate\":\"event_AT_bettermarks\",\"pipeline\":[{\"$match\":{\"event_type\":\"ReportProblemEvent\",\"metadata.device_pixel_ratio\":{\"$exists\":false}}},{\"$count\":\"count\"}],\"cursor\":{},\"maxTimeMS\":5000,\"lsid\":{\"id\":{\"$uuid\":\"cba9171b-bfc5-4156-99a5-addd62fa3220\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566713,\"i\":2}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"vXe8j5gv7mVzNo9cvM3qIw2MWbE=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":164,\"keysExamined\":1037,\"docsExamined\":1037,\"cursorExhausted\":true,\"numYields\":7,\"nreturned\":0,\"queryHash\":\"94335E5E\",\"planCacheKey\":\"280A6E17\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":9}},\"Global\":{\"acquireCount\":{\"r\":9}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"writeConcern\":{\"w\":\"majority\",\"wtimeout\":0,\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":97504381,\"timeReadingMicros\":11584}},\"cpuNanos\":96953434,\"remote\":\"3.122.44.223:34944\",\"protocol\":\"op_msg\",\"durationMillis\":97}}", | |
| "stats": { | |
| "ms": 97, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566713609 | |
| } | |
| } | |
| ], | |
| "predicateHashes": [ | |
| "7219575955243324623" | |
| ], | |
| "queryShapeHashes": [], | |
| "queryShapes": [], | |
| "queryTargeting": 1037 | |
| }, | |
| { | |
| "avgMs": 49, | |
| "avgNReturned": 0, | |
| "avgNScanned": 1037, | |
| "count": 2, | |
| "fromCountOrDistinct": false, | |
| "id": "691ee78b73b2257ec38fa5dc", | |
| "namespace": "backend.event_AT_bettermarks", | |
| "operations": [ | |
| { | |
| "predicates": [ | |
| { | |
| "find": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata": null | |
| } | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:40:45.157+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35554\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"find\":\"event_AT_bettermarks\",\"filter\":{\"event_type\":\"ReportProblemEvent\",\"metadata\":null},\"projection\":{\"_id\":0,\"__doc\":\"$$ROOT\",\"__size\":{\"$bsonSize\":\"$$ROOT\"}},\"skip\":0,\"limit\":100,\"maxTimeMS\":60000,\"lsid\":{\"id\":{\"$uuid\":\"5b9576d4-8970-45db-a337-3c9059075339\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566840,\"i\":228}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"WfyTu7VXjTTBFejZaTQTOm89oi8=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":188,\"keysExamined\":1037,\"docsExamined\":1037,\"nBatches\":1,\"cursorExhausted\":true,\"numYields\":4,\"nreturned\":0,\"queryHash\":\"929EE63F\",\"planCacheKey\":\"2C5A91C3\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":5}},\"Global\":{\"acquireCount\":{\"r\":5}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":15364422,\"timeReadingMicros\":2203}},\"cpuNanos\":19810580,\"remote\":\"3.122.44.223:28664\",\"protocol\":\"op_msg\",\"durationMillis\":48}}", | |
| "stats": { | |
| "ms": 48, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566845294 | |
| } | |
| }, | |
| { | |
| "predicates": [ | |
| { | |
| "aggregate": [ | |
| { | |
| "$match": { | |
| "event_type": "ReportProblemEvent", | |
| "metadata": null | |
| } | |
| }, | |
| { | |
| "$count": "count" | |
| } | |
| ] | |
| } | |
| ], | |
| "raw": "{\"t\":{\"$date\":\"2025-11-19T15:40:45.157+00:00\"},\"s\":\"I\", \"c\":\"COMMAND\", \"id\":51803, \"ctx\":\"conn35556\",\"msg\":\"Slow query\",\"attr\":{\"type\":\"command\",\"ns\":\"backend.event_AT_bettermarks\",\"appName\":\"Data Explorer--64a521bde3797d3fc19b08c4\",\"command\":{\"aggregate\":\"event_AT_bettermarks\",\"pipeline\":[{\"$match\":{\"event_type\":\"ReportProblemEvent\",\"metadata\":null}},{\"$count\":\"count\"}],\"cursor\":{},\"maxTimeMS\":5000,\"lsid\":{\"id\":{\"$uuid\":\"838a60f0-d4f7-47a0-b138-1a1837da1501\"}},\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1763566840,\"i\":229}},\"signature\":{\"hash\":{\"$binary\":{\"base64\":\"WfyTu7VXjTTBFejZaTQTOm89oi8=\",\"subType\":\"0\"}},\"keyId\":7522009764331520041}},\"$db\":\"backend\"},\"planSummary\":\"IXSCAN { event_type: 1, timestamp: 1 }\",\"planningTimeMicros\":131,\"keysExamined\":1037,\"docsExamined\":1037,\"cursorExhausted\":true,\"numYields\":4,\"nreturned\":0,\"queryHash\":\"929EE63F\",\"planCacheKey\":\"2C5A91C3\",\"queryFramework\":\"classic\",\"reslen\":242,\"locks\":{\"FeatureCompatibilityVersion\":{\"acquireCount\":{\"r\":6}},\"Global\":{\"acquireCount\":{\"r\":6}}},\"readConcern\":{\"level\":\"local\",\"provenance\":\"implicitDefault\"},\"writeConcern\":{\"w\":\"majority\",\"wtimeout\":0,\"provenance\":\"implicitDefault\"},\"storage\":{\"data\":{\"bytesRead\":39992523,\"timeReadingMicros\":4770}},\"cpuNanos\":37813351,\"remote\":\"3.122.44.223:64720\",\"protocol\":\"op_msg\",\"durationMillis\":50}}", | |
| "stats": { | |
| "ms": 50, | |
| "nReturned": 0, | |
| "nScanned": 1037, | |
| "ts": 1763566845294 | |
| } | |
| } | |
| ], | |
| "predicateHashes": [ | |
| "5244271316208728979" | |
| ], | |
| "queryShapeHashes": [], | |
| "queryShapes": [], | |
| "queryTargeting": 1037 | |
| } | |
| ], | |
| "suggestedIndexes": [ | |
| { | |
| "avgMs": 61, | |
| "avgNReturned": 0, | |
| "avgNScanned": 1037, | |
| "avgObjSize": 1007.0, | |
| "count": 8, | |
| "fromCountOrDistinct": false, | |
| "id": "691ee78c73b2257ec38fab55", | |
| "impact": [ | |
| "691ee78b73b2257ec38fa5b3", | |
| "691ee78b73b2257ec38fa5a7", | |
| "691ee78b73b2257ec38fa5b5", | |
| "691ee78b73b2257ec38fa5c2" | |
| ], | |
| "index": [ | |
| { | |
| "event_type": 1 | |
| }, | |
| { | |
| "metadata.device_pixel_ratio": 1 | |
| } | |
| ], | |
| "indexWeight": 8353065.0, | |
| "namespace": "backend.event_AT_bettermarks", | |
| "queryTargeting": 1037, | |
| "sortInMemoryCount": 0 | |
| }, | |
| { | |
| "avgMs": 49, | |
| "avgNReturned": 0, | |
| "avgNScanned": 1037, | |
| "avgObjSize": 1007.0, | |
| "count": 2, | |
| "fromCountOrDistinct": false, | |
| "id": "691ee78c73b2257ec38fab56", | |
| "impact": [ | |
| "691ee78b73b2257ec38fa5dc" | |
| ], | |
| "index": [ | |
| { | |
| "event_type": 1 | |
| }, | |
| { | |
| "metadata": 1 | |
| } | |
| ], | |
| "indexWeight": 2088518.0, | |
| "namespace": "backend.event_AT_bettermarks", | |
| "queryTargeting": 1037, | |
| "sortInMemoryCount": 0 | |
| } | |
| ], | |
| "timeCollected": "2025-11-20T10:03:56Z", | |
| "timespan": 86400000 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment