[GENERAL] Memory consumption for Query

Let's say for following query how to calculate memory consumption.

select * from test where id=1;