How to see override functions and template files in use for any part of the drupal site?
You are thinking about the Theme Developer module.  When you install and enable, it you can click on just about any properly rendered element and see


Preprocess and process function candidates
Theme function candidates
Template file suggestions


Just keep in mind that it can interfere with some themes, and doesn't work well in some versions of IE.