That's expensive! How much are 24 CPU minutes on the instance you are using? Charge it in sats and people would still want it.
Discussion
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.
I can easily halve it too as a chunk of double handling.