The Report Profiler displays a report on all the sites and lists queried by an instance of a report, including how long individual sites and lists take to query. This can assist you when you are trying to improve the performance of a report. The information displayed in the Report Profiler report includes site level and list level data.
To run the Report Profiler:
Click Configure Reporter Settings in the Reporter ribbon to open the Reporter Settings page.
Expand the Rendering and Performance section.
Select Enable under Report Profiler, then click OK.
Click Show Report Profiler on the report.
The Report Profiler is not available when Project Cache or Work Cache is selected as a Data Source. Report Profiler is also not available when Retention Duration is enabled.
The information displayed about the sites processed by the report includes:
Site - the site name.
URL - the site collection-relative URL to the site (this is also a link)
Time (ms) - the amount of time in milliseconds it took to query the site
The time taken to process the site will always be more than the sum of the time it took to query the lists in the site, as the total includes the time taken to process the site itself.
#Lists Matched - the number of lists queried in the site (if a site is excluded, this will be 0)
Site Filters - which web filters were run against the site and, if one excluded the site, which one it was