Diagnostics

Speedy's diagnostics help reveal potential bottlenecks in your template code. The total queries executed and the processing time for each {exp:speedy:fragment} and {exp:speedy:static} tag will be recorded and made available through Speedy's control panel settings page for future inspection. Caching may help hide slow performing pages, but the captured diagnostics can be used to help you identify and optimize bottlenecks.

You can disable diagnostics entirely by adding this to your config file:

$config['speedy_diagnostics_enabled'] = 'no';

If you want a detailed list of all queries performed in each cache item you can add this to your config file. By default the diganostics will only record the key, query count, and execution time.

$config['speedy_diagnostics_save_queries'] = 'yes';

Viewing the diagnostics detail will list out all of the queries, along with their execution time, performed while generating that cache item. Run the queries individually in an external tool such as MySQL Workbench or Sequel Ace to further analyze the query.

There is even a home page widget listing out the top 10 slowest cache items.