ClickHouse-Powered Admin Analytics and Leaderboard Fixes

This release focuses on faster, more reliable administration reporting, along with a couple of important correctness and stability fixes.

Smoother admin reporting with ClickHouse analytics

Administration pipelines, Overview charts, and analytical totals are now served from ClickHouse instead of PostgreSQL reporting tables. This reduces reporting load and helps keep admin pages responsive as data scales.

Charts can now retry independently while reports are preparing, so you are less likely to hit a dead end while waiting for results. Historical data is imported automatically as part of the move.

Fixes and stability updates

Leaderboards now require a public display name or username to be included. This removes repeated anonymous rows, keeps the top ten accurate, and avoids incorrectly labeling someone else as “You” when matching your rank.

Operational recovery is now safer when worker state is missing, reducing the chance of recovery actions failing due to absent or incomplete state.

Upgrade notes

If you self-host, review the analytics rollout guide before updating. You will need to complete the required migrations, deploy the new applications, drain older processes, and run the historical importer in the recommended order.