💸 Meet the Cost Center
Sooner or later every platform team gets the same question: "why is the ClickHouse bill so high, and who is causing it?" If you run ClickHouse yourself, you've never had a good answer. Cost visibility was a cloud-console privilege.
Not anymore. CH-UI 2.7.0 ships the Cost Center, a new Pro page that prices your cluster's real consumption straight from system.query_log and system.parts, using your rates, your currency, your teams.
What you get
| 💰 Real compute costs | Measured from actual CPU time per query (OSCPUVirtualTimeMicroseconds), not guesses. You set what a core-hour costs you, CH-UI does the math. |
| 👥 Team chargeback | Map ClickHouse users to teams with exact names or prefix rules like etl_*. Spend nobody claims lands in Unallocated, and an allocation-coverage KPI tells you how trustworthy the report is. |
| 📈 Spend trend by team | Watch which cost center is trending up before the month ends. |
| 🔥 Top cost drivers | Query patterns ranked by total spend. The cheap query that runs fifty thousand times a day finally shows up, and you can open it in the editor with one click. |
| 🗄️ Storage run rate | Cost per table per month from on-disk bytes, with the compression ratio so you can see what ClickHouse is saving you. |
| 🚮 Failed-query cost | The money burned on queries that error out. Nothing motivates fixing a flaky pipeline like a price tag on it. |
| 📤 CSV showback export | Every table exports to CSV, ready to attach to the budget email. |
Cluster-aware out of the box: queries fan out over clusterAllReplicas and fall back to the local node if a replica denies access. If query_log is disabled the page tells you instead of breaking.
60-second start
- Open Cost Center in the sidebar (Pro license required)
- It already works with default rates. Hit the ⚙️ to set your real cost per CPU core-hour and per GB-month, and your currency
- Add your teams and user rules, then watch the Allocated KPI climb toward 100%
Upgrading
Drop-in upgrade from any 2.x: the local database migrates automatically, no config changes, no breaking changes.
# Docker
docker pull ghcr.io/caioricciuti/ch-ui:latest
# Binary (Linux amd64)
curl -L -o ch-ui https://github.com/caioricciuti/ch-ui/releases/download/v2.7.0/ch-ui-linux-amd64
chmod +x ch-ui && sudo install -m 755 ch-ui /usr/local/bin/ch-uiHelm users: chart 0.4.0 in deploy/helm/ch-ui tracks this release.
Verify checksums
sha256sum -c checksums.txtFull changelog: v2.6.2...v2.7.0