Performance issues with grafana loki after upgraded to version 3.x

[Pawan Kamboj]

After upgrading to 3.0(enable TSDB) we are facing performance issues with loki. Queries are taking lots of time to complete. Any help/config which can help to improve the query time.

Setup Details:
Loki Version: 3.1
Deployment Type: Loki Distributed
Ingesters: 7
Distributor: 7
index gateway: 3
Querier - autoscale
Frontend - autoscale
Scheduler - 5 

Chunk/result cache - 3 each

Also raised on slack channel

https://grafana.slack.com/archives/CEPJRLQNL/p1721371923587599

Loki Configuration: