Viewers Without BordersReal-Time Foreground Concurrency
CLICKHOUSE CLOUD

SONYLIV · CLICK-A-THON 2026

Who is actually watching?

Minute-level audience truth with background, pause, heartbeat-loss and late-arrival periods removed.

MODEL State-gated intervals 40s heartbeat · 60s buckets · exact distinct
Filters0 active

Every delivered dimension—and newly discovered map key—is filterable. Options load lazily from compact interval/catalog tables.

Peak concurrency

Select a range

Average concurrency

weighted across displayed minutes

Viewer-minutes

foreground time only

ClickHouse latency

waiting for query

FULL CURVE

Foreground concurrency

accurate stateless naive peak drag across the chart to zoom
CLICKHOUSE EXECUTIONExact query work, enriched asynchronously from system.query_log

Run an analysis to capture ClickHouse execution evidence.

TOP SEGMENTS

Peak breakdown

Run a query to see the breakdown.

CLICKHOUSE EXECUTIONIndependent exact breakdown query

Waiting for breakdown query.

AUDIENCE RHYTHM

Hour-of-day heatmap

Minute or hour results become a UTC activity heatmap.

CLICKHOUSE SOURCEBrowser-derived from the exact foreground curve response

Waiting for source query.

JUDGE MODE

Trace the answer

01Raw events
02Clean + state gatequarantine invalid rows
03Active intervals
04Hour-clipped deltasfast exact serving
05Dashboardparameterized, read-only
Query pathRunsMedianp95Rows readPeak memory
Run the dashboard, then refresh evidence.