Found some info from late 2018, but paywalled and incomplete, focusing on oil wells.

https://news.stanford.edu/2018/08/30/measuring-crude-oils-ca...

https://science.sciencemag.org/content/361/6405/851.summary

Older data from 2013 regarding tar sand production is much worse

https://insideclimatenews.org/news/20130219/oil-sands-mining...

Then, in the end, general refineries have ca 85% energy efficiency for petrol and diesel, discounting other factors.