demo.phpmyadmin.net / phpMyAdmin demo - MySQL / performance_schema / events_statements_summary_by_digest

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

Always expand query messages

Show query history at start

Show current browsing query

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - 24 (550 total, Query took 0.0006 seconds.)

SELECT * FROM `events_statements_summary_by_digest`

Filter rows:

Partial texts

Full texts

Show binary contents

Show BLOB contents

Hide browser transformation

Well Known Text

Well Known Binary

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	QUANTILE_95	QUANTILE_99	QUANTILE_999	QUERY_SAMPLE_TEXT	QUERY_SAMPLE_SEEN	QUERY_SAMPLE_TIMER_WAIT
NULL	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	SELECT @@`version` , @@`version_comment`	413	44297953000	24114000	107258000	944579000	0	0	0	0	413	413	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.664864	2024-09-27 21:17:33.515930	239883291	275422870	954992586	SELECT @@version, @@version_comment	2024-09-27 21:17:16.774012	437996000
NULL	52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc...	SET NAMES ? COLLATE ?	413	25414093000	19582000	61535000	192389000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.665098	2024-09-27 21:17:33.516911	151356124	181970085	199526231	SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'	2024-09-27 21:17:27.989078	187614000
NULL	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	SET `lc_messages` = ?	391	76211567000	19579000	194914000	18778394000	0	0	11	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.665327	2024-09-27 21:17:33.517758	190546071	4168693834	19054607179	SET lc_messages = 'zh_CN'	2024-09-27 21:17:30.090161	191065000
NULL	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	413	89000515000	73154000	215497000	845359000	36439000000	413	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.665954	2024-09-27 21:17:33.521469	478630092	602559586	870963589	SHOW TABLES FROM `phpmyadmin`	2024-09-27 21:16:56.978076	845359000
NULL	d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10...	SET `collation_connection` = ?	413	26340967000	18801000	63779000	225793000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.666953	2024-09-27 21:17:33.531023	158489319	199526231	229086765	SET collation_connection = 'utf8mb4_unicode_ci'	2024-09-27 21:16:49.185053	225793000
NULL	1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39...	SELECT @@`skip_networking` , @@`skip_name_resolve`...	1	106714000	106714000	106714000	106714000	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.668954	2024-09-27 21:16:03.668954	109647819	109647819	109647819	SELECT @@skip_networking, @@skip_name_resolve, @@h...	2024-09-27 21:16:03.668954	106714000
sys	c552f840b97cf2c164de85ef343eae0b410364ed59846f9192...	SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	3	76332868000	175842000	25444289000	57356231000	1970000000	0	0	0	2	2	2	9	0	0	0	0	4	0	0	462	4	2	0	2024-09-27 21:16:03.725958	2024-09-27 21:16:03.821614	57543993733	57543993733	57543993733	SELECT 1 FROM `sys`.`x$innodb_buffer_stats_by_sche...	2024-09-27 21:16:03.725958	57356231000
sys	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	49	37552953000	441631000	766386000	3142884000	18030000000	0	0	0	375	2022	0	49	0	0	0	0	49	0	0	375	49	0	0	2024-09-27 21:16:03.729483	2024-09-27 21:17:28.051882	2187761623	3162277660	3162277660	SHOW FULL COLUMNS FROM `sys`.`x$wait_classes_globa...	2024-09-27 21:17:26.978226	2180064000
sys	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	93	57715480000	421532000	620596000	1566658000	32883000000	0	0	0	0	279	0	93	0	0	0	0	93	0	0	0	93	0	0	2024-09-27 21:16:03.731319	2024-09-27 21:17:28.052586	1047128548	1584893192	1584893192	SHOW INDEXES FROM `sys`.`x$memory_global_total`	2024-09-27 21:16:49.231990	1566658000
sys	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	30	1700786000	22914000	56692000	101862000	0	0	0	0	30	30	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.744085	2024-09-27 21:17:28.087172	91201083	104712854	104712854	SELECT CURRENT_USER()	2024-09-27 21:16:42.515586	101862000
sys	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	26	1818765000	44605000	69952000	117041000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.744469	2024-09-27 21:17:28.087392	104712854	120226443	120226443	SHOW GRANTS	2024-09-27 21:17:27.003053	80242000
sys	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	99	62796923000	295029000	634312000	3555298000	20569000000	0	0	0	901	6203	0	225	153	0	0	0	225	0	0	1658	54	99	0	2024-09-27 21:16:03.748358	2024-09-27 21:17:28.098034	1445439770	3630780547	3630780547	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2024-09-27 21:17:28.093496	1431061000
sys	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	2913	810958634000	208317000	278392000	2469136000	437549000000	0	0	0	2879	17376	0	0	0	0	0	0	2913	0	0	0	0	0	0	2024-09-27 21:16:03.781750	2024-09-27 21:17:28.111558	416869383	630957344	1819700858	SELECT 1 FROM information_schema.VIEWS WHERE TABLE...	2024-09-27 21:16:49.234989	2469136000
sys	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	15	1269289000	55992000	84619000	199057000	637000000	0	0	0	15	15	0	0	0	0	0	0	15	0	0	0	0	0	0	2024-09-27 21:16:03.783203	2024-09-27 21:17:27.033768	199526231	199526231	199526231	SELECT 1 FROM mysql.user LIMIT 1	2024-09-27 21:17:27.033768	61346000
sys	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	31	14598563000	394916000	470921000	718046000	4495000000	0	0	0	31	124	0	217	0	0	0	0	217	0	0	0	0	31	0	2024-09-27 21:16:03.783950	2024-09-27 21:17:28.112167	724435960	724435960	724435960	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2024-09-27 21:17:27.034406	415779000
NULL	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	179	13020512000	21419000	72740000	236379000	0	0	0	0	179	179	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.837681	2024-09-27 21:17:32.489022	173780082	229086765	239883291	SELECT CURRENT_USER()	2024-09-27 21:17:27.990133	162686000
NULL	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	127	12255491000	50885000	96499000	430120000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.838020	2024-09-27 21:17:32.489339	239883291	263026799	436515832	SHOW GRANTS	2024-09-27 21:17:01.406432	430120000
NULL	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	531	358674099000	290807000	675469000	3663573000	131207000000	0	0	0	4823	31437	0	1206	819	0	0	0	1206	0	0	8872	288	531	0	2024-09-27 21:16:03.838911	2024-09-27 21:17:32.499262	1584893192	2754228703	3801893963	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2024-09-27 21:17:07.033385	3663573000
NULL	66e314e6ff32a1679b43ab40786b50df99ab83617d5586abd9...	SHOW TABLES FROM `LEON`	1	146665000	146665000	146665000	146665000	76000000	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.868009	2024-09-27 21:16:03.868009	151356124	151356124	151356124	SHOW TABLES FROM `LEON`	2024-09-27 21:16:03.868009	146665000
NULL	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	343	44323386000	48012000	129222000	623376000	21308000000	0	0	0	343	343	0	0	0	0	0	0	343	0	0	0	0	0	0	2024-09-27 21:16:03.868461	2024-09-27 21:17:33.573762	199526231	398107170	630957344	SELECT 1 FROM mysql.user LIMIT 1	2024-09-27 21:17:27.989424	623376000
NULL	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	163	93177478000	370092000	571640000	2815377000	29439000000	0	0	0	163	652	0	1141	0	0	0	0	1141	0	0	0	0	163	0	2024-09-27 21:16:03.869265	2024-09-27 21:17:32.514855	870963589	2511886431	2884031503	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2024-09-27 21:17:27.992849	2111082000
NULL	cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...	SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ...	221	45310361000	135323000	205024000	482394000	10428000000	0	0	0	221	38233	0	221	0	0	0	0	221	0	0	0	0	221	0	2024-09-27 21:16:03.869795	2024-09-27 21:17:32.515316	301995172	436515832	501187233	SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`....	2024-09-27 21:17:13.753397	235960000
NULL	cde413c1c35a535d19fdccb67e729e12d897c93818da51fc74...	SHOW TABLES FROM `shopping`	1	154904000	154904000	154904000	154904000	73000000	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.934566	2024-09-27 21:16:03.934566	158489319	158489319	158489319	SHOW TABLES FROM `shopping`	2024-09-27 21:16:03.934566	154904000
NULL	1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631...	SELECT @@`lower_case_table_names`	41	2589124000	29134000	63149000	199881000	0	0	0	0	41	41	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-09-27 21:16:03.966795	2024-09-27 21:17:32.512193	173780082	208929613	208929613	SELECT @@lower_case_table_names	2024-09-27 21:17:07.037724	199881000
NULL	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	44	15716206000	233879000	357186000	658157000	9064000000	0	0	0	0	44	0	0	0	0	0	0	44	0	0	0	0	0	0	2024-09-27 21:16:03.999210	2024-09-27 21:17:32.514146	549540873	660693448	660693448	SELECT 1 FROM information_schema.VIEWS WHERE TABLE...	2024-09-27 21:17:04.379284	473613000

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4907-g5b04607256 from the master branch.