SQL Replay Report

Performance Summary

Connection 0 (Baseline)

IP: 10.10.218.57
Port: 3306
User: test
Total SQLs 21
Avg Response 18.4ms
Error Count 1

Connection 1

IP: 10.10.218.57
Port: 3306
User: test
Total SQLs 21
Avg Response 17.9ms
Error Count 1
Better Performance 5

Display Settings

sqlid ⇅ fingerprint ⇅ tablelist ⇅ conn_0_min ⇅ conn_0_min_sql ⇅ conn_0_max ⇅ conn_0_max_sql ⇅ conn_0_avg ⇅ conn_0_execution ⇅ conn_0_error ⇅ conn_1_min ⇅ conn_1_min_sql ⇅ conn_1_max ⇅ conn_1_max_sql ⇅ conn_1_avg ⇅ conn_1_execution ⇅ conn_1_error ⇅
6E3F90DDBC12719C
select * from users where salary > (select avg(salary) from users)
Expand
users
Expand 		18
SELECT * FROM users WHERE salary > (SELECT AVG(salary) FROM users)
Expand 		18
SELECT * FROM users WHERE salary > (SELECT AVG(salary) FROM users)
Expand 		18.0 1 0 18
SELECT * FROM users WHERE salary > (SELECT AVG(salary) FROM users)
Expand 		18
SELECT * FROM users WHERE salary > (SELECT AVG(salary) FROM users)
Expand 		18.0 1 0
493C7CF9A5F95BAB
select id, name, salary, salary - lag(salary) over (order by salary desc) as salary_diff from users
Expand
users
Expand 		18
SELECT id, name, salary, salary - LAG(salary) OVER (ORDER BY salary DESC) AS salary_diff FROM users
Expand 		18
SELECT id, name, salary, salary - LAG(salary) OVER (ORDER BY salary DESC) AS salary_diff FROM users
Expand 		18.0 1 0 18
SELECT id, name, salary, salary - LAG(salary) OVER (ORDER BY salary DESC) AS salary_diff FROM users
Expand 		18
SELECT id, name, salary, salary - LAG(salary) OVER (ORDER BY salary DESC) AS salary_diff FROM users
Expand 		18.0 1 0
3811A994C76CADDF
select city, avg(salary) as avg_salary from users group by city
Expand
users
Expand 		14
SELECT city, AVG(salary) AS avg_salary FROM users GROUP BY city
Expand 		14
SELECT city, AVG(salary) AS avg_salary FROM users GROUP BY city
Expand 		14.0 1 0 14
SELECT city, AVG(salary) AS avg_salary FROM users GROUP BY city
Expand 		14
SELECT city, AVG(salary) AS avg_salary FROM users GROUP BY city
Expand 		14.0 1 0
16777FECB752BF05
select * from users order by salary desc limit ?
Expand
users
Expand 		33
SELECT * FROM users ORDER BY salary DESC LIMIT 3
Expand 		36
SELECT * FROM users ORDER BY salary DESC LIMIT 3
Expand 		18.0 2 0 26
SELECT * FROM users ORDER BY salary DESC LIMIT 3
Expand 		29
SELECT * FROM users ORDER BY salary DESC LIMIT 3
Expand 		14.5 2 0
E3A3649C5FAC418D
select @@version_comment limit ?
Expand
27
select @@version_comment limit 1
Expand 		32
select @@version_comment limit 1
Expand 		16.0 2 0 27
select @@version_comment limit 1
Expand 		32
select @@version_comment limit 1
Expand 		16.0 2 0
EED022D709B5DA4D
select id, name, salary, rank() over (order by salary desc) as salary_rank from users
Expand
users
Expand 		30
SELECT id, name, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM users
Expand 		30
SELECT id, name, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM users
Expand 		30.0 1 0 27
SELECT id, name, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM users
Expand 		27
SELECT id, name, salary, RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM users
Expand 		27.0 1 0
E2614CE311B973BF
select count(*) as total_users from users
Expand
users
Expand 		29
SELECT COUNT(*) AS total_users FROM users
Expand 		29
SELECT COUNT(*) AS total_users FROM users
Expand 		29.0 1 0 29
SELECT COUNT(*) AS total_users FROM users
Expand 		29
SELECT COUNT(*) AS total_users FROM users
Expand 		29.0 1 0
E745E369AC71BBCE
select * from users where salary = (select max(salary) from users)
Expand
users
Expand 		18
SELECT * FROM users WHERE salary = (SELECT MAX(salary) FROM users)
Expand 		18
SELECT * FROM users WHERE salary = (SELECT MAX(salary) FROM users)
Expand 		18.0 1 0 18
SELECT * FROM users WHERE salary = (SELECT MAX(salary) FROM users)
Expand 		18
SELECT * FROM users WHERE salary = (SELECT MAX(salary) FROM users)
Expand 		18.0 1 0
5CA6471E3081F236
select * from users where salary > ?
Expand
users
Expand 		4
SELECT * FROM users WHERE salary > 10000
Expand 		4
SELECT * FROM users WHERE salary > 10000
Expand 		4.0 1 0 4
SELECT * FROM users WHERE salary > 10000
Expand 		4
SELECT * FROM users WHERE salary > 10000
Expand 		4.0 1 0
FB38455BF7035609
select database()
Expand
26
SELECT DATABASE()
Expand 		86
SELECT DATABASE()
Expand 		28.7 3 0 25
SELECT DATABASE()
Expand 		83
SELECT DATABASE()
Expand 		27.7 3 0
8975B8BDEEFF43EF
select * from users order by salary limit ?
Expand
users
Expand 		27
SELECT * FROM users ORDER BY salary ASC LIMIT 3
Expand 		27
SELECT * FROM users ORDER BY salary ASC LIMIT 3
Expand 		27.0 1 0 27
SELECT * FROM users ORDER BY salary ASC LIMIT 3
Expand 		27
SELECT * FROM users ORDER BY salary ASC LIMIT 3
Expand 		27.0 1 0
495055AD0EA17C56
select id, name, city, salary, rank() over (partition by city order by salary desc) as city_salary_rank from users
Expand
users
Expand 		18
SELECT id, name, city, salary, RANK() OVER (PARTITION BY city ORDER BY salary DESC) AS city_salary_rank FROM users
Expand 		18
SELECT id, name, city, salary, RANK() OVER (PARTITION BY city ORDER BY salary DESC) AS city_salary_rank FROM users
Expand 		18.0 1 0 20
SELECT id, name, city, salary, RANK() OVER (PARTITION BY city ORDER BY salary DESC) AS city_salary_rank FROM users
Expand 		20
SELECT id, name, city, salary, RANK() OVER (PARTITION BY city ORDER BY salary DESC) AS city_salary_rank FROM users
Expand 		20.0 1 0
F7A6F402D75C6880
select avg(salary) as avg_salary from users
Expand
users
Expand 		14
SELECT AVG(salary) AS avg_salary FROM users
Expand 		14
SELECT AVG(salary) AS avg_salary FROM users
Expand 		14.0 1 0 14
SELECT AVG(salary) AS avg_salary FROM users
Expand 		14
SELECT AVG(salary) AS avg_salary FROM users
Expand 		14.0 1 0
87BAE6DA99D190A9
select city, avg(age) as avg_age from users group by city
Expand
users
Expand 		31
SELECT city, AVG(age) AS avg_age FROM users GROUP BY city
Expand 		31
SELECT city, AVG(age) AS avg_age FROM users GROUP BY city
Expand 		31.0 1 0 26
SELECT city, AVG(age) AS avg_age FROM users GROUP BY city
Expand 		26
SELECT city, AVG(age) AS avg_age FROM users GROUP BY city
Expand 		26.0 1 0
389FF9DA2DF3DF62
select user()
Expand
26
select USER()
Expand 		31
select USER()
Expand 		15.5 2 0 27
select USER()
Expand 		32
select USER()
Expand 		16.0 2 0
0FD9925997B03211
select city, count(*) as user_count from users group by city
Expand
users
Expand 		27
SELECT city, COUNT(*) AS user_count FROM users GROUP BY city
Expand 		41
SELECT city, COUNT(*) AS user_count FROM users GROUP BY city
Expand 		20.5 2 0 29
SELECT city, COUNT(*) AS user_count FROM users GROUP BY city
Expand 		43
SELECT city, COUNT(*) AS user_count FROM users GROUP BY city
Expand 		21.5 2 0
1E673FAA643367F1
select city, count(*) as user_count from users group by ；
Expand
users
Expand 		-1
SELECT city, COUNT(*) AS user_count FROM users GROUP BY ；
Expand 		-1
SELECT city, COUNT(*) AS user_count FROM users GROUP BY ；
Expand 		-Inf 1 1 -1
SELECT city, COUNT(*) AS user_count FROM users GROUP BY ；
Expand 		-1
SELECT city, COUNT(*) AS user_count FROM users GROUP BY ；
Expand 		-Inf 1 1
EF3C0A967687DF79
select * from users u1 where salary = (select max(salary) from users u2 where u1.city = u2.city)
Expand
users
Expand 		17
SELECT * FROM users u1 WHERE salary = (SELECT MAX(salary) FROM users u2 WHERE u1.city = u2.city)
Expand 		23
SELECT * FROM users u1 WHERE salary = (SELECT MAX(salary) FROM users u2 WHERE u1.city = u2.city)
Expand 		11.5 2 0 17
SELECT * FROM users u1 WHERE salary = (SELECT MAX(salary) FROM users u2 WHERE u1.city = u2.city)
Expand 		23
SELECT * FROM users u1 WHERE salary = (SELECT MAX(salary) FROM users u2 WHERE u1.city = u2.city)
Expand 		11.5 2 0
D08D166618E6BC67
select * from users where age > ?
Expand
users
Expand 		6
SELECT * FROM users WHERE age > 30
Expand 		6
SELECT * FROM users WHERE age > 30
Expand 		6.0 1 0 6
SELECT * FROM users WHERE age > 30
Expand 		6
SELECT * FROM users WHERE age > 30
Expand 		6.0 1 0
4A11D1AA18F0F632
select city, sum(salary) as total_salary from users group by city
Expand
users
Expand 		6
SELECT city, SUM(salary) AS total_salary FROM users GROUP BY city
Expand 		6
SELECT city, SUM(salary) AS total_salary FROM users GROUP BY city
Expand 		6.0 1 0 6
SELECT city, SUM(salary) AS total_salary FROM users GROUP BY city
Expand 		6
SELECT city, SUM(salary) AS total_salary FROM users GROUP BY city
Expand 		6.0 1 0
831AD2FB940FC23C
select * from users where id = ?
Expand
users
Expand 		28
SELECT * FROM users WHERE id = 4
Expand 		220
SELECT * FROM users WHERE id = 4
Expand 		18.3 12 0 26
SELECT * FROM users WHERE id = 4
Expand 		213
SELECT * FROM users WHERE id = 4
Expand 		17.8 12 0