Analytics And Event Tracking With Clickhouse Time Series Database

via “dashboard and analytics with clickhouse aggregations”

Open-source LLM observability — tracing, prompt management, evaluation, cost tracking, self-hosted.

Unique: Materialized views in ClickHouse pre-compute aggregations incrementally as new events arrive, enabling sub-second dashboard queries without full-table scans. Dashboards support drill-down to PostgreSQL traces via foreign key relationships.

vs others: Faster than Grafana or Tableau for LLM metrics because ClickHouse columnar storage is optimized for time-series aggregations, and materialized views eliminate the need for on-demand aggregation computation, whereas external BI tools would require exporting data and building custom dashboards.