Yakko Majuri

Yup let's look at it then and discuss the best way to shift the interval - I have a solution but it's a bit messy. As for "benchmarking", I'll take...

A lot of progress! Query is simpler now and _most_ tests pass (compared to none earlier!) Seems something is off for WAU but all MAU tests are passing. Will dig...

Ok I know what the problem is - just need to find a way to fix it

So there's a few tricky things here which I'll be working on today. Mostly it's about rounding to the nearest week/month stuff. There are a few complications with deriving buckets...

Good and bad news about the query exactly as is The good news is that this is potentially up to 10x faster for most cases (while using less memory). Here's...

Although to be fair the 720 buckets sometimes doesn't even complete with the old query

Did some benchmarking and not sure this query will cut it. Its speed and memory usage depend both on the number of buckets (which we have more control over, see...

Final benchmark clearing page cache each time. Above green means the new query is better, red means it's worse, and yellow means it's better but wouldn't actually complete due to...

Should I merge @macobo ?

Hey @ilovefreesw! Try setting `CLICKHOUSE_SECURE=False` and see if that works