What do you mean by compute power? Smart contracts (which run on-chain code) pay fees for each command they execute. The most popular smart contracts are token exchanges and DeFi (ie crypto backed loans).

Having trouble finding the total smart contract revenue, but this article has examples of the top few, and gives an idea of their usage patterns: https://medium.com/@vikati/ranking-ethereum-smart-contracts-...