sqlite-object-cache icon indicating copy to clipboard operation
sqlite-object-cache copied to clipboard

Make an interactive visualization for statistics

Open nickchomey opened this issue 10 months ago • 1 comments

A picture is worth 1000 words.

I very much like the detailed stats that are collected and presented by this plugin, yet find it difficult to actually glean information from a big table of numbers - despite being very statistically inclined/trained/experienced. Conversely, you can instantly glean considerable information from a good visualization.

I think, at the very least, the existing stats could be presented in boxplots. Here's an example: Image

Perhaps even better would be a timeseries, like Redis Object Cache does, but with confidence bands rather than just their rolling median (or perhaps its an average. I dont recall). An example, with just a single band, but it could be done with p25/75. p5/95, etc...

Image

A row of buttons/radio buttons etc... adjacent to the chart could toggle between the different stats.

I could probably help with this at some point, but am a bit busy right now.

nickchomey avatar Feb 28 '25 15:02 nickchomey

You're quite right about the presentation of the stats.

OllieJones avatar Mar 02 '25 12:03 OllieJones