Did you try Mimir or VictoriaMetrics additionally to Thanos? Probably, they use less resources and work faster than Thanos for your workload.