Summary

Current period

Percentage of total time for new slow queries： {{ '%.2f' % query_time_statistics.fresh_digest }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.fresh_digest / query_time_statistics.total * 100) }}%
Percentage of total time for the database: {{ '%.2f' % query_time_statistics.fresh_database }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.fresh_database / query_time_statistics.total * 100) }}%
Percentage of total time for the new table: {{ '%.2f' % query_time_statistics.fresh_table }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.fresh_table / query_time_statistics.total * 100) }}%
Percentage of total time for plan changes: {{ '%.2f' % query_time_statistics.multi_plan_digest }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.multi_plan_digest / query_time_statistics.total * 100) }}%
Plan Percentage of changes: {{ query_statistics.multi_plan_digest_count }}/{{ query_statistics.digest_count }} = {{ '%.2f' % (query_statistics.multi_plan_digest_count/query_statistics.digest_count*100) }}%
Percentage of total time for index changes: {{ '%.2f' % query_time_statistics.multi_index_digest }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.multi_index_digest / query_time_statistics.total * 100) }}%
Index Percentage of changes: {{ query_statistics.multi_index_digest_count }}/{{ query_statistics.digest_count }} = {{ '%.2f' % (query_statistics.multi_index_digest_count/query_statistics.digest_count*100) }}%
Percentage of total time for internal SQL: {{ '%.2f' % query_time_statistics.internal }}/{{ '%.2f' % (query_time_statistics.total+query_time_statistics.internal) }} = {{ '%.2f' % (query_time_statistics.internal / (query_time_statistics.total+query_time_statistics.internal) * 100) }}%
Percentage of internal SQL: {{ query_statistics.internal_count }}/{{ query_statistics.query_count + query_statistics.internal_count}} = {{ '%.2f' % (query_statistics.internal_count/(query_statistics.query_count+query_statistics.internal_count)*100) }}%
Percentage of total time for the execution at TiKV: {{ '%.2f' % query_time_statistics.execution_at_tikv }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.execution_at_tikv / query_time_statistics.total * 100) }}%
Percentage of execution at TiKV: {{ query_statistics.tikv_query_count }}/{{ query_statistics.query_count }} = {{ '%.2f' % (query_statistics.tikv_query_count / query_statistics.query_count * 100) }}%
Percentage of total time for the execution at TiFlash: {{ '%.2f' % query_time_statistics.execution_at_tiflash }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.execution_at_tiflash / query_time_statistics.total * 100) }}%
Percentage of execution at TiFlash: {{ query_statistics.tiflash_query_count }}/{{ query_statistics.query_count }} = {{ '%.2f' % (query_statistics.tiflash_query_count / query_statistics.query_count * 100) }}%
Percentage of total time for the mixed execution: {{ '%.2f' % query_time_statistics.execution_mixed }}/{{ '%.2f' % query_time_statistics.total }} = {{ '%.2f' % (query_time_statistics.execution_mixed / query_time_statistics.total * 100) }}%
Percentage of execution at mixed execution: {{ query_statistics.mixed_query_count }}/{{ query_statistics.query_count }} = {{ '%.2f' % (query_statistics.mixed_query_count / query_statistics.query_count * 100) }}%
Total Time by Database, Top-3：
1. {{stat.DB}}: {{'%.2f' % stat.query_time}}s
Total Count by Database, Top-3：
1. {{stat.DB}}: {{'%d' % stat.count}}
Total Time by Table, Top-3：
1. {{ stat.DB }}:{{ stat.table }}: {{ '%.2f' % stat.query_time }}s
Total Count by Table, Top-3：
1. {{ stat.DB }}:{{ stat.table }}: {{ '%d' % stat.count }}

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) }}%
Percentage of total time for new Database: {{ '%.2f' % new_database_query_time }}/{{ '%.2f' % query_time_diff.current }} = {{ '%.2f' % (new_database_query_time/query_time_diff.current*100)}}%
Percentage of total count for new Database: {{new_database_query_count}}//{{query_count_diff.current}} = {{ '%.2f' % (new_database_query_count / query_count_diff.current * 100) }}%
Changes in the stock of SlowQuery
1. 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) }}%
2. 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) }}%
3. 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) }}%
4. 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) }}%

Detail

Current period

Added SlowQuery sorted by total query time

{% for query in new_digest_current[:20] %} {% 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

{% for query in new_database_current[:20] %} {% endfor %}

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

Added Table sorted by total query time

{% for query in new_table_current[:20] %} {% endfor %}

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

SlowQuery of Plan changes sorted by total query time

{% for query in digest_with_multi_plan[:20] %} {% 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

{% for query in digest_with_multi_index[:20] %} {% 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 }}

Internal SlowQuery sorted by total query time

{% for query in internal_digests[:20] %} {% 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 executed on TiKV sorted by total query time

{% for query in digests_on_tikv[:20] %} {% 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 executed on TiFlash sorted by total query time

{% for query in digests_on_tiflash[:20] %} {% 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 executed in a mix of TiKV and TiFlash sorted by total query time

{% for query in digests_on_tikv_and_tiflash[:20] %} {% 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

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

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

Total SlowQuery count by database, sorted by count

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

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

Total SlowQuery time by table, sorted by query time

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

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

Total SlowQuery count by table, sorted by count

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

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

Total SlowQuery time by sql_digest, sorted by total query time

{% for query in digest_statistics.order_by_time[:20] %} {% 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

{% for query in digest_statistics.order_by_count[:20] %} {% 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 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 }}

{% if data_range_days > 0 %}

AD-HOC SlowQuery on TiKV sorted by total query time

{% for query in ad_hoc_digests_on_tikv[:20] %} {% 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 }}

{% endif %}

Comparison with the previous period

Added SlowQuery sorted by total query time

{% for query in new_digest[:20] %} {% 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

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

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

Added Table sorted by total query time

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

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

SlowQuery of Plan changes sorted by total query time

{% for query in digest_with_plan_diff[:20] %} {% 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

{% for query in digest_with_index_diff[:20] %} {% 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 }}