Loggly Event Delta Calculation

README.md

How to use this

Pre-requisites

• Install R
• run install.packages('parsedate') in your r shell

Use the script

1. Get your Loggly results for some event and export the results as a csv.
2. Run the r script with the file as input and out will pop the average time taken between the events occurring and their standard deviations.

loggly_event_time_deltas.r

timestampDiffs <- function(filename) {
  data <- read.csv(filename)
  event_times <- data[,1]

  library(parsedate)

  event_times_parsed <- parse_iso_8601(substr(event_times, 0, 23))
  event_sec_diffs <- diff(rev(event_times_parsed), 1)

  event_sec_diffs
}

# Example

event_sec_diffs <- timestampDiffs('loggly_grid_2022-11-08 17_26_48.902484.csv')

mean(event_sec_diffs)
# Time difference of 142.9542 secs

sd(event_sec_diffs)
# 190.6124