Slow queries just on mongos node

I find the slow logs only be logged on mongos . I think the slow queries weren’t be only happened on the mongos and weren be logged on the mongod’s log files(and the queries with shard key should be excuted quickly).

The mongodb’s version is 4.0.12.

The below log only find on the mongoses’s node , haven’t logged on the mongod’s log.

2021-08-06T18:14:39.413+0800 I COMMAND [conn283674] command dmsBik4Bos.bik4bos command: find { find: “bik4bos”, filter: { bikeNo: “7780170950” }, projection: { bizType: 1, rideStatus: 1, bikeType: 1, pos.lat: 1, pos.lng: 1, pos.type: 1, pos.timeStamp: 1, alert: 1, alertMsg: 1, lock: 1, licensePlateNo: 1, lastMaintainTime: 1, serviceAreaId: 1, zeroBatteryScanCount: 1, smallAreaId: 1, rackDeployTime: 1, manualLabel: 1, manualLabelMsg: 1, fault: 1, faultMsg: 1, cityGuid: 1, modelGuid: 1, largeBatteryPercent: 1, opFaultCheck: 1, bikeNo: 1, lockVersion: 1, bigAreaId: 1, siteId: 1, opFault: 1, gridId: 1, opStatus: 1, licensePlateType: 1, lastScanUser: 1 }, limit: 1, singleBatch: true, $db: “dmsBik4Bos”, $clusterTime: { clusterTime: Timestamp(1628244877, 3136), signature: { hash: BinData(0, 8BF6B66C9B87883E83465F8833EFAC596C2026FE), keyId: 6962514570933960916 } }, lsid: { id: UUID(“a26797f2-7427-471f-9dab-3c2fa649560f”) }, $readPreference: { mode: “primaryPreferred” } } nShards:1 cursorExhausted:1 numYields:0 nreturned:1 reslen:1980 protocol:op_msg 1799ms

1 Like