Snap stats page timeouts

[Bret Barker]

Stats pages are timing out for snaps with large numbers of revisions, e.g. nextcloud snap:
  https://dashboard.snapcraft.io/dev/snaps/5207/stats/

Oops here w/query timings:
  https://oops.canonical.com/oops/?oopsid=OOPS-3e81ac927bb3404692a9fa1873fa0671

[Kyle Fazzari (kyrofa)]

The stats are a big plus to snaps. Even more so for heavy users (e.g. Nextcloud). Any ETA on this?

[Bret Barker (noise)]

While this is a great improvement for the vast majority of snaps, it's worth noting stats for the core snap still gets timeouts, or is very near the threshold.

[William Grant (wgrant)]

I think that's going to have to wait for the new stats service. I'm cheating by using index-only scans, but that doesn't change the fact that there are millions of core downloads that have to be processed multiple times. We need to persist aggregates, and doing that in SCA's DB at this point seems like a wast of time.

[Bret Barker (noise)]

Agreed William, just wanted to point it out for anyone who comes across this.