I have logs from two apps to analyze. General a session of app interaction (as it is represented in logs) looks like this:
App1 sends message to App2 (Let's say operation code is SEND1)
App2 receives this message (operation code is RECV1)
App2 processes this message and sends the response to App1 (operation code is SEND2)
App1 receives this message (operation code is RECV2)
App1 processes this message and sends the response to App2 (operation code is SEND3)
Each message/response gets a new ID. Each response also has its corresponding request message ID.
Log file of App1 consists of many chunks like:
[timestamp]|SEND1|[XXX7]
[timestamp]|RECV2|[XXX8]
[timestamp]|SEND3|[XXX9]|[XXX8]
Log file of App2 consists of many chunks like:
[timestamp]|RECV1|[XXX7]
[timestamp]|SEND2|[XXX8]|[XXX7]
Where [XXXX] is some random message ID.
Apps are asynchronous, so log records from few sessions can be mixed.
So if you combine both logs, logically group them by message ID's and sort them by timestamps, you'll get something like this:
log from App1 log from App2
[timestamp]|SEND1|[XXX7]
[timestamp]|RECV1|[XXX7]
[timestamp]|SEND2|[XXX8]|[XXX7]
[timestamp]|RECV2|[XXX8]
[timestamp]|SEND3|[XXX9]|[XXX8]
Is there a way to get statistics on average(by the second/minute/hour) delays between each pair of records?
... View more