What does your small business use to track and analyze product analytics?

We've got a lot of users, and we've done a pretty good job of launching features that they like over the years, assuming we know how they behave. But we have started to take a data-driven approach recently by collecting data points about how the app is really being used. But now we've got a lot of data, and we're not sure of the most cost effective way to query it, graph it, monitor with it, etc...

So far we've just been dumping things into PostgreSQL and building materialized views every night, then graphing things on Retool(.com). It's not an idea solution though, those materialized views are fine when we only have a few million events, but as the months have passed and we've grown to having more than a hundred million events, our queries are a lot slower. We can pay for a bigger database, or spend time engineering our queries to be faster and more efficient. We also looked at moving our data into Google's Bigquery, and using Data Studio, but almost instantly found that would require a whole new set of skills specific to Google's tools.

So we want to know what other small companies (1-5 million a year or so in revenue, maybe?) are doing to track and analyze product metrics. Do you have a homespun solution? Do you drop data in Redshift and query it with a service like Chart.io? Do you just drop it all in your main database and write some queries on an admin page? Do you pay big bucks for a service like Mixpanel?