One year* of RIFT event data

I've been running an event tracker for almost a year. I've also been storing the observed events and run times, so some interesting numbers are below. You can look at more numbers here (don't hammer it, and your browser might not like the size of the all-time view, so restrict by date).

Caveats:

Spoiler!

• Since 2014-10-20, so not quite a year
• Some end times until 2014-11-11 may be way early due to erroneous error handling
• Start times are exact, but end times (in normal collection) are up to one minute late
• Max end times may be way high due to server restarts (the API keeps them up for hours), but are capped at 120 minutes.
• Where known, an event is capped at its max run time
• EU data is missing 2015-08-19 - 2015-09-04
• All data is merely observed by a third-party (me) and may not 100% accurately reflect Trion's data

Across ALL shards and ALL time:

• Your favorite PoW events (Tendrils of Renewal style) all have an average end time of 20 minutes, so get there quickly.
• All of the PoW fortress events (e.g. Fortress of the Broodmother) had a 95th percentile end time of 45 minutes, which is also their max run time, meaning that 95%+ of the time, these events timed out and failed.
• The most common events are Unstable Dendrome and Unstable Steppes of Infinity, at nearly 25000 and nearly 24500 runs each. (The least common Unstables are Unstable Freemarch and Unstable Silverwood at only around 2000 each).
• The most common PoW event is The Ravenous Devourer at over 15000 runs since 2015-01-28. You're not imagining that Finric is always yelling about Ojindingdong.
• The least common events overall are Terror Above and Rotten March at only about 30 runs each.
• Hooves and Horns has run around 400 times.
• The most common Bloodfire Behemoth is Ember Isle around 3200 runs, and the least common are Kingdom of Pelladane and Morban around 120 runs.
• The event with the shortest average run time is Operation: Landfall at 5 minutes. This probably means it always fails quickly. The highest average run time is The Awakening at 113 minutes.
• Other events that usually always time out, at 120 minutes, are The Craft of Conflict, Champions of the Firestorm, Fragment of Kaaz'Ra, and The Rising Depths.
• The event (non-timed, non-always-time out) with the smallest standard deviation is Arboreal Assault, meaning it consistently ends very close to its average run time of 16 minutes. The events with the highest standard deviations (meaning end times vary wildly) are In Golden's Grasp and Terror Above.
• In the PoW, the (non-fortress) event with the most consistent run time is Crushing Force, and the least consistent run times are owned by Darkness from the Depths and Aphogglach.

Anyway, here's a 4MB compressed full MySQL dump if you want to look at the numbers yourself: here (any end times of 0 were currently running at the time of the dump).

One year* of RIFT event data