Even more confusingly my query is very simple. I was just trying to see what the latest record in a table was,

... ORDER BY timestamp DESC LIMIT 1;

and that's seems to take unreasonably long and then result in this memory usage exceeded error