As open source columnar databases improve, the cost will drop.
In a well designed scheduler, a task that has been granted an allotment of at least n cores, should never get throttled to less than n cores at any time. It can be limited to less than n cores if CPU utilization is at 100% and another task gets scheduled at the time, since that's unavoidable when you oversubscribe the available resources.
https://docs.kernel.org/accounting/psi.html
I made a Prometheus exporter for it:
rimworld•37m ago