OSS Trino, and vendors such as Starburst, usually leverage CPU utilization as the determining fractor to scale up/down instead of memory. This article talks a bit about this approach; https://medium.com/bestsecret-tech/maximize-performance-the-bestsecret-to-scaling-trino-clusters-with-keda-c209efe4a081