jq -r --arg start "<start_timestamp>" --arg end "<end_timestamp>" 'select(.msg | contains("query") and .durationMillis >= 100 and .timestamp >= $start and .timestamp <= $end) | .msg' mongodb.log
jq 'select(.timestamp >= "2023-06-01T00:00:00Z" and .timestamp <= "2023-06-15T23:59:59Z" and .executionTime > 1000)' <mongodb_logs.json jq 'select(.executionTime > 1000)' <mongodb_logs.json. jq 'select((strptime("%Y-%m-%dT%H:%M:%SZ") | mktime) >= strptime("2023-06-01T00:00:00Z") and (strptime("%Y-%m-%dT%H:%M:%SZ") | mktime) <= strptime("2023-06-15T23:59:59Z") and .executionTime > 1000)' mongodb_logs.json
Hi White Chris,
ReplyDeleteRegarding the ticket you raised to switch from sync to async — that request has already been completed. Now, you’re requesting to change it back from async to sync.
Please note that this change can only be made through a Change Request (CR). If it’s an emergency, kindly raise an Emergency Change Request (ECR) ticket.
Additionally, we suggest keeping PHX in async mode to avoid latency issues between DAL and PHX.