Monitoring Running Queries

[John Leach]

Is there a UI, command line, or logging level to see the internal execution of 
the query?  I am trying to understand how much time is spent in each phase 
(Join, Aggregation, Etc.) of a multi-phase execution tree?

Regards,
John Leach