system.profile Collection

{"op": "command", "ns": "stage_aet.objectTypes", "command": {"aggregate": "objectTypes", "pipeline": [{"$match": {"$and": [{"usageStatus": 1}]}}, {"$group": {"_id": 1, "n": {"$sum": 1}}}], "cursor": {}, "$db": "stage_aet", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1782969463, "i": 10}}, "signature": {"hash": {"$binary": {"base64": "8Bfh5M/oogFBH3UcpfpK45YYrOo=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "FYTCBiGaSVOLRwkVqCWoBw==", "subType": "04"}}}}, "keysExamined": 57, "docsExamined": 0, "cursorExhausted": true, "numYield": 1, "nreturned": 1, "planCacheShapeHash": "8D4D1CE3", "queryHash": "8D4D1CE3", "planCacheKey": "8B1EB6E4", "queryShapeHash": "15CED2ABF357CF4D273A5297CB30FD101A2EDA4FE3D13CF9E3B5684DF588DDC5", "queryFramework": "sbe", "locks": {"Global": {"acquireCount": {"r": 3}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 259, "protocol": "op_msg", "cpuNanos": 5227401, "millis": 413, "planSummary": "COUNT_SCAN { usageStatus: 1, externalId: 1 }", "planningTimeMicros": 354480, "ts": {"$date": "2026-07-02T05:17:55.943Z"}, "client": "172.18.0.8", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_aet.objectTypes", "command": {"aggregate": "objectTypes", "pipeline": [{"$match": {"$and": [{"usageStatus": 1}]}}, {"$group": {"_id": 1, "n": {"$sum": 1}}}], "cursor": {}, "$db": "stage_aet", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1782969481, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "EGh8kVrHnI6H6g5kiZfB+Vv/8j0=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "FYTCBiGaSVOLRwkVqCWoBw==", "subType": "04"}}}}, "keysExamined": 57, "docsExamined": 0, "cursorExhausted": true, "numYield": 2, "nreturned": 1, "planCacheShapeHash": "8D4D1CE3", "queryHash": "8D4D1CE3", "planCacheKey": "8B1EB6E4", "queryShapeHash": "15CED2ABF357CF4D273A5297CB30FD101A2EDA4FE3D13CF9E3B5684DF588DDC5", "queryFramework": "sbe", "locks": {"Global": {"acquireCount": {"r": 4}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 259, "protocol": "op_msg", "cpuNanos": 13610597, "millis": 1383, "planSummary": "COUNT_SCAN { usageStatus: 1, externalId: 1 }", "planningTimeMicros": 887708, "ts": {"$date": "2026-07-02T05:18:09.701Z"}, "client": "172.18.0.8", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "query", "ns": "stage_aet.objectTypes", "command": {"find": "objectTypes", "filter": {"$and": [{"usageStatus": 1}]}, "sort": {"_id": -1}, "limit": 25, "$db": "stage_aet", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1782969481, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "EGh8kVrHnI6H6g5kiZfB+Vv/8j0=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "FYTCBiGaSVOLRwkVqCWoBw==", "subType": "04"}}}}, "keysExamined": 25, "docsExamined": 25, "fromPlanCache": true, "nBatches": 1, "cursorExhausted": true, "numYield": 0, "nreturned": 25, "planCacheShapeHash": "2853AF91", "queryHash": "2853AF91", "planCacheKey": "46AFBC09", "queryShapeHash": "7C9200D0490AA2403972DED0AB051E37A0FF1307E043269994FA13E4904E73D3", "queryFramework": "classic", "locks": {"Global": {"acquireCount": {"r": 2}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {}, "responseLength": 107366, "protocol": "op_msg", "cpuNanos": 1014971, "millis": 201, "planSummary": "IXSCAN { _id: 1 }", "planningTimeMicros": 181714, "ts": {"$date": "2026-07-02T05:18:10.325Z"}, "client": "172.18.0.8", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_aet.objectTypes", "command": {"aggregate": "objectTypes", "pipeline": [{"$match": {"_id": {"$oid": "6a43cd77bcb7a77323a0291c"}}}, {"$project": {"properties": {"$filter": {"input": "$properties", "as": "property", "cond": {"$and": [{"$eq": ["$$property.usageStatus", 1]}]}}}}}, {"$project": {"_id": 0}}, {"$unwind": "$properties"}, {"$replaceRoot": {"newRoot": "$properties"}}, {"$sort": {"sortOrder": 1}}, {"$count": "totalSize"}], "cursor": {}, "allowDiskUse": false, "$db": "stage_aet", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1782969492, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "tLX8M1KbfOu7QvlCM0pOe5bXOfg=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "FYTCBiGaSVOLRwkVqCWoBw==", "subType": "04"}}}}, "keysExamined": 1, "docsExamined": 1, "hasSortStage": true, "cursorExhausted": true, "numYield": 1, "nreturned": 1, "queryShapeHash": "0E33A564EE95EDFDD940DFDB372967F6096FC7F9F67A9C54A1F329C33C385684", "queryFramework": "classic", "locks": {"Global": {"acquireCount": {"r": 4}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 258, "protocol": "op_msg", "cpuNanos": 2194906, "millis": 206, "planSummary": "IDHACK", "planningTimeMicros": 9088, "ts": {"$date": "2026-07-02T05:18:17.211Z"}, "client": "172.18.0.8", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}