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.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 792249 95261352700000 44000000 120200000 44081500000 0 0 0 0 792249 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-08 23:29:00
NULL18d48176446b1d9596ef5766d1366743 SHOW VARIABLES LIKE ? 806436 861590753300000 384400000 1068300000 1778993100000 537815880000000 0 0 0 804831 804831 0 806436 0 0 0 0 806436 0 0 0 0 806436 0 2024-06-12 00:44:58 2024-07-08 23:29:00
NULL3a3d9057d91e5d5e95a8892609abad13 SET NAMES ? COLLATE ? 460330 110613444100000 29100000 240200000 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-08 23:29:02
NULL54ab90d16e01c3b89c01f7fb6c3aa3b5 SELECT * FROM `information_schema` . `CHARACTER_SE...792249 251065630500000 177100000 316900000 859157100000 136086656000000 0 0 0 31689960 31689960 0 792249 0 0 0 0 792249 0 0 0 0 792249 0 2024-06-12 00:44:58 2024-07-08 23:29:00
NULLbacdbc64d36d8176d2fb716f08faecf7 SELECT * FROM `information_schema` . `COLLATIONS` 792249 608605438300000 538100000 768100000 797506600000 108984110000000 0 0 0 173502531 173502531 0 792249 0 0 0 0 792249 0 0 0 0 792249 0 2024-06-12 00:44:58 2024-07-08 23:29:00
NULL46d66b37b8fd552d1ee001d894fb1104 SELECT COUNT ( * ) FROM `mysql` . `user` 788453 100233238700000 50300000 127100000 368203900000 39274185000000 0 0 0 788453 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 00:44:58 2024-07-08 23:29:00
mysql cfa64266e06b6058c4ae65418e9aecfb SHOW SESSION VARIABLES 4506 10135584600000 1133700000 2249300000 908615500000 4321070000000 0 4506 0 2005170 2005170 0 4506 0 0 0 0 4506 0 0 0 0 4506 0 2024-06-12 00:44:58 2024-07-08 23:27:06
mysql 626df0d4d348aaae7f26bddaccb066cb SHOW GLOBAL VARIABLES 10614 12604856700000 905700000 1187500000 111939100000 1434344000000 0 10614 0 4574634 4574634 0 10614 0 0 0 0 10614 0 0 0 0 10614 0 2024-06-12 00:44:58 2024-07-08 23:27:56
mysql b4121f407149459aa7daa1e02211d841 SHOW GRANTS 206712 18517038700000 33000000 89500000 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-08 23:29:00
mysql 0d6c82272ddc0ba6755237ce1d976391 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...369374 520476470500000 589400000 1409000000 1752513300000 196958878000000 0 0 0 2954992 5909984 0 369374 0 0 0 0 369374 0 0 2954992 369374 369374 0 2024-06-12 00:44:58 2024-07-08 23:29:02
mysql 1f48aa4f42708aa18fadb902aea7f892 SELECT COUNT ( * ) FROM `INFORMATION_SCHEMA` . `SC...738748 671124243900000 558400000 908400000 1418750000000 114206956000000 0 0 0 738748 5909984 0 738748 0 0 0 0 738748 0 0 0 0 738748 0 2024-06-12 00:44:58 2024-07-08 23:29:02
mysql 26f671bf3cef88f71f187ca07a370633 SHOW MASTER LOGS 370718 32834887900000 29100000 88500000 98351100000 0 370718 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 23:29:02
NULLa9081fc94c4e1d3f727af7fd05e788cb SET CHARACTER SET ? 637205 46636769200000 27100000 73100000 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-08 23:29:02
NULL5004072ee7ccbcb3c65614c72cac435f SET `collation_connection` = ? 637205 186321800600000 30600000 292400000 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-08 23:29:02
mysql 912155a01c21a0fbb7092da1641dc3c9 SELECT SYSTEM_USER ( ) 87496 13102965500000 37600000 149700000 106280100000 0 0 0 0 87496 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-12 05:22:30 2024-07-08 23:29:02
mysql b8420fe14cb4d7552f6c58c3305dbd0b SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...30885 28547169100000 567600000 924300000 404966100000 5954720000000 0 0 0 247080 247080 0 30885 0 0 0 0 30885 0 0 0 0 30885 0 2024-06-12 06:04:07 2024-07-08 23:28:39
mysql e92f0967fb63f05e617bb1bc77102518 SHOW STORAGE ENGINES 16862 10520678800000 146600000 623900000 613451100000 5614893000000 0 0 0 151758 151758 0 16862 0 0 0 0 16862 0 0 0 0 16862 0 2024-06-12 06:18:18 2024-07-08 23:28:39
mysql ed74142b59c3a8a355ca8c61812d565f SELECT * , IF ( `Password` = (_charset) ?, ... ) A...41777 13924979300000 245200000 333300000 84104100000 3969566000000 0 0 0 167108 334216 0 0 0 0 0 0 41777 0 0 167108 41777 41777 0 2024-06-12 06:43:03 2024-07-08 23:28:37
mysql 0a918246fe42fb01e88cb5dd759fc780 SHOW TABLES FROM `mysql` 195095 226509860300000 639300000 1161000000 1057043200000 85097455000000 0 0 0 5462660 5462660 0 195095 0 0 0 0 195095 0 0 0 0 195095 0 2024-06-12 06:43:03 2024-07-08 23:28:58
mysql 58ad4162c9af9f07f9ded10fb4f0cf14 ( SELECT DISTINCTROW `User` , `Host` FROM `mysql` ...41777 22244473700000 348400000 532400000 536449600000 10171550000000 0 0 0 208885 877317 0 83554 0 0 0 0 125331 0 0 208885 41777 41777 0 2024-06-12 06:43:03 2024-07-08 23:28:37
test d1a8f6c5ed7e085fd1559a569462628b SHOW TABLES FROM `test` 166758 112567359300000 261000000 675000000 1100776400000 59002944000000 0 0 0 0 0 0 166758 0 0 0 0 166758 0 0 0 0 166758 0 2024-06-12 07:38:27 2024-07-08 23:28:55
test e95550f818dc263df5d796dcb125ac1e SELECT * , `TABLE_SCHEMA` AS `Db` , `TABLE_NAME` A...52978 31191112500000 385800000 588700000 694618900000 12007361000000 0 0 0 0 0 0 52978 0 0 0 0 52978 0 0 0 52978 52978 0 2024-06-12 07:38:27 2024-07-08 23:28:55
test 095fdf22a733a8960d722d56cf083699 SHOW TABLE STATUS FROM `test` 53571 24019273300000 287600000 448300000 664462700000 7420362000000 0 0 0 0 0 0 53571 0 0 0 0 53571 0 0 0 0 53571 0 2024-06-12 07:38:27 2024-07-08 23:28:55
test 4203e2584232109ca0b0934c1ba7e723 SELECT `DEFAULT_COLLATION_NAME` FROM `information_...25185 13341529500000 340800000 529700000 102712400000 2909935000000 0 0 0 25185 25185 0 25185 0 0 0 0 25185 0 0 0 0 25185 0 2024-06-12 07:38:27 2024-07-08 23:28:55
test b4121f407149459aa7daa1e02211d841 SHOW GRANTS 45237 4883613500000 36700000 107900000 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 23:26:16

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