korsasupreme

databaselogs

Mar 26th, 2021 (edited)
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.96 KB | None | 0 0
  1. log from server
  2. 2021-03-26T10:06:14.030+0000 I COMMAND [conn7063] warning: log line attempted (25kB) over max size (10kB), printing beginning and end ... command test.client_session_info command: aggregate { aggregate: "client_session_info", pipeline: [ { $match: { $or: [ { stop: { $eq: 0 } }, { stop: { $gte: 1616702400 } } ], cpe_id: { $in: [...] }, start: { $lte: 1616788799 } } }, { $group: { _id: "$mac", tx_bytes: { $sum: "$tx_bytes" }, session_count: { $sum: 1 }, usernames: { $addToSet: "$username" }, sessions: { $push: { freq: "$freq", tx_bytes: "$tx_bytes", username: "$username", useragent: "$useragent", start: "$start", radio_id: "$radio_id", start_noise: "$start_noise", start_rssi: "$start_rssi", stop_rssi: "$stop_rssi", ssid: "$ssid", duration: "$duration", dest_ips: "$dpi.dest_ips", stop: "$stop", wlan_id: "$wlan_id", cpe_id: "$cpe_id", mode: "$mode", stop_noise: "$stop_noise", rx_bytes: "$rx_bytes" } }, duration: { $sum: "$duration" }, duration_avg: { $avg: "$duration" }, rx_bytes: { $sum: "$rx_bytes" }, username: { $last: "$username" } } }, { $sort: { rx_bytes: -1, _id: 1 } }, { $skip: 0 }, { $limit: 100 } ], cursor: {}, allowDiskUse: true } planSummary: IXSCAN { cpe_id: 1, start: -1, stop: -1, _id: 1 } keysExamined:1996502 docsExamined:1996497 hasSortStage:1 cursorExhausted:1 numYields:15612 nreturned:100 reslen:1604610 locks:{ Global: { acquireCount: { r: 31300 }, acquireWaitCount: { r: 308 }, timeAcquiringMicros: { r: 2204698 } }, Database: { acquireCount: { r: 15650 } }, Collection: { acquireCount: { r: 15649 } } } protocol:op_query 15120ms
  3.  
  4.  
  5.  
  6. log from my pc
  7. 2021-03-26T10:26:27.735+0000 I COMMAND [conn132] command test.client_session_info command: aggregate { aggregate: "client_session_info", pipeline: [ { $match: { cpe_id: { $in: [ .... ] }, start: { $lte: 1616702400 }, $or: [ { stop: { $eq: 0 } }, { stop: { $gte: 1616616000 } } ] } }, { $group: { _id: "$mac", sessions: { $push: { wlan_id: "$wlan_id", cpe_id: "$cpe_id", radio_id: "$radio_id", freq: "$freq", stop: "$stop", stop_rssi: "$stop_rssi", rx_bytes: "$rx_bytes", ssid: "$ssid", dest_ips: "$dpi.dest_ips", mode: "$mode", start_rssi: "$start_rssi", tx_bytes: "$tx_bytes", duration: "$duration", username: "$username", start: "$start", start_noise: "$start_noise", stop_noise: "$stop_noise", useragent: "$useragent" } }, duration_avg: { $avg: "$duration" }, rx_bytes: { $sum: "$rx_bytes" }, tx_bytes: { $sum: "$tx_bytes" }, username: { $last: "$username" }, duration: { $sum: "$duration" }, session_count: { $sum: 1 }, usernames: { $addToSet: "$username" } } }, { $sort: { rx_bytes: -1, _id: 1 } }, { $skip: 0 }, { $limit: 100 } ], cursor: {}, allowDiskUse: true, maxTimeMS: 20000 } planSummary: IXSCAN { cpe_id: 1, start: -1, stop: -1, _id: 1 } keysExamined:150153 docsExamined:150058 hasSortStage:1 cursorExhausted:1 numYields:1175 nreturned:100 reslen:1385632 locks:{ Global: { acquireCount: { r: 2368 } }, Database: { acquireCount: { r: 1184 } }, Collection: { acquireCount: { r: 1183 } } } protocol:op_query 679ms
  8.  
Advertisement
Add Comment
Please, Sign In to add comment