ClickStack Demo Day (2026-08-28) - Log volume for raw SQL in Grafana

In Grafana, a logs query built in the query builder gets a log volume histogram, which is easy enough because the plugin knows the columns ahead of time. A query written in the SQL editor got no histogram at all, and in Explore it got a row-based one capped by the query's LIMIT that didn't follow the selected time range. The plugin now wraps your SQL as a derived table, strips the trailing ORDER BY and LIMIT, and aggregates over the full time range. Dropping the LIMIT is the parsing trick that makes it work, since aggregating inside it would only ever count the rows the query returned. Filters you add in plain SQL are reflected in the histogram, and it follows the time range as you change it. It applies whether you typed the SQL directly or arrived there via "Edit as SQL" from the query builder. Depending on the query, there are likely edge cases where the rewrite won't hold. Part of the ClickStack Demo Day series. See the full post at https://clickhouse.com/docs/use-cases/observability/clickstack/demo-days/2026/2026-08-28