This demonstration plugin identifies the primary filters that are used by WordPress as it parses your queries.
The objective for writing this plugin was to provide a comprehensive, working demonstration of all the filters and action hooks that a query will pass through on its way to being displayed on your page. Note that this plugin does not attempt to only address the main_query, but will spit out its output for each and every query run on that page. That can be a lot of queries if you have a bunch of plugins and whatnot installed. You have been warned.