Not going to disclose that but you can make a guess on % if you analyze the S3 write/read ops a ClickHouse server does with regular or compact parts in a simple table (with a few columns) writing once per second
I don't think is going to happen often, but definitely happens. We see that more than anyone would do because we run a lot of different workload types, any possible combination of types/sql/engines...
Running postgres in my previous company we saw a few of them as well and I'd consider postgres a "production grade" system.
We found a way to organize large SQL decomposing them in smaller chunks and organize those chunks like in a "jupiter notebook" so you also see results for intermediate results, an example:
Dark mode is very useful for people with "eye problems", for example, eye floaters are small black points you see all the time, they usually appear with the age, dark mode make them "disapear" making you brain happier.