In-kernel resource-specific counters are great, but those are limited to 10/60/300 seconds averages.
For historic resource utilization, sar/sadc tool is still a go-to.
For historic resource utilization, sar/sadc tool is still a go-to.
I'm sure someone is already working on integrating information made available in PSI to Kubernetes so that the automation bit is taken care of.