bug(ui): analytics dashboards take a long time to hydrate/render #597

New issue

Closed

opened 2026-03-28 04:26:12 +00:00 by mfreeman451 · 4 comments

mfreeman451 commented

2026-03-28 04:26:12 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #1853
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1853
Original created: 2025-10-22T16:22:49Z

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

Imported from GitHub. Original GitHub issue: #1853 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1853 Original created: 2025-10-22T16:22:49Z --- **Describe the bug** A clear and concise description of what the bug is. **To Reproduce** Steps to reproduce the behavior: 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. See error **Expected behavior** A clear and concise description of what you expected to happen. **Screenshots** If applicable, add screenshots to help explain your problem. **Desktop (please complete the following information):** - OS: [e.g. iOS] - Browser [e.g. chrome, safari] - Version [e.g. 22] **Smartphone (please complete the following information):** - Device: [e.g. iPhone6] - OS: [e.g. iOS8.1] - Browser [e.g. stock browser, safari] - Version [e.g. 22] **Additional context** Add any other context about the problem here.

mfreeman451 commented

2026-03-28 04:26:12 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433285081
Original created: 2025-10-22T16:42:02Z

Implemented aggregated analytics fetches so the dashboard now executes 10 SRQL calls instead of 22. Counts now come from countIf rollups with tighter limits, plus a vitest adds coverage for the new dataService wiring. Bazel pushed ghcr.io/carverauto/serviceradar-web:sha-a61bd0b57240dc8e7a38c2d08187250d7b85d6d6 and the demo web deployment is updated to that tag.

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433285081 Original created: 2025-10-22T16:42:02Z --- Implemented aggregated analytics fetches so the dashboard now executes 10 SRQL calls instead of 22. Counts now come from countIf rollups with tighter limits, plus a vitest adds coverage for the new dataService wiring. Bazel pushed ghcr.io/carverauto/serviceradar-web:sha-a61bd0b57240dc8e7a38c2d08187250d7b85d6d6 and the demo web deployment is updated to that tag.

mfreeman451 commented

2026-03-28 04:26:13 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433409877
Original created: 2025-10-22T17:20:19Z

Follow-up: reverted the analytics counters to their original SRQL shape (no more countIf) so totals/offline devices line up again, and moved the slow-trace list to a background fetch so the dashboard renders immediately while that query finishes. Bazel rebuilt/pushed ghcr.io/carverauto/serviceradar-web:sha-0f0e530eccbf and the demo deployment is running that digest now.

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433409877 Original created: 2025-10-22T17:20:19Z --- Follow-up: reverted the analytics counters to their original SRQL shape (no more countIf) so totals/offline devices line up again, and moved the slow-trace list to a background fetch so the dashboard renders immediately while that query finishes. Bazel rebuilt/pushed ghcr.io/carverauto/serviceradar-web:sha-0f0e530eccbf and the demo deployment is running that digest now.

mfreeman451 commented

2026-03-28 04:26:13 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433497260
Original created: 2025-10-22T17:44:26Z

Trimmed the remaining duplicate otel_trace_summaries calls by switching to a single stats query that rolls up total/error/slow counts via sum(if(...)). Only the slow-trace list still hits that stream separately (now fetched async), so the dashboard issues 19 primary SRQL queries plus one background fetch. Deployed ghcr.io/carverauto/serviceradar-web:sha-9f6d9b04bebe to demo.

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433497260 Original created: 2025-10-22T17:44:26Z --- Trimmed the remaining duplicate otel_trace_summaries calls by switching to a single stats query that rolls up total/error/slow counts via sum(if(...)). Only the slow-trace list still hits that stream separately (now fetched async), so the dashboard issues 19 primary SRQL queries plus one background fetch. Deployed ghcr.io/carverauto/serviceradar-web:sha-9f6d9b04bebe to demo.

mfreeman451 commented

2026-03-28 04:26:13 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433549679
Original created: 2025-10-22T17:58:13Z

Also consolidated the remaining widget trace counters onto the same aggregated SRQL call (useTraceCounts now parses sum(if(...)) results), so the analytics dashboard only makes a single synchronous request into otel_trace_summaries plus the async slow-trace fetch. Latest demo build: ghcr.io/carverauto/serviceradar-web:sha-71f597e11f8d.

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1853#issuecomment-3433549679 Original created: 2025-10-22T17:58:13Z --- Also consolidated the remaining widget trace counters onto the same aggregated SRQL call (useTraceCounts now parses sum(if(...)) results), so the analytics dashboard only makes a single synchronous request into otel_trace_summaries plus the async slow-trace fetch. Latest demo build: ghcr.io/carverauto/serviceradar-web:sha-71f597e11f8d.