If interested in details like this, this book [1] is amazing. I'm not sure every programmer needs to dig this deep, but it has been handy to know some of these details for systems engineering/sre work. It's a very thorough book but I think he is very pragmatic in the way he discusses the topics. It's definitely in my top 5 of comp sci books.
[1] http://www.brendangregg.com/blog/2020-07-15/systems-performa...