{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "8888724d-5538-4311-8796-3701682da427", "metadata": { "tags": [], "ExecuteTime": { "end_time": "2024-01-17T07:45:22.885662Z", "start_time": "2024-01-17T07:45:22.416211Z" } }, "outputs": [], "source": [ "from IPython.display import display, HTML\n", "from analyzer import SlowlogAnalyzer, SlowlogComparator, render_html" ] }, { "cell_type": "code", "execution_count": 2, "id": "3c771f3b-11fd-4d24-87cf-21aa85a89f65", "metadata": { "tags": [], "ExecuteTime": { "end_time": "2024-01-17T07:53:05.013456Z", "start_time": "2024-01-17T07:45:24.780710Z" } }, "outputs": [ { "data": { "text/plain": "", "text/html": "\n\n Slow Query Report\n \n\n\n

Summary

Current period

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

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	55707	271867.80	20567884.00	2	2	dh_app_5252	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	14425	67944.12	7809704.00	2	2	dh_app_5065	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	12455	64295.32	876868.00	3	3	dh_app_5381	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	9844	54475.61	111572.00	2	2	dh_app_5381	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	4921	33229.64	776044.00	2	2	dh_app_5376	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	4449	30335.43	116324.00	2	2	dh_app_5012	dh_active_receive_logs
4ad1c3379474776c47e11699e39237d83f82b3a2693b9068a4b6984e55569302	5611	27316.22	1245700.00	1	1	dh_app_5381	dh_active_receive_logs
9505cacb7c710ed17125fcc6cb3669e8ddca6c8cd8af6a31f6b3cd64604c3098	6270	25719.48	90112.00	1	1	dh_app_5376
a37cfae39f75ddac1eea5d8b0ef5ece32e1e5a68fc51bf8dec284d07a7c49b98	1288	20992.62	42976.00	1	1	dh_app_5021	dh_active_word_profit;dh_active_word_profit
77f10c86e21cb52c123ba0c7b3f0642136051351f4bc59a637290ffdc20b3678	2619	20151.24	889508.00	2	2	dh_app_5376	dh_promote_myteam_detail

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

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	55707	271867.80	20567884.00	2	2	dh_app_5252	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	14425	67944.12	7809704.00	2	2	dh_app_5065	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	12455	64295.32	876868.00	3	3	dh_app_5381	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	9844	54475.61	111572.00	2	2	dh_app_5381	dh_active_receive_logs
9505cacb7c710ed17125fcc6cb3669e8ddca6c8cd8af6a31f6b3cd64604c3098	6270	25719.48	90112.00	1	1	dh_app_5376
4ad1c3379474776c47e11699e39237d83f82b3a2693b9068a4b6984e55569302	5611	27316.22	1245700.00	1	1	dh_app_5381	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	4921	33229.64	776044.00	2	2	dh_app_5376	dh_active_receive_logs
9505cacb7c710ed17125fcc6cb3669e8ddca6c8cd8af6a31f6b3cd64604c3098	4781	17349.75	2088960.00	1	1	dh_app_5033
9505cacb7c710ed17125fcc6cb3669e8ddca6c8cd8af6a31f6b3cd64604c3098	4622	16256.53	40960.00	1	1	dh_app_5377
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	4449	30335.43	116324.00	2	2	dh_app_5012	dh_active_receive_logs

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

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	55707	271867.80	20567884.00	2	2	dh_app_5252	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	14425	67944.12	7809704.00	2	2	dh_app_5065	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	12455	64295.32	876868.00	3	3	dh_app_5381	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	9844	54475.61	111572.00	2	2	dh_app_5381	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	4921	33229.64	776044.00	2	2	dh_app_5376	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	4449	30335.43	116324.00	2	2	dh_app_5012	dh_active_receive_logs
77f10c86e21cb52c123ba0c7b3f0642136051351f4bc59a637290ffdc20b3678	2619	20151.24	889508.00	2	2	dh_app_5376	dh_promote_myteam_detail
decaf2d4697bd3b01cf67fe59889877f807dccaa87b16596a97581e5c0782560	723	13925.29	3193616.00	4	1	dh_app_5017	dh_account_basic;dh_account_ext_authinfo;dh_account_ext_financeinfo;dh_account_ext_promoteinfo;dh_account_ext_logininfo;dh_account_ext_yuebaoinfo;dh_finance_first_pay;dh_account_basic
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	1799	12345.23	485252.00	2	2	dh_app_5301	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	3762	10106.03	2242948.00	2	2	dh_app_5386	dh_active_receive_logs

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

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	55707	271867.80	20567884.00	2	2	dh_app_5252	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	14425	67944.12	7809704.00	2	2	dh_app_5065	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	12455	64295.32	876868.00	3	3	dh_app_5381	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	9844	54475.61	111572.00	2	2	dh_app_5381	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	4921	33229.64	776044.00	2	2	dh_app_5376	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	4449	30335.43	116324.00	2	2	dh_app_5012	dh_active_receive_logs
77f10c86e21cb52c123ba0c7b3f0642136051351f4bc59a637290ffdc20b3678	2619	20151.24	889508.00	2	2	dh_app_5376	dh_promote_myteam_detail
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	1799	12345.23	485252.00	2	2	dh_app_5301	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	3762	10106.03	2242948.00	2	2	dh_app_5386	dh_active_receive_logs
e3d5f3a28dd0f89485341dcb8a7953e16bce768a267b3257289b46b1d847d759	3644	9762.87	1352416.00	2	2	dh_app_5252	dh_active_receive_logs

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

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

database	query_time
information_schema	928853.13
dh_app_5252	324426.09
dh_app_5381	165892.26
dh_app_5376	91837.65
dh_app_5065	90939.20
dh_app_5033	66059.08
dh_app_5012	57171.48
dh_app_5017	54373.83
dh_app_681	50166.78
dh_app_5016	44393.22

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

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

database	query_time
dh_app_5252	70648
dh_app_5381	33492
dh_app_5065	19279
dh_app_5376	17173
dh_app_5033	12663
dh_app_5386	12280
dh_app_5012	9171
dh_app_5377	7936
dh_app_5251	7455
dh_app_702	6771

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

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

database	table	query_time
dh_app_5252	dh_active_receive_logs	289100.33
dh_app_5381	dh_active_receive_logs	146586.89
dh_app_5065	dh_active_receive_logs	83355.86
dh_app_5017	dh_account_basic	42674.21
dh_app_5376	dh_active_receive_logs	35393.63
dh_app_5012	dh_active_receive_logs	30712.32
dh_app_681	dh_active_receive_logs	29459.14
dh_app_5376	dh_promote_myteam_detail	22600.43
dh_app_5016	dh_account_basic	22116.88
dh_app_5021	dh_active_word_profit	20998.82

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

database	table	count
dh_app_5252	dh_active_receive_logs	62136
dh_app_5381	dh_active_receive_logs	28014
dh_app_5065	dh_active_receive_logs	17924
dh_app_5376	dh_active_receive_logs	5239
dh_app_5386	dh_active_receive_logs	5155
dh_app_5012	dh_active_receive_logs	4516
dh_app_681	dh_active_receive_logs	4088
dh_app_702	dh_user_withdraw_order	3508
dh_app_5376	dh_promote_myteam_detail	3489
dh_app_702	dh_finance_order_count	3346

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

database	digest	query_time_std	mem_max_std	plan_count
dh_app_5121	a196c73ee9e3b91090603777a6ec2d8cb86e69c4487237b190d5da41bd83b167	43.05	1515262.37	2
dh_app_722	9491b7bbd2a0c046e984a2f7cd0f7fc1e57ef72c3dd064a984023ef6d98aa045	30.16	1527807.58	2
dh_app_5033	5b5a869cdda4286578b219b3dcdcd4c9033234f330ee34a6b29c11d52e944d25	29.83	192105.14	2
dh_app_272	d2cbd246eeff10431396c103518f9e63a62374521ab6bf388835d044f65dee6f	23.43	160729.33	2
dh_app_5251	b3c06a32ea8fd4bfb777e764d2bc4a18eec28c7eaa57c3af1509c30e5e739db6	20.42	875155.96	2
dh_app_5096	d2cbd246eeff10431396c103518f9e63a62374521ab6bf388835d044f65dee6f	19.62	32328.42	2
dh_app_5033	3f749bab32d6204dae90917d147d02cb2f84a255515e75565a4d3a0563aa83d8	19.52	18770288.23	2
dh_app_5038	5b5a869cdda4286578b219b3dcdcd4c9033234f330ee34a6b29c11d52e944d25	18.94	1191673.97	5
dh_app_680	f5cb6530d6dc90d679b4ac0c3dbb4d6caa31395333e6f5fefbc35a919c95c337	18.19	71585.00	2
dh_app_5068	d2cbd246eeff10431396c103518f9e63a62374521ab6bf388835d044f65dee6f	17.65	150829.42	2

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

database	digest	mem_max_std	query_time_std	plan_count
dh_app_5033	9491b7bbd2a0c046e984a2f7cd0f7fc1e57ef72c3dd064a984023ef6d98aa045	326942826.54	12.20	2
dh_app_5065	33769fe254627b498a5d0bdbeca312dcca17764d582eaf88a54cc0437c3807a2	21074512.03	0.59	2
dh_app_5251	9491b7bbd2a0c046e984a2f7cd0f7fc1e57ef72c3dd064a984023ef6d98aa045	20443596.29	1.46	3
dh_app_5033	3f749bab32d6204dae90917d147d02cb2f84a255515e75565a4d3a0563aa83d8	18770288.23	19.52	2
dh_app_5033	1963eabb8b53c2c39c556e0d5a74e33b5bc27ac40939955606f31765f11f4072	14706547.26	8.60	2
dh_app_5252	3f749bab32d6204dae90917d147d02cb2f84a255515e75565a4d3a0563aa83d8	14079372.65	5.47	2
dh_app_5377	9491b7bbd2a0c046e984a2f7cd0f7fc1e57ef72c3dd064a984023ef6d98aa045	13435774.67	3.50	2
dh_app_5251	5b5a869cdda4286578b219b3dcdcd4c9033234f330ee34a6b29c11d52e944d25	12530171.81	10.60	4
dh_app_5381	7e8b766d52ec9ac20473d5ab7b82408d06ac6276e69766227b0ef5bec9442e61	11844731.27	0.60	2
dh_app_681	0ae4c51dbc6df6b2fca664de1fbf45863d8e043f90c6487c6b9440a769e8af53	11076658.02	2.26	2

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

database	digest	plan_count	mem_max_std	query_time_std
dh_app_5386	0029d3910d26f8aed08a2c113a31b7a1b240f5eff2c380b4360088cd342e03dc	9	3106955.79	0.71
go_biz_backstage	9176f3fb9123657e7f0510c0b32238e968f484e32d45b7cdfdb6a4fa24cd38cd	9	532557.64	0.53
dh_app_5136	decaf2d4697bd3b01cf67fe59889877f807dccaa87b16596a97581e5c0782560	7	156631.00	4.44
dh_app_651	32169075d1ff9e2757fd4db87ff6f0cc267ca262d12319af332d15dcbae78a20	6	1082651.48	1.16
dh_app_5119	decaf2d4697bd3b01cf67fe59889877f807dccaa87b16596a97581e5c0782560	6	304570.37	4.22
dh_app_5376	b2e948679e977640c0da87ef627cf5b6e303fb6457b3d9245d5c45c3861ee804	6	235.51	0.76
dh_app_5091	e875e74d098eb6f271fa391059f9ed61358fd0d95f0077236003396ed8ed5c08	5	350.34	0.92
dh_app_5118	5b5a869cdda4286578b219b3dcdcd4c9033234f330ee34a6b29c11d52e944d25	5	2390507.95	8.48
dh_app_5118	2b15fdbfff4120691df3332b24c4f780a9579c9fd9c603841d68f6c6089391da	5	383.55	0.23
dh_app_5252	afbfd61a2199a04b07aa0826a35c871681d61f133bcd62eebe354d9c4f5e4943	5	745122.50	11.47

Comparison with the previous period

\n Percentage change in total time: 1579136.63/1516655.49 =\n 104.12%\n
\n Percentage change in total count: 190383.00/218548.00 =\n 87.11%\n
\n Percentage of total time for new slow queries: 616674.46/3095792.13 =\n 19.92%\n
\n Percentage of total count for new slow queries: 15930//408931 =\n 3.90%\n

\n Plan Percentage of changes (count):\n 818/408931 =\n 0.20%\n
\n Plan Percentage of changes (time):\n 51227.48/3095792.13 =\n 1.65%\n
\n Index Percentage of changes (count):\n 509/408931 =\n 0.12%\n
\n Index Percentage of changes (time):\n 19463.82/3095792.13 =\n 0.63%\n

Added SlowQuery sorted by total query time, Top-10

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	12455	64295.32	876868.00	3	3	dh_app_5381	dh_active_receive_logs
1b8b6c97e94c3f02bf5725e477fbec79cc9cb5b286540c645ddcf387908cd41c	9844	54475.61	111572.00	2	2	dh_app_5381	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	4921	33229.64	776044.00	2	2	dh_app_5376	dh_active_receive_logs
4ad1c3379474776c47e11699e39237d83f82b3a2693b9068a4b6984e55569302	5611	27316.22	1245700.00	1	1	dh_app_5381	dh_active_receive_logs
8b377a3e3cf7efc25f1fbfd16938a0e8716c2dabfd6a3e4c72d881041711c14c	1799	12345.23	485252.00	2	2	dh_app_5301	dh_active_receive_logs
9505cacb7c710ed17125fcc6cb3669e8ddca6c8cd8af6a31f6b3cd64604c3098	3051	10571.27	1564672.00	1	1	dh_app_5381
0e94d650cc21889cfd6d2909da8dc3fee37946fdec596bd4383f206307d3704f	1981	9579.18	17704214.00	1	1	dh_app_5016	dh_user_withdraw_order;dh_withdraw_ip_count;dh_finance_order_count
cd14fba6375c0972372076ce64362af9c7e959e248775f0d1250ec47ae1d7396	1186	6872.96	4040925.00	1	1	dh_app_5051	dh_user_withdraw_order;dh_withdraw_ip_count;dh_finance_order_count
69880eb65a2718f89a8c1848a328f257c3f35158dc0dde872388d0efd2fe4584	1271	6370.87	13285976.00	2	2	dh_app_702	dh_user_withdraw_order;dh_withdraw_ip_count;dh_finance_order_count
66d5464f15cf3e27327d9ad9e9388832e194eab5bb567789f194506ade38c983	28	5308.59	769239790.00	1	1	information_schema

Added Database sorted by total query time, Top-10

\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

database	query_time
dh_app_5393	6.21
dh_app_5395	6.20
dh_app_5396	4.62

Added Table sorted by total query time, Top-10

database	table	query_time
dh_app_5381	dh_active_receive_logs	146586.89
dh_app_5325	dh_game_record	4401.46
dh_app_5252	dh_game_record	3463.60
dh_app_5323	dh_game_record	3242.08
dh_app_5321	dh_game_record	2555.26
dh_app_5265	dh_user_withdraw_order	2367.71
dh_app_5265	dh_finance_order_count	2357.29
dh_app_5265	dh_withdraw_ip_count	2357.29
dh_app_5335	dh_active_discount_log	1659.38
dh_app_5228	dh_game_record	1646.77

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

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
77f10c86e21cb52c123ba0c7b3f0642136051351f4bc59a637290ffdc20b3678	618	4608.26	889508.00	1	1	dh_app_5376	dh_promote_myteam_detail
decaf2d4697bd3b01cf67fe59889877f807dccaa87b16596a97581e5c0782560	163	3237.56	2948824.00	3	1	dh_app_5013	dh_account_basic;dh_account_ext_authinfo;dh_account_ext_financeinfo;dh_account_ext_promoteinfo;dh_account_ext_logininfo;dh_account_ext_yuebaoinfo;dh_finance_first_pay;dh_account_basic
5b5a869cdda4286578b219b3dcdcd4c9033234f330ee34a6b29c11d52e944d25	101	2211.90	14166760.00	2	2	dh_app_5038	dh_promote_agent_report;dh_promote_myteam_summary;dh_account_basic
32169075d1ff9e2757fd4db87ff6f0cc267ca262d12319af332d15dcbae78a20	277	1686.93	14028557.00	5	5	dh_app_651	dh_message_setting;dh_message_setting_ext;dh_message_logs;dh_message_setting_currency;dh_message_setting_lang;dh_message_setting_ext_language
3f749bab32d6204dae90917d147d02cb2f84a255515e75565a4d3a0563aa83d8	21	1357.99	25505688.00	1	1	dh_app_5033	dh_promote_agent_report
decaf2d4697bd3b01cf67fe59889877f807dccaa87b16596a97581e5c0782560	86	1239.21	2612536.00	2	1	dh_app_673	dh_account_basic;dh_account_ext_authinfo;dh_account_ext_financeinfo;dh_account_ext_promoteinfo;dh_account_ext_logininfo;dh_account_ext_yuebaoinfo;dh_finance_first_pay;dh_account_basic
decaf2d4697bd3b01cf67fe59889877f807dccaa87b16596a97581e5c0782560	81	1138.22	1785380.00	3	1	dh_app_658	dh_account_basic;dh_account_ext_authinfo;dh_account_ext_financeinfo;dh_account_ext_promoteinfo;dh_account_ext_logininfo;dh_account_ext_yuebaoinfo;dh_finance_first_pay;dh_account_basic
241eb78b3dae0afe7e5e5ed6c98b37c348947232eb1d8d1acaa0b65e2eef07ad	63	935.45	1701805.00	2	1	dh_app_630	dh_account_basic;dh_account_ext_authinfo;dh_account_ext_financeinfo;dh_account_ext_promoteinfo;dh_account_ext_logininfo;dh_account_ext_yuebaoinfo;dh_finance_first_pay;dh_account_basic
9176f3fb9123657e7f0510c0b32238e968f484e32d45b7cdfdb6a4fa24cd38cd	273	851.82	18415075.00	8	1	go_biz_backstage	dh_translate_lang;dh_translate
decaf2d4697bd3b01cf67fe59889877f807dccaa87b16596a97581e5c0782560	38	707.81	2237047.00	3	1	dh_app_5036	dh_account_basic;dh_account_ext_authinfo;dh_account_ext_financeinfo;dh_account_ext_promoteinfo;dh_account_ext_logininfo;dh_account_ext_yuebaoinfo;dh_finance_first_pay;dh_account_basic

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

sql_digest	count	query_time	mem_max	plan_count	index_count	database	table
77f10c86e21cb52c123ba0c7b3f0642136051351f4bc59a637290ffdc20b3678	618	4608.26	889508.00	1	1	dh_app_5376	dh_promote_myteam_detail
3f749bab32d6204dae90917d147d02cb2f84a255515e75565a4d3a0563aa83d8	21	1357.99	25505688.00	1	1	dh_app_5033	dh_promote_agent_report
d2cbd246eeff10431396c103518f9e63a62374521ab6bf388835d044f65dee6f	168	535.93	17691804.00	1	1	dh_app_5065	dh_active_details;dh_account_ext_financeinfo
32169075d1ff9e2757fd4db87ff6f0cc267ca262d12319af332d15dcbae78a20	60	412.79	14028557.00	4	4	dh_app_651	dh_message_setting;dh_message_setting_ext;dh_message_logs;dh_message_setting_currency;dh_message_setting_lang;dh_message_setting_ext_language
afbfd61a2199a04b07aa0826a35c871681d61f133bcd62eebe354d9c4f5e4943	169	393.83	35309837.00	4	2	dh_app_5252	dh_promote_myteam_detail;dh_promote_agent_report
2c4defdf92dbed08aa5afb59e0ab023fb905c087903ad8c1222447eca9225461	46	357.92	103632.00	1	1	dh_app_5386	dh_order_summary
3f749bab32d6204dae90917d147d02cb2f84a255515e75565a4d3a0563aa83d8	16	353.56	1714958304.00	1	1	dh_app_5252	dh_promote_agent_report
c4a60fedcd0f8f74c3ca087c1c3b601b76aace2d01aa456a57a85a7c267c5474	26	345.96	5019750.00	1	1	dh_app_5038	dh_promote_agent_report;dh_promote_myteam_summary
6f4b7911d7468d9f812e8d1eb366352d4f0f9fa4fb46c22296beecdf941e1a98	18	258.68	19752.00	1	1	dh_app_5072	dh_account_basic;dh_account_ext_financeinfo
5974254c144b71ac77f3b44570d0506df55210e5b54125aba009b703208aa185	20	245.80	22836294.00	1	1	dh_app_5356	dh_promote_myteam_summary;dh_account_basic;dh_account_ext_promoteinfo;dh_account_basic;dh_account_ext_financeinfo

\n\n" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "from slowquery.analyzer import render_simple_html\n", "\n", "#new_file = \"../local/weekly/2023-12-11-slowlog.sqlite\"\n", "#last_file = \"../local/weekly/2023-12-04-slowlog.sqlite\"\n", "new_file = \"../local/daily/2023-12-06-slowlog.sqlite\"\n", "last_file = \"../local/daily/2023-12-05-slowlog.sqlite\"\n", "a = SlowlogAnalyzer([new_file])\n", "b = SlowlogComparator([new_file], [last_file])\n", "display(HTML(render_simple_html({\n", " **a.execute(),\n", " **b.execute(),\n", "})))" ] }, { "cell_type": "code", "execution_count": null, "outputs": [], "source": [], "metadata": { "collapsed": false, "ExecuteTime": { "end_time": "2024-01-17T07:03:32.202609Z", "start_time": "2024-01-17T07:03:32.199409Z" } }, "id": "6e5413ab282f9a84" }, { "cell_type": "code", "outputs": [], "source": [], "metadata": { "collapsed": false }, "id": "71e091350e252e43" } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.10" } }, "nbformat": 4, "nbformat_minor": 5 }