Optimizing Large Time-Range Queries in Grafana (ClickHouse Plugin)

[NikithaPa-Kore]

Hello, team! 👋

I'm new here and asking my first question on the forum — not entirely sure how everything works yet, but here goes! 😅

We're currently using the ClickHouse plugin for Grafana, and I was wondering if there's a way to optimize performance when querying over large time ranges (e.g., 7 days or more).

Specifically, I'm looking to understand if the plugin supports:

Automatically splitting a large query into smaller time-based chunks (like one-day intervals)?

Executing those subqueries in parallel to speed up response times?

Merging the results seamlessly on the Grafana side to provide a unified view?

This kind of chunked execution strategy would significantly improve performance and usability for dashboards handling high-volume datasets.

Is this feature currently supported in the plugin?
If not, is there any known workaround or is it something that's being considered for future development?

Any insights, suggestions, or best practices around this would be greatly appreciated!

Thanks again for your time and support,
Nikitha