> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://fastpix.com/docs/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://fastpix.com/docs/_mcp/server.

# Faster timeseries, breakdown, and list-of-views queries

> Query and storage optimizations across timeseries, breakdown, list-of-views, and errors endpoints — the biggest wins land on the surfaces dashboards hit most often.

We have rolled out a set of query and storage optimizations across the metrics service. The biggest wins are on the endpoints customers hit most often from dashboards and BI integrations.

Improvements include:

* **Optimized timeseries query** — the timeseries path has been rewritten to push more work into Pinot, reducing the volume of data shipped back to the API tier.
* **Optimized breakdown and overall queries** — the breakdown, overall, and overview endpoints use a new query shape with `is_final` semantics that skips redundant scans of in-progress sessions.
* **Optimized list-of-views and top-content** — list-of-views and top-content queries have been restructured to use indexed columns and produce results faster on large catalogs.
* **Optimized errors APIs** — error timeseries and breakdown endpoints use the same optimized pattern, fixing both speed and correctness for total-views counts in error views.
* **Pinot tuning** — UTF-8 handling and table-level configuration changes mean fewer fallbacks to slow paths on multi-byte titles and metadata.

No client changes are required. Existing queries will simply respond faster, with the largest gains on long time ranges and high-cardinality breakdowns.