Ha. That’s just a once off calculation from beginning of time. I can easily do delta updates from there.
It’s a shared 4 vCPU 8GB. And it’s running other workloads.
For my pubkey it was seconds. @jack is an outlier for sure.
With roll up the query goes from 400ms to like 1.5ms with hourly resolution.