This is the text description for profiler.gif.

This figure shows the Profiler advanced tab.

The Profiler contains the following data results: The Profiler logs the following information:

  • Query class
  • Domain class
  • Total time, total execution time of the query (in milliseconds)
  • Local time, the amount of time spent on the user's workstation (in milliseconds)
  • Number of objects, the total number of objects affected
  • Number of objects handled per second
  • Logging, the amount of time spent printing logging messages (in milliseconds)
  • SQL prepare, the amount of time spent preparing the SQL (in milliseconds)
  • SQL execute, the amount of time spent executing the SQL (in milliseconds)
  • Row fetch, the amount of time spent fetching rows from the database (in milliseconds)
  • Cache, the amount of time spent searching or updating the object cache (in milliseconds)
  • Object build, the amount of time spent building the domain object (in milliseconds)
  • Query prepare, the amount of time spent to prepare the query prior to execution (in milliseconds)
  • SQL generation, the amount of time spent to generate the SQL before it is sent to the database (in milliseconds)