Summary

Current period

Total SlowQuery time by sql_digest, sorted by total query time, Top-10

{% for query in digest_statistics.order_by_time[:10] %} {% endfor %}

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
{{ query.Digest }}	{{ '%d' % query.count }}	{{ '%.2f' % query.query_time }}	{{ '%.2f' % query.mem_max }}	{{ '%d' % query.plan_count }}	{{ '%d' % query.index_count }}	{{ query.DB }}	{{ query.table }}

Total SlowQuery count by sql_digest, sorted by count, Top-10

{% for query in digest_statistics.order_by_count[:10] %} {% endfor %}

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
{{ query.Digest }}	{{ '%d' % query.count }}	{{ '%.2f' % query.query_time }}	{{ '%.2f' % query.mem_max }}	{{ '%d' % query.plan_count }}	{{ '%d' % query.index_count }}	{{ query.DB }}	{{ query.table }}

SlowQuery of Plan changes sorted by total query time, Top-10

{% for query in digest_with_multi_plan[:10] %} {% endfor %}

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
{{ query.Digest }}	{{ '%d' % query.count }}	{{ '%.2f' % query.query_time }}	{{ '%.2f' % query.mem_max }}	{{ '%d' % query.plan_count }}	{{ '%d' % query.index_count }}	{{ query.DB }}	{{ query.table }}

SlowQuery of Index changes sorted by total query time, Top-10

{% for query in digest_with_multi_index[:10] %} {% endfor %}

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
{{ query.Digest }}	{{ '%d' % query.count }}	{{ '%.2f' % query.query_time }}	{{ '%.2f' % query.mem_max }}	{{ '%d' % query.plan_count }}	{{ '%d' % query.index_count }}	{{ query.DB }}	{{ query.table }}

Total SlowQuery time by database, sorted by total query time, Top-10

{% for query in database_statistics.order_by_time[:10] %} {% endfor %}

database	query_time
{{ query.DB }}	{{ '%.2f' % query.query_time }}

Total SlowQuery count by database, sorted by count, Top-10

{% for query in database_statistics.order_by_count[:10] %} {% endfor %}

database	query_time
{{ query.DB }}	{{ '%d' % query.count }}

Total SlowQuery time by table, sorted by query time, Top-10

{% for query in table_statistics.order_by_time[:10] %} {% endfor %}

database	table	query_time
{{ query.DB }}	{{ query.table }}	{{ '%.2f' % query.query_time }}

Total SlowQuery count by table, sorted by count, Top-10

{% for query in table_statistics.order_by_count[:10] %} {% endfor %}

database	table	count
{{ query.DB }}	{{ query.table }}	{{ '%d' % query.count }}

SlowQuery with worst execution time, sorted by query_time_std, Top-10

{% for query in worse_digest_stat.order_by_query_time_std[:10] %} {% endfor %}

database	digest	query_time_std	mem_max_std	plan_count
{{ query.DB }}	{{ query.Digest }}	{{ '%.2f' % query.query_time_std }}	{{ '%.2f' % query.mem_max_std }}	{{ '%d' % query.plan_count }}

SlowQuery with worst execution time, sorted by max_mem_std, Top-10

{% for query in worse_digest_stat.order_by_mem_max_std[:10] %} {% endfor %}

database	digest	mem_max_std	query_time_std	plan_count
{{ query.DB }}	{{ query.Digest }}	{{ '%.2f' % query.mem_max_std }}	{{ '%.2f' % query.query_time_std }}	{{ '%d' % query.plan_count }}

SlowQuery with worst execution time, sorted by plan_count, Top-10

{% for query in worse_digest_stat.order_by_plan_count[:10] %} {% endfor %}

database	digest	plan_count	mem_max_std	query_time_std
{{ query.DB }}	{{ query.Digest }}	{{ '%d' % query.plan_count }}	{{ '%.2f' % query.mem_max_std }}	{{ '%.2f' % query.query_time_std }}

Comparison with the previous period

Percentage change in total time: {{ '%.2f' % (query_time_diff.current - query_time_diff.prev) }}/{{ '%.2f' % query_time_diff.prev }} = {{ '%.2f' % ((query_time_diff.current-query_time_diff.prev)/query_time_diff.prev*100)}}%
Percentage change in total count: {{ '%.2f' % (query_count_diff.current - query_count_diff.prev) }}/{{ '%.2f' % query_count_diff.prev }} = {{ '%.2f' % ((query_count_diff.current-query_count_diff.prev)/query_count_diff.prev*100)}}%
Percentage of total time for new slow queries: {{ '%.2f' % new_digest_query_time }}/{{ '%.2f' % query_time_diff.current }} = {{ '%.2f' % (new_digest_query_time/query_time_diff.current*100)}}%
Percentage of total count for new slow queries: {{new_digest | length}}//{{query_count_diff.current}} = {{ '%.2f' % ((new_digest | length) / query_count_diff.current * 100) }}%

Plan Percentage of changes (count): {{ digest_with_plan_diff | length }}/{{ query_count_diff.current }} = {{ '%.2f' % ((digest_with_plan_diff | length) / query_count_diff.current * 100) }}%
Plan Percentage of changes (time): {{ '%.2f' % (digest_with_plan_diff | sum(attribute='query_time')) }}/{{ '%.2f' % query_time_diff.current }} = {{ '%.2f' % ((digest_with_plan_diff | sum(attribute='query_time')) / query_time_diff.current * 100) }}%
Index Percentage of changes (count): {{ digest_with_index_diff | length }}/{{ query_count_diff.current }} = {{ '%.2f' % ((digest_with_index_diff | length) / query_count_diff.current * 100) }}%
Index Percentage of changes (time): {{ '%.2f' % (digest_with_index_diff | sum(attribute='query_time')) }}/{{ '%.2f' % query_time_diff.current }} = {{ '%.2f' % ((digest_with_index_diff | sum(attribute='query_time')) / query_time_diff.current * 100) }}%

Added SlowQuery sorted by total query time, Top-10

{% for query in new_digest[:10] %} {% endfor %}

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
{{ query.Digest }}	{{ '%d' % query.count }}	{{ '%.2f' % query.query_time }}	{{ '%.2f' % query.mem_max }}	{{ '%d' % query.plan_count }}	{{ '%d' % query.index_count }}	{{ query.DB }}	{{ query.table }}

Added Database sorted by total query time, Top-10

{% for query in new_database[:10] %} {% endfor %}

database	query_time
{{ query.DB }}	{{ '%.2f' % query.query_time }}

Added Table sorted by total query time, Top-10

{% for query in new_table[:10] %} {% endfor %}

database	table	query_time
{{ query.DB }}	{{ query.table }}	{{ '%.2f' % query.query_time }}

SlowQuery of Plan changes sorted by total query time, Top-10

{% for query in digest_with_plan_diff[:10] %} {% endfor %}

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
{{ query.Digest }}	{{ '%d' % query.count }}	{{ '%.2f' % query.query_time }}	{{ '%.2f' % query.mem_max }}	{{ '%d' % query.plan_count }}	{{ '%d' % query.index_count }}	{{ query.DB }}	{{ query.table }}

SlowQuery of Index changes sorted by total query time, Top-10

{% for query in digest_with_index_diff[:10] %} {% endfor %}

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
{{ query.Digest }}	{{ '%d' % query.count }}	{{ '%.2f' % query.query_time }}	{{ '%.2f' % query.mem_max }}	{{ '%d' % query.plan_count }}	{{ '%d' % query.index_count }}	{{ query.DB }}	{{ query.table }}