Analyze history of events in grafana

Analysing events? This sounds like a job for the Elastic Stack.

Here is a tutorial: Logging to Filebeat + Elasticsearch + Kibana

But I never used this myself.

And I think this approach still does store all data in a database.
So it might not solve your problem.