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 844603 101820036600000 44000000 120500000 44081500000 0 0 0 0 844603 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-10 03:37:16
NULL18d48176446b1d9596ef5766d1366743 SHOW VARIABLES LIKE ? 862208 941087846200000 384400000 1091400000 1778993100000 594425475000000 0 0 0 860087 860087 0 862208 0 0 0 0 862208 0 0 0 0 862208 0 2024-06-12 00:44:58 2024-07-10 03:37:16
NULL3a3d9057d91e5d5e95a8892609abad13 SET NAMES ? COLLATE ? 566782 150698475100000 29100000 265800000 122511300000 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-10 03:37:16
NULL54ab90d16e01c3b89c01f7fb6c3aa3b5 SELECT * FROM `information_schema` . `CHARACTER_SE...844603 271764255200000 177100000 321700000 859157100000 148086047000000 0 0 0 33784120 33784120 0 844603 0 0 0 0 844603 0 0 0 0 844603 0 2024-06-12 00:44:58 2024-07-10 03:37:16
NULLbacdbc64d36d8176d2fb716f08faecf7 SELECT * FROM `information_schema` . `COLLATIONS` 844603 656241537300000 538100000 776900000 797506600000 118681038000000 0 0 0 184968057 184968057 0 844603 0 0 0 0 844603 0 0 0 0 844603 0 2024-06-12 00:44:58 2024-07-10 03:37:16
NULL46d66b37b8fd552d1ee001d894fb1104 SELECT COUNT ( * ) FROM `mysql` . `user` 840678 107419796400000 50300000 127700000 368203900000 42164876000000 0 0 0 840678 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-10 03:37:16
mysql cfa64266e06b6058c4ae65418e9aecfb SHOW SESSION VARIABLES 5715 11931492000000 1133700000 2087700000 908615500000 4571067000000 0 5715 0 2543175 2543175 0 5715 0 0 0 0 5715 0 0 0 0 5715 0 2024-06-12 00:44:58 2024-07-10 03:36:26
mysql 626df0d4d348aaae7f26bddaccb066cb SHOW GLOBAL VARIABLES 13711 16240239100000 905700000 1184400000 172751500000 1909042000000 0 13711 0 5909441 5909441 0 13711 0 0 0 0 13711 0 0 0 0 13711 0 2024-06-12 00:44:58 2024-07-10 03:36:28
mysql b4121f407149459aa7daa1e02211d841 SHOW GRANTS 222904 20633733000000 33000000 92500000 60714200000 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-10 03:37:09
mysql 0d6c82272ddc0ba6755237ce1d976391 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...514223 664589556900000 589400000 1292400000 1752513300000 227467407000000 0 0 0 4113784 8227568 0 514223 0 0 0 0 514223 0 0 4113784 514223 514223 0 2024-06-12 00:44:58 2024-07-10 03:37:15
mysql 1f48aa4f42708aa18fadb902aea7f892 SELECT COUNT ( * ) FROM `INFORMATION_SCHEMA` . `SC...1028446 908963227700000 558400000 883800000 1418750000000 147683741000000 0 0 0 1028446 8227568 0 1028446 0 0 0 0 1028446 0 0 0 0 1028446 0 2024-06-12 00:44:58 2024-07-10 03:37:15
mysql 26f671bf3cef88f71f187ca07a370633 SHOW MASTER LOGS 473808 41663580700000 29100000 87900000 98351100000 0 473808 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-10 03:37:15
NULLa9081fc94c4e1d3f727af7fd05e788cb SET CHARACTER SET ? 851928 65068532800000 27100000 76300000 37994300000 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-10 03:37:16
NULL5004072ee7ccbcb3c65614c72cac435f SET `collation_connection` = ? 851928 260320759400000 30600000 305500000 380759000000 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-10 03:37:16
mysql 912155a01c21a0fbb7092da1641dc3c9 SELECT SYSTEM_USER ( ) 119656 18530102000000 37600000 154800000 106280100000 0 0 0 0 119656 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 05:22:30 2024-07-10 03:37:15
mysql b8420fe14cb4d7552f6c58c3305dbd0b SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...38703 35676058300000 567600000 921700000 590390600000 7289563000000 0 0 0 309624 309624 0 38703 0 0 0 0 38703 0 0 0 0 38703 0 2024-06-12 06:04:07 2024-07-10 03:36:50
mysql e92f0967fb63f05e617bb1bc77102518 SHOW STORAGE ENGINES 21271 12690654900000 146600000 596600000 613451100000 6615007000000 0 0 0 191439 191439 0 21271 0 0 0 0 21271 0 0 0 0 21271 0 2024-06-12 06:18:18 2024-07-10 03:36:38
mysql ed74142b59c3a8a355ca8c61812d565f SELECT * , IF ( `Password` = (_charset) ?, ... ) A...51586 17467282600000 245200000 338600000 84104100000 5305888000000 0 0 0 206344 412688 0 0 0 0 0 0 51586 0 0 206344 51586 51586 0 2024-06-12 06:43:03 2024-07-10 03:37:13
mysql 0a918246fe42fb01e88cb5dd759fc780 SHOW TABLES FROM `mysql` 247189 274396033700000 639300000 1110000000 1057043200000 97796248000000 0 0 0 6921292 6921292 0 247189 0 0 0 0 247189 0 0 0 0 247189 0 2024-06-12 06:43:03 2024-07-10 03:37:14
mysql 58ad4162c9af9f07f9ded10fb4f0cf14 ( SELECT DISTINCTROW `User` , `Host` FROM `mysql` ...51586 26843096400000 344400000 520300000 536449600000 11738912000000 0 0 0 257930 1083306 0 103172 0 0 0 0 154758 0 0 257930 51586 51586 0 2024-06-12 06:43:03 2024-07-10 03:37:13
test d1a8f6c5ed7e085fd1559a569462628b SHOW TABLES FROM `test` 200811 130848230300000 261000000 651500000 1100776400000 67462615000000 0 0 0 0 0 0 200811 0 0 0 0 200811 0 0 0 0 200811 0 2024-06-12 07:38:27 2024-07-10 03:37:04
test e95550f818dc263df5d796dcb125ac1e SELECT * , `TABLE_SCHEMA` AS `Db` , `TABLE_NAME` A...63658 36668730800000 385800000 576000000 694618900000 14083330000000 0 0 0 0 0 0 63658 0 0 0 0 63658 0 0 0 63658 63658 0 2024-06-12 07:38:27 2024-07-10 03:37:04
test 095fdf22a733a8960d722d56cf083699 SHOW TABLE STATUS FROM `test` 64543 28194475200000 287600000 436800000 664462700000 8500528000000 0 0 0 0 0 0 64543 0 0 0 0 64543 0 0 0 0 64543 0 2024-06-12 07:38:27 2024-07-10 03:37:04
test 4203e2584232109ca0b0934c1ba7e723 SELECT `DEFAULT_COLLATION_NAME` FROM `information_...32802 17168524600000 340800000 523300000 148726500000 3838889000000 0 0 0 32802 32802 0 32802 0 0 0 0 32802 0 0 0 0 32802 0 2024-06-12 07:38:27 2024-07-10 03:37:04
test b4121f407149459aa7daa1e02211d841 SHOW GRANTS 47739 5299828000000 36700000 111000000 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-10 03:37:04

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