system.profile Collection

View documents in this collection


Documents

Showing up to 10 documents:

Document 1
{"op": "query", "ns": "qa_e.objectTypes", "command": {"find": "objectTypes", "filter": {"_id": {"$oid": "69ba6fbd63d8e12b372ef28c"}}, "limit": 1, "singleBatch": true, "$db": "qa_e", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1775048573, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "6y1DflHOs1fmVOog0X45gL4mTac=", "subType": "00"}}, "keyId": 7566288231453425666}}, "lsid": {"id": {"$binary": {"base64": "xnfp6VPYSZyny6x8TPIU0g==", "subType": "04"}}}}, "keysExamined": 1, "docsExamined": 1, "nBatches": 1, "cursorExhausted": true, "numYield": 0, "nreturned": 1, "queryFramework": "classic", "locks": {"Global": {"acquireCount": {"r": 2}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 21628, "timeReadingMicros": 6796}}, "responseLength": 2160, "protocol": "op_msg", "cpuNanos": 67883864, "millis": 283, "planSummary": "EXPRESS_IXSCAN { _id: 1 }", "planningTimeMicros": 88323, "execStats": {"isCached": false, "stage": "EXPRESS_IXSCAN", "keyPattern": "{ _id: 1 }", "indexName": "_id_", "keysExamined": 1, "docsExamined": 1, "nReturned": 1}, "ts": {"$date": "2026-04-01T13:03:04.748Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}
Document 2
{"op": "command", "ns": "qa_e.eq", "command": {"aggregate": "eq", "pipeline": [{"$match": {"$and": [{"usageStatus": 1}, {"facilityId": "1616367801"}]}}, {"$group": {"_id": 1, "n": {"$sum": 1}}}], "cursor": {}, "$db": "qa_e", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1775048583, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "7GZs2uHT5Ony5u1DY3CCynoRQrQ=", "subType": "00"}}, "keyId": 7566288231453425666}}, "lsid": {"id": {"$binary": {"base64": "xnfp6VPYSZyny6x8TPIU0g==", "subType": "04"}}}}, "keysExamined": 0, "docsExamined": 0, "cursorExhausted": true, "numYield": 2, "nreturned": 0, "planCacheShapeHash": "1567DC07", "queryHash": "1567DC07", "planCacheKey": "4DDBFA90", "queryShapeHash": "E59C4B420A8C1EEEC3300A28AA9C6AC71ABD4EAB5080D5A4108E0662E7EEF3DA", "queryFramework": "sbe", "locks": {"Global": {"acquireCount": {"r": 4}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 107, "timeReadingMicros": 2126}}, "responseLength": 221, "protocol": "op_msg", "cpuNanos": 451872154, "millis": 1697, "planSummary": "COUNT_SCAN { usageStatus: 1, facilityId: 1, externalId: 1 }", "planningTimeMicros": 938771, "ts": {"$date": "2026-04-01T13:03:07.842Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}
Document 3
{"op": "query", "ns": "qa_e.eq", "command": {"find": "eq", "filter": {"$and": [{"usageStatus": 1}, {"facilityId": "1616367801"}]}, "sort": {"_id": -1}, "limit": 25, "$db": "qa_e", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1775048583, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "7GZs2uHT5Ony5u1DY3CCynoRQrQ=", "subType": "00"}}, "keyId": 7566288231453425666}}, "lsid": {"id": {"$binary": {"base64": "xnfp6VPYSZyny6x8TPIU0g==", "subType": "04"}}}}, "keysExamined": 0, "docsExamined": 0, "hasSortStage": true, "fromPlanCache": true, "nBatches": 1, "cursorExhausted": true, "numYield": 2, "nreturned": 0, "planCacheShapeHash": "F2EC0FFB", "queryHash": "F2EC0FFB", "planCacheKey": "2D651DC8", "queryShapeHash": "D3DB9F3BDA5F5BB682148DDE3C9C070B096CF4DDB4B7A59E44C5903F034AC322", "queryFramework": "classic", "locks": {"Global": {"acquireCount": {"r": 4}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {}, "responseLength": 221, "protocol": "op_msg", "cpuNanos": 236860740, "millis": 827, "planSummary": "IXSCAN { usageStatus: 1, facilityId: 1, externalId: 1 }", "planningTimeMicros": 676615, "execStats": {"isCached": false, "stage": "CACHED_PLAN", "nReturned": 0, "executionTimeMillisEstimate": 122, "works": 1, "advanced": 0, "needTime": 0, "needYield": 0, "saveState": 2, "restoreState": 2, "isEOF": 1, "inputStage": {"stage": "SORT", "nReturned": 0, "executionTimeMillisEstimate": 77, "works": 2, "advanced": 0, "needTime": 1, "needYield": 0, "saveState": 2, "restoreState": 2, "isEOF": 1, "sortPattern": {"_id": -1}, "memLimit": 104857600, "limitAmount": 25, "type": "simple", "totalDataSizeSorted": 0, "usedDisk": false, "spills": 0, "spilledDataStorageSize": 0, "inputStage": {"stage": "FETCH", "nReturned": 0, "executionTimeMillisEstimate": 50, "works": 1, "advanced": 0, "needTime": 0, "needYield": 0, "saveState": 2, "restoreState": 2, "isEOF": 1, "docsExamined": 0, "alreadyHasObj": 0, "inputStage": {"stage": "IXSCAN", "nReturned": 0, "executionTimeMillisEstimate": 50, "works": 1, "advanced": 0, "needTime": 0, "needYield": 0, "saveState": 2, "restoreState": 2, "isEOF": 1, "keyPattern": {"usageStatus": 1, "facilityId": 1, "externalId": 1}, "indexName": "usageStatus_1_facilityId_1_externalId_1", "isMultiKey": false, "multiKeyPaths": {"usageStatus": [], "facilityId": [], "externalId": []}, "isUnique": true, "isSparse": false, "isPartial": true, "indexVersion": 2, "direction": "forward", "indexBounds": {"usageStatus": ["[1, 1]"], "facilityId": ["[\"1616367801\", \"1616367801\"]"], "externalId": ["[MinKey, MaxKey]"]}, "keysExamined": 0, "seeks": 1, "dupsTested": 0, "dupsDropped": 0}}}}, "ts": {"$date": "2026-04-01T13:03:09.232Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}
Document 4
{"op": "command", "ns": "qa_e", "command": {"dbStats": 1, "scale": 1, "freeStorage": 1, "lsid": {"id": {"$binary": {"base64": "yXGtEy1wQi2eMLMHg9J8Ig==", "subType": "04"}}}, "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1775646831, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "G6nRaLLZBbIuJMK6L6FZOHyVUOQ=", "subType": "00"}}, "keyId": 7566288231453425666}}, "$db": "qa_e", "$readPreference": {"mode": "primaryPreferred"}}, "numYield": 0, "locks": {"ReplicationStateTransition": {"acquireCount": {"w": 1}}, "Global": {"acquireCount": {"r": 2}}, "Database": {"acquireCount": {"r": 1}}, "Collection": {"acquireCount": {"r": 13}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 1437168, "timeReadingMicros": 200}, "timeWaitingMicros": {"handleLock": 14904}}, "responseLength": 490, "protocol": "op_msg", "cpuNanos": 42260400, "millis": 397, "ts": {"$date": "2026-04-08T11:13:55.019Z"}, "client": "172.18.0.4", "appName": "mongodb_exporter", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}
Document 5
{"op": "command", "ns": "qa_e", "command": {"dbStats": 1, "scale": 1, "freeStorage": 1, "lsid": {"id": {"$binary": {"base64": "yXGtEy1wQi2eMLMHg9J8Ig==", "subType": "04"}}}, "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1775717974, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "rODFeTpw6F93Cgfv69mHiB67OOc=", "subType": "00"}}, "keyId": 7566288231453425666}}, "$db": "qa_e", "$readPreference": {"mode": "primaryPreferred"}}, "numYield": 0, "locks": {"ReplicationStateTransition": {"acquireCount": {"w": 1}}, "Global": {"acquireCount": {"r": 2}}, "Database": {"acquireCount": {"r": 1}}, "Collection": {"acquireCount": {"r": 13}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 1437168, "timeReadingMicros": 170}, "timeWaitingMicros": {"handleLock": 3806, "schemaLock": 256312}}, "responseLength": 490, "protocol": "op_msg", "cpuNanos": 26553473, "millis": 287, "ts": {"$date": "2026-04-09T06:59:37.422Z"}, "client": "172.18.0.4", "appName": "mongodb_exporter", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}
Document 6
{"op": "command", "ns": "qa_e", "command": {"dbStats": 1, "scale": 1, "freeStorage": 1, "lsid": {"id": {"$binary": {"base64": "ZwIMdLvpTdWAiCzkub3rpA==", "subType": "04"}}}, "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1776269730, "i": 2}}, "signature": {"hash": {"$binary": {"base64": "5BZku8rK094w/7CXItMfbnCipU0=", "subType": "00"}}, "keyId": 7566288231453425666}}, "$db": "qa_e", "$readPreference": {"mode": "primaryPreferred"}}, "numYield": 0, "locks": {"ReplicationStateTransition": {"acquireCount": {"w": 1}}, "Global": {"acquireCount": {"r": 2}}, "Database": {"acquireCount": {"r": 1}}, "Collection": {"acquireCount": {"r": 13}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 1437168, "timeReadingMicros": 119}, "timeWaitingMicros": {"handleLock": 1993, "schemaLock": 369501}}, "responseLength": 490, "protocol": "op_msg", "cpuNanos": 20539556, "millis": 393, "ts": {"$date": "2026-04-15T16:15:39.742Z"}, "client": "172.18.0.8", "appName": "mongodb_exporter", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}