Server: mysql wampserver »Database: performance_schema »Table: events_statements_summary_by_digest
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 24 (1432 total, Query took 0.0009 sec)
SELECT * FROM `events_statements_summary_by_digest`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED FIRST_SEEN LAST_SEEN
NULLdde72c2e259686824bf6c3a5e284eb46 SELECT @ @ version , @ @ version_comment 777026 93045295300000 44000000 119700000 44081500000 0 0 0 0 777026 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-08 18:52:15
NULL18d48176446b1d9596ef5766d1366743 SHOW VARIABLES LIKE ? 790950 778288703900000 384400000 983900000 1573902600000 461392031000000 0 0 0 789495 789495 0 790950 0 0 0 0 790950 0 0 0 0 790950 0 2024-06-12 00:44:58 2024-07-08 18:52:16
NULL3a3d9057d91e5d5e95a8892609abad13 SET NAMES ? COLLATE ? 432909 87954548700000 29100000 203100000 111952500000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-08 18:52:16
NULL54ab90d16e01c3b89c01f7fb6c3aa3b5 SELECT * FROM `information_schema` . `CHARACTER_SE...777026 240856196400000 177100000 309900000 677596800000 129455333000000 0 0 0 31081040 31081040 0 777026 0 0 0 0 777026 0 0 0 0 777026 0 2024-06-12 00:44:58 2024-07-08 18:52:15
NULLbacdbc64d36d8176d2fb716f08faecf7 SELECT * FROM `information_schema` . `COLLATIONS` 777026 587810837300000 538100000 756400000 493485900000 106204657000000 0 0 0 170168694 170168694 0 777026 0 0 0 0 777026 0 0 0 0 777026 0 2024-06-12 00:44:58 2024-07-08 18:52:15
NULL46d66b37b8fd552d1ee001d894fb1104 SELECT COUNT ( * ) FROM `mysql` . `user` 773295 97457027800000 50300000 126000000 368203900000 38419326000000 0 0 0 773295 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-08 18:52:15
mysql cfa64266e06b6058c4ae65418e9aecfb SHOW SESSION VARIABLES 4262 8604209300000 1133700000 2018800000 908615500000 3147172000000 0 4262 0 1896590 1896590 0 4262 0 0 0 0 4262 0 0 0 0 4262 0 2024-06-12 00:44:58 2024-07-08 18:51:30
mysql 626df0d4d348aaae7f26bddaccb066cb SHOW GLOBAL VARIABLES 9951 11644915700000 905700000 1170200000 111939100000 1311444000000 0 9951 0 4288881 4288881 0 9951 0 0 0 0 9951 0 0 0 0 9951 0 2024-06-12 00:44:58 2024-07-08 18:51:58
mysql b4121f407149459aa7daa1e02211d841 SHOW GRANTS 201719 17749220900000 33000000 87900000 57115100000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-08 18:52:14
mysql 0d6c82272ddc0ba6755237ce1d976391 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...326457 412934129900000 589400000 1264800000 1070643100000 137966625000000 0 0 0 2611656 5223312 0 326457 0 0 0 0 326457 0 0 2611656 326457 326457 0 2024-06-12 00:44:58 2024-07-08 18:52:16
mysql 1f48aa4f42708aa18fadb902aea7f892 SELECT COUNT ( * ) FROM `INFORMATION_SCHEMA` . `SC...652914 562662027700000 558400000 861700000 1418750000000 88696925000000 0 0 0 652914 5223312 0 652914 0 0 0 0 652914 0 0 0 0 652914 0 2024-06-12 00:44:58 2024-07-08 18:52:16
mysql 26f671bf3cef88f71f187ca07a370633 SHOW MASTER LOGS 344770 29314766800000 29100000 85000000 98351100000 0 344770 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-08 18:52:15
NULLa9081fc94c4e1d3f727af7fd05e788cb SET CHARACTER SET ? 580390 41278733800000 27100000 71100000 21217100000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:45:02 2024-07-08 18:52:16
NULL5004072ee7ccbcb3c65614c72cac435f SET `collation_connection` = ? 580390 142232410600000 30600000 245000000 114590500000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:45:02 2024-07-08 18:52:16
mysql 912155a01c21a0fbb7092da1641dc3c9 SELECT SYSTEM_USER ( ) 78644 10640583900000 37600000 135300000 84795600000 0 0 0 0 78644 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 05:22:30 2024-07-08 18:52:14
mysql b8420fe14cb4d7552f6c58c3305dbd0b SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...28848 24858929000000 567600000 861700000 404966100000 4207481000000 0 0 0 230784 230784 0 28848 0 0 0 0 28848 0 0 0 0 28848 0 2024-06-12 06:04:07 2024-07-08 18:52:15
mysql e92f0967fb63f05e617bb1bc77102518 SHOW STORAGE ENGINES 15741 6459630500000 146600000 410300000 349715400000 2491855000000 0 0 0 141669 141669 0 15741 0 0 0 0 15741 0 0 0 0 15741 0 2024-06-12 06:18:18 2024-07-08 18:52:08
mysql ed74142b59c3a8a355ca8c61812d565f SELECT * , IF ( `Password` = (_charset) ?, ... ) A...39562 13123658700000 246900000 331700000 84104100000 3732638000000 0 0 0 158248 316496 0 0 0 0 0 0 39562 0 0 158248 39562 39562 0 2024-06-12 06:43:03 2024-07-08 18:52:15
mysql 0a918246fe42fb01e88cb5dd759fc780 SHOW TABLES FROM `mysql` 183212 194263047000000 639300000 1060300000 975601800000 62977884000000 0 0 0 5129936 5129936 0 183212 0 0 0 0 183212 0 0 0 0 183212 0 2024-06-12 06:43:03 2024-07-08 18:52:15
mysql 58ad4162c9af9f07f9ded10fb4f0cf14 ( SELECT DISTINCTROW `User` , `Host` FROM `mysql` ...39562 20357509000000 348400000 514500000 536449600000 9458011000000 0 0 0 197810 830802 0 79124 0 0 0 0 118686 0 0 197810 39562 39562 0 2024-06-12 06:43:03 2024-07-08 18:52:15
test d1a8f6c5ed7e085fd1559a569462628b SHOW TABLES FROM `test` 154196 97114261000000 261000000 629800000 1100776400000 47484925000000 0 0 0 0 0 0 154196 0 0 0 0 154196 0 0 0 0 154196 0 2024-06-12 07:38:27 2024-07-08 18:52:05
test e95550f818dc263df5d796dcb125ac1e SELECT * , `TABLE_SCHEMA` AS `Db` , `TABLE_NAME` A...48940 29056055600000 385800000 593700000 694618900000 11142522000000 0 0 0 0 0 0 48940 0 0 0 0 48940 0 0 0 48940 48940 0 2024-06-12 07:38:27 2024-07-08 18:52:05
test 095fdf22a733a8960d722d56cf083699 SHOW TABLE STATUS FROM `test` 49468 22054086400000 287600000 445800000 664462700000 6942703000000 0 0 0 0 0 0 49468 0 0 0 0 49468 0 0 0 0 49468 0 2024-06-12 07:38:27 2024-07-08 18:52:05
test 4203e2584232109ca0b0934c1ba7e723 SELECT `DEFAULT_COLLATION_NAME` FROM `information_...23261 11774237400000 340800000 506100000 102712400000 2516304000000 0 0 0 23261 23261 0 23261 0 0 0 0 23261 0 0 0 0 23261 0 2024-06-12 07:38:27 2024-07-08 18:52:05
test b4121f407149459aa7daa1e02211d841 SHOW GRANTS 43032 4209081400000 37000000 97800000 69982600000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 07:38:27 2024-07-08 18:52:05

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view