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 (1412 total, Query took 0.0007 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 134702 17042447400000 49300000 126500000 34852800000 0 0 0 0 134702 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:53
NULL18d48176446b1d9596ef5766d1366743 SHOW VARIABLES LIKE ? 142188 102183384200000 378200000 718600000 1084197900000 44359500000000 0 0 0 142008 142008 0 142188 0 0 0 0 142188 0 0 0 0 142188 0 2024-09-13 12:59:13 2024-09-18 11:43:53
NULLa9081fc94c4e1d3f727af7fd05e788cb SET CHARACTER SET ? 742682 65725233700000 27100000 88400000 25284700000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:54
NULL5004072ee7ccbcb3c65614c72cac435f SET `collation_connection` = ? 742682 265349008700000 31100000 357200000 98969500000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:54
NULL54ab90d16e01c3b89c01f7fb6c3aa3b5 SELECT * FROM `information_schema` . `CHARACTER_SE...134702 37144579200000 169000000 275700000 269449800000 13525819000000 0 0 0 5388080 5388080 0 134702 0 0 0 0 134702 0 0 0 0 134702 0 2024-09-13 12:59:13 2024-09-18 11:43:53
NULLbacdbc64d36d8176d2fb716f08faecf7 SELECT * FROM `information_schema` . `COLLATIONS` 134702 105297204200000 555000000 781700000 185269700000 12833664000000 0 0 0 29499738 29499738 0 134702 0 0 0 0 134702 0 0 0 0 134702 0 2024-09-13 12:59:13 2024-09-18 11:43:53
NULL46d66b37b8fd552d1ee001d894fb1104 SELECT COUNT ( * ) FROM `mysql` . `user` 134613 17319947300000 54700000 128600000 17697600000 7374833000000 0 0 0 134613 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:53
readme_to_recover_sz 7164267928ced1f24dc08818aa9024d8 SHOW TABLES FROM `readme_to_recover_sz` 125777 46369122700000 254200000 368600000 786260500000 16328011000000 0 0 0 125777 125777 0 125777 0 0 0 0 125777 0 0 0 0 125777 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test d1a8f6c5ed7e085fd1559a569462628b SHOW TABLES FROM `test` 123465 43837939200000 244500000 355000000 738492200000 15781148000000 0 0 0 0 0 0 123465 0 0 0 0 123465 0 0 0 0 123465 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test e95550f818dc263df5d796dcb125ac1e SELECT * , `TABLE_SCHEMA` AS `Db` , `TABLE_NAME` A...36744 15564395200000 354500000 423500000 15615100000 5625000000000 0 0 0 0 0 0 36744 0 0 0 0 36744 0 0 0 36744 36744 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test 095fdf22a733a8960d722d56cf083699 SHOW TABLE STATUS FROM `test` 38616 11679661800000 269400000 302400000 35012800000 2999977000000 0 0 0 0 0 0 38616 0 0 0 0 38616 0 0 0 0 38616 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test 4203e2584232109ca0b0934c1ba7e723 SELECT `DEFAULT_COLLATION_NAME` FROM `information_...22423 8447605900000 322300000 376700000 42156500000 1718736000000 0 0 0 22423 22423 0 22423 0 0 0 0 22423 0 0 0 0 22423 0 2024-09-13 12:59:13 2024-09-18 11:43:34
test b4121f407149459aa7daa1e02211d841 SHOW GRANTS 6818 977623500000 34100000 143300000 4639100000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:47
test 6e554fd61a0a59021a50e63b0a26e110 SELECT ( COUNT ( `SCHEMA_NAME` ) DIV ? ) * ? FROM ...40516 30745925300000 589500000 758800000 257419200000 5609570000000 0 0 0 40516 324128 0 40516 0 0 0 0 40516 0 0 0 0 40516 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test 0d6c82272ddc0ba6755237ce1d976391 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...40516 28838816000000 580400000 711700000 18516000000 3531289000000 0 0 0 324128 648256 0 40516 0 0 0 0 40516 0 0 324128 40516 40516 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test 1f48aa4f42708aa18fadb902aea7f892 SELECT COUNT ( * ) FROM `INFORMATION_SCHEMA` . `SC...81032 50495096100000 545600000 623100000 160740900000 6191924000000 0 0 0 81032 648256 0 81032 0 0 0 0 81032 0 0 0 0 81032 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test 0061196ebdfc760b0b1c48ad0055b662 SELECT CURRENT_USER ( ) 170609 11119772800000 34200000 65100000 10684400000 0 0 0 0 170609 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:48
test 28fc08977ebe53c17344efe8fefdcede SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ...170609 53581699400000 238100000 314000000 175518100000 14718586000000 0 0 0 170609 14501765 0 170609 0 0 0 0 170609 0 0 0 0 170609 0 2024-09-13 12:59:13 2024-09-18 11:43:48
readme_to_recover_sz e95550f818dc263df5d796dcb125ac1e SELECT * , `TABLE_SCHEMA` AS `Db` , `TABLE_NAME` A...37280 23375173200000 534200000 627000000 295681000000 5328128000000 0 0 0 37280 74560 0 37280 0 0 0 0 37280 0 0 37280 37280 37280 0 2024-09-13 12:59:13 2024-09-18 11:43:48
readme_to_recover_sz 4203e2584232109ca0b0934c1ba7e723 SELECT `DEFAULT_COLLATION_NAME` FROM `information_...22208 8371221900000 326500000 376900000 42037100000 1953180000000 0 0 0 22208 22208 0 22208 0 0 0 0 22208 0 0 0 0 22208 0 2024-09-13 12:59:13 2024-09-18 11:43:43
readme_to_recover_sz b4121f407149459aa7daa1e02211d841 SHOW GRANTS 10520 996310100000 35100000 94700000 18044200000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:36:54
readme_to_recover_sz 97fab7b1e8536616c337189e05564a12 SHOW MASTER STATUS 11173 692838200000 36100000 62000000 813400000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:00
readme_to_recover_sz 6e554fd61a0a59021a50e63b0a26e110 SELECT ( COUNT ( `SCHEMA_NAME` ) DIV ? ) * ? FROM ...49247 41327083700000 601500000 839100000 859605600000 8972268000000 0 0 0 49247 393976 0 49247 0 0 0 0 49247 0 0 0 0 49247 0 2024-09-13 12:59:13 2024-09-18 11:43:48
readme_to_recover_sz d2a0ffb1232f2704cef785f030306603 SHOW SLAVE STATUS 11173 1015099000000 59600000 90800000 18933700000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-13 12:59:13 2024-09-18 11:43:00
readme_to_recover_sz 0d6c82272ddc0ba6755237ce1d976391 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...49247 35330552500000 582900000 717400000 392838200000 4971488000000 0 0 0 393976 787952 0 49247 0 0 0 0 49247 0 0 393976 49247 49247 0 2024-09-13 12:59:13 2024-09-18 11:43:48

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