"Estar echo polvo" is used when you are tired of something you have done. For example, you have done a very long race, after the race use "estoy hecho polvo".
Oral expressions must be interpreted figuratively, not literally.
5.8m questions
7.6m answers