system.profile Collection

{"op": "command", "ns": "stage_hetero.plannedOrders", "command": {"createIndexes": "plannedOrders", "indexes": [{"key": {"usageStatus": 1, "facilityId": 1, "externalId": 1}, "partialFilterExpression": {"usageStatus": 1}, "name": "usageStatus_1_facilityId_1_externalId_1", "unique": true, "ns": "stage_hetero.plannedOrders"}], "ignoreUnknownIndexOptions": true, "lsid": {"id": {"$binary": {"base64": "ccHvbFH/RfSRBS2RDBOLYg==", "subType": "04"}}}, "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778218166, "i": 29}}, "signature": {"hash": {"$binary": {"base64": "MhIgNwjOHh6x4U3VOGSgnqgYtik=", "subType": "00"}}, "keyId": 7637157051558264839}}, "$db": "stage_hetero", "$readPreference": {"mode": "primaryPreferred"}}, "numYield": 0, "locks": {"ReplicationStateTransition": {"acquireCount": {"w": 6}}, "Global": {"acquireCount": {"r": 4, "w": 3}}, "Database": {"acquireCount": {"w": 2}}, "Collection": {"acquireCount": {"w": 1, "W": 1}}, "Mutex": {"acquireCount": {"r": 1}}}, "flowControl": {"acquireCount": 3}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "waitForWriteConcernDuration": 54, "storage": {}, "responseLength": 271, "protocol": "op_msg", "cpuNanos": 767854, "millis": 374, "ts": {"$date": "2026-05-08T05:29:26.862Z"}, "client": "172.18.0.1", "appName": "mongorestore", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.products", "command": {"createIndexes": "products", "indexes": [{"key": {"usageStatus": 1, "facilityId": 1, "externalId": 1}, "partialFilterExpression": {"usageStatus": 1}, "ns": "stage_hetero.products", "name": "usageStatus_1_facilityId_1_externalId_1", "unique": true}], "ignoreUnknownIndexOptions": true, "lsid": {"id": {"$binary": {"base64": "sQ0ur75oSRm1MQx5SLxdAQ==", "subType": "04"}}}, "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778218166, "i": 43}}, "signature": {"hash": {"$binary": {"base64": "MhIgNwjOHh6x4U3VOGSgnqgYtik=", "subType": "00"}}, "keyId": 7637157051558264839}}, "$db": "stage_hetero", "$readPreference": {"mode": "primaryPreferred"}}, "numYield": 0, "locks": {"ReplicationStateTransition": {"acquireCount": {"w": 6}}, "Global": {"acquireCount": {"r": 4, "w": 3}}, "Database": {"acquireCount": {"w": 2}}, "Collection": {"acquireCount": {"w": 1, "W": 1}}, "Mutex": {"acquireCount": {"r": 1}}}, "flowControl": {"acquireCount": 3}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "waitForWriteConcernDuration": 54, "storage": {}, "responseLength": 271, "protocol": "op_msg", "cpuNanos": 697897, "millis": 270, "ts": {"$date": "2026-05-08T05:29:26.955Z"}, "client": "172.18.0.1", "appName": "mongorestore", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "insert", "ns": "stage_hetero.changeLogs", "command": {"insert": "changeLogs", "ordered": true, "$db": "stage_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778478350, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "7jqfRi6HelJVPboJoujzRmEO8fY=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "y6cbirttR3ePTQDGlIs8vw==", "subType": "04"}}}, "txnNumber": 158, "autocommit": false}, "ninserted": 1, "keysInserted": 1, "numYield": 0, "locks": {"Collection": {"acquireCount": {"w": 1}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 3665080, "timeReadingMicros": 161091, "txnBytesDirty": 7680}}, "responseLength": 230, "protocol": "op_msg", "cpuNanos": 2753116, "millis": 250, "ts": {"$date": "2026-05-11T05:45:56.98Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.$cmd.aggregate", "command": {"aggregate": 1, "pipeline": [{"$changeStream": {"fullDocument": "updateLookup", "fullDocumentBeforeChange": "whenAvailable"}}], "cursor": {}, "$db": "stage_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778492889, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "1EskaVQ1ZBHBTPYNezxtyNFGuEQ=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "s0SZWa31S/uNQ+AkUfg2Yg==", "subType": "04"}}}}, "cursorid": 7845756083439504545, "keysExamined": 0, "docsExamined": 3, "numYield": 0, "nreturned": 15, "planCacheShapeHash": "655A0E98", "queryHash": "655A0E98", "planCacheKey": "B02DB244", "queryShapeHash": "6315F22B9B53C918348C7C80E2097160A46829B1E68DDACC0ED7B912E41138E0", "queryFramework": "classic", "locks": {"Global": {"acquireCount": {"r": 4}}}, "flowControl": {}, "readConcern": {"level": "majority"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 266873, "timeReadingMicros": 4264}}, "responseLength": 11530, "protocol": "op_msg", "cpuNanos": 3926837, "millis": 230, "planSummary": "COLLSCAN", "planningTimeMicros": 27506, "ts": {"$date": "2026-05-11T09:48:18.779Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.productionVersion", "command": {"aggregate": "productionVersion", "pipeline": [{"$match": {"$and": [{"usageStatus": 1}, {"facilityId": "1771087225"}, {"$or": [{"displayName": {"$regularExpression": {"pattern": "(?i)(?s)^.*000000000003013196_0001.*$", "options": "is"}}}, {"externalId": {"$regularExpression": {"pattern": "(?i)(?s)^.*000000000003013196_0001.*$", "options": "is"}}}]}, {"$or": [{"displayName": {"$regularExpression": {"pattern": "(?i)(?s)^.*000000000003013196_0001.*$", "options": "is"}}}, {"externalId": {"$regularExpression": {"pattern": "(?i)(?s)^.*000000000003013196_0001.*$", "options": "is"}}}]}]}}, {"$group": {"_id": 1, "n": {"$sum": 1}}}], "cursor": {}, "$db": "stage_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778575822, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "sI+WO/YMeopbqCgnzCBM/3DiWRk=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "Q2PFGe5STiWuYJEiY6I4xA==", "subType": "04"}}}}, "keysExamined": 4, "docsExamined": 4, "cursorExhausted": true, "numYield": 1, "nreturned": 0, "planCacheShapeHash": "77E977DA", "queryHash": "77E977DA", "planCacheKey": "671CA48A", "queryShapeHash": "3E372159AC2BF26CEBDF34390C67B4D9D0B6EB5B832C0D9A2637E1C3429BC26E", "queryFramework": "sbe", "locks": {"Global": {"acquireCount": {"r": 3}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 244, "protocol": "op_msg", "cpuNanos": 5160225, "millis": 289, "planSummary": "IXSCAN { usageStatus: 1, facilityId: 1, externalId: 1 }", "planningTimeMicros": 236564, "ts": {"$date": "2026-05-12T08:50:28.894Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.instruments", "command": {"createIndexes": "instruments", "indexes": [{"key": {"usageStatus": 1, "facilityId": 1, "externalId": 1}, "name": "usageStatus_1_facilityId_1_externalId_1", "unique": true, "partialFilterExpression": {"usageStatus": 1}}], "$db": "stage_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778577309, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "9liKNX+b0qh3dxUfSxuXan1cQ4s=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "Kl/n+dnLT9GyMeuUgB1eiw==", "subType": "04"}}}, "txnNumber": 233, "autocommit": false}, "numYield": 0, "locks": {"MultiDocumentTransactionsBarrier": {"acquireCount": {"w": 1}}, "ReplicationStateTransition": {"acquireCount": {"w": 1}}, "Global": {"acquireCount": {"w": 1}}, "Database": {"acquireCount": {"w": 1}}, "Collection": {"acquireCount": {"w": 2}}, "Mutex": {"acquireCount": {"r": 2}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "storage": {"data": {"bytesRead": 112343, "timeReadingMicros": 11887, "txnBytesDirty": 4490}}, "responseLength": 271, "protocol": "op_msg", "cpuNanos": 8120873, "millis": 472, "ts": {"$date": "2026-05-12T09:15:18.009Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.objectTypes", "command": {"aggregate": "objectTypes", "pipeline": [{"$match": {"$and": [{"usageStatus": 1}]}}, {"$group": {"_id": 1, "n": {"$sum": 1}}}], "cursor": {}, "$db": "stage_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778869899, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "XwR40rLVTr8J53BRUuKtuHtv798=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "lGzTIHSnRPKGNHAEXh9Q6Q==", "subType": "04"}}}}, "keysExamined": 63, "docsExamined": 0, "cursorExhausted": true, "numYield": 1, "nreturned": 1, "planCacheShapeHash": "8D4D1CE3", "queryHash": "8D4D1CE3", "planCacheKey": "8B1EB6E4", "queryShapeHash": "C46B10258078C45E497AB20DE2A612E240AC8F25DFC57BFB17D6C8BFF217F604", "queryFramework": "sbe", "locks": {"Global": {"acquireCount": {"r": 3}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 262, "protocol": "op_msg", "cpuNanos": 4194378, "millis": 376, "planSummary": "COUNT_SCAN { usageStatus: 1, externalId: 1 }", "planningTimeMicros": 338681, "ts": {"$date": "2026-05-15T18:31:47.71Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.objectTypes", "command": {"aggregate": "objectTypes", "pipeline": [{"$match": {"_id": {"$oid": "69e60509060994708f737319"}}}, {"$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_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778874845, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "qEqNW1Sr52DHqNK99piip8B6cq8=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "1V+mEV6DT7uXGpP0HzFb7Q==", "subType": "04"}}}}, "keysExamined": 1, "docsExamined": 1, "hasSortStage": true, "cursorExhausted": true, "numYield": 2, "nreturned": 1, "queryShapeHash": "B8E74A5FB6DA51607EBFE848B2B81FD6AAED22673F4DF15AC58402645BFD44C2", "queryFramework": "classic", "locks": {"Global": {"acquireCount": {"r": 5}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 261, "protocol": "op_msg", "cpuNanos": 3702787, "millis": 1294, "planSummary": "IDHACK", "planningTimeMicros": 49116, "ts": {"$date": "2026-05-15T19:54:15.367Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.objectTypes", "command": {"aggregate": "objectTypes", "pipeline": [{"$match": {"_id": {"$oid": "69e60509060994708f737319"}}}, {"$project": {"relations": {"$filter": {"input": "$relations", "as": "relation", "cond": {"$and": [{"$eq": ["$$relation.usageStatus", 1]}]}}}}}, {"$project": {"_id": 0}}, {"$unwind": "$relations"}, {"$replaceRoot": {"newRoot": "$relations"}}, {"$sort": {"sortOrder": 1}}, {"$count": "totalSize"}], "cursor": {}, "allowDiskUse": false, "$db": "stage_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778874845, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "qEqNW1Sr52DHqNK99piip8B6cq8=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "7/B5RKuFQiyMrDeKR5psRQ==", "subType": "04"}}}}, "keysExamined": 1, "docsExamined": 1, "hasSortStage": true, "cursorExhausted": true, "numYield": 2, "nreturned": 1, "queryShapeHash": "30C467F72D4D00567857666FFD0856AADB62C395A027D7E2E621BDDC3D38C5D2", "queryFramework": "classic", "locks": {"Global": {"acquireCount": {"r": 5}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 261, "protocol": "op_msg", "cpuNanos": 5578163, "millis": 1294, "planSummary": "IDHACK", "planningTimeMicros": 49100, "ts": {"$date": "2026-05-15T19:54:15.366Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}

{"op": "command", "ns": "stage_hetero.objectTypes", "command": {"aggregate": "objectTypes", "pipeline": [{"$match": {"$and": [{"usageStatus": 1}]}}, {"$group": {"_id": 1, "n": {"$sum": 1}}}], "cursor": {}, "$db": "stage_hetero", "$clusterTime": {"clusterTime": {"$timestamp": {"t": 1778874845, "i": 1}}, "signature": {"hash": {"$binary": {"base64": "qEqNW1Sr52DHqNK99piip8B6cq8=", "subType": "00"}}, "keyId": 7637157051558264839}}, "lsid": {"id": {"$binary": {"base64": "dc08zdPUQv2g7odCdxvm7w==", "subType": "04"}}}}, "keysExamined": 63, "docsExamined": 0, "cursorExhausted": true, "numYield": 2, "nreturned": 1, "planCacheShapeHash": "8D4D1CE3", "queryHash": "8D4D1CE3", "planCacheKey": "8B1EB6E4", "queryShapeHash": "C46B10258078C45E497AB20DE2A612E240AC8F25DFC57BFB17D6C8BFF217F604", "queryFramework": "sbe", "locks": {"Global": {"acquireCount": {"r": 4}}}, "flowControl": {}, "readConcern": {"level": "local", "provenance": "implicitDefault"}, "writeConcern": {"w": "majority", "wtimeout": 0, "provenance": "implicitDefault"}, "storage": {}, "responseLength": 262, "protocol": "op_msg", "cpuNanos": 9697283, "millis": 2000, "planSummary": "COUNT_SCAN { usageStatus: 1, externalId: 1 }", "planningTimeMicros": 1172075, "ts": {"$date": "2026-05-15T19:54:16.626Z"}, "client": "172.18.0.1", "allUsers": [{"user": "root", "db": "admin"}], "user": "root@admin"}