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 (390 total, Query took 0.0017 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	1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39...	SELECT @@`skip_networking` , @@`skip_name_resolve`...	1	1665707000	1665707000	1665707000	1665707000	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:48.050637	2024-07-21 09:15:48.050637	1737800828	1737800828	1737800828	SELECT @@skip_networking, @@skip_name_resolve, @@h...	2024-07-21 09:15:48.050637	1665707000
NULL	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	SELECT @@`version` , @@`version_comment`	735	449883869000	24574000	612086000	397790872000	0	0	0	0	735	735	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.595411	2024-07-21 09:16:58.715119	100000000	151356124	398107170553	SELECT @@version, @@version_comment	2024-07-21 09:16:05.364679	397790872000
NULL	52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc...	SET NAMES ? COLLATE ?	735	28066297000	13373000	38185000	269333000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.595603	2024-07-21 09:16:58.717001	54954087	75857757	275422870	SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'	2024-07-21 09:16:18.771812	269333000
NULL	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	SET `lc_messages` = ?	725	58389038000	13228000	80536000	5107264000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.595752	2024-07-21 09:16:58.721444	52480746	1445439770	5248074602	SET lc_messages = 'zh_CN'	2024-07-21 09:16:58.266727	47841000
NULL	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	735	105424568000	70746000	143434000	1018891000	42962000000	735	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.596605	2024-07-21 09:16:58.729592	190546071	275422870	1047128548	SHOW TABLES FROM `phpmyadmin`	2024-07-21 09:16:41.667434	1018891000
NULL	d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10...	SET `collation_connection` = ?	735	30868492000	18801000	41997000	207195000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.597490	2024-07-21 09:16:58.731540	69183097	91201083	208929613	SET collation_connection = 'utf8mb4_unicode_ci'	2024-07-21 09:16:24.837206	207195000
NULL	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	697	97616024000	50422000	140051000	896466000	47771000000	0	0	0	697	697	0	0	0	0	0	0	697	0	0	0	0	0	0	2024-07-21 09:15:55.612468	2024-07-21 09:16:58.758225	208929613	263026799	912010839	SELECT 1 FROM mysql.user LIMIT 1	2024-07-21 09:16:57.579191	199256000
NULL	ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f...	SELECT SCHEMA ( )	590	32139522000	17256000	54473000	472695000	0	0	0	0	590	590	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.613309	2024-07-21 09:16:58.765552	100000000	131825673	478630092	SELECT DATABASE()	2024-07-21 09:16:57.489768	102275000
performance_schema	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	935	861795014000	633351000	921705000	5434714000	87830000000	0	0	0	935	536690	0	935	0	0	0	0	1870	0	0	0	0	935	0	2024-07-21 09:15:55.618392	2024-07-21 09:16:58.766491	1318256738	2089296130	5495408738	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2024-07-21 09:16:35.938425	5434714000
performance_schema	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	SELECT * FROM `table_lock_waits_summary_by_table` ...	439	138606394000	159713000	315732000	3500360000	31758000000	0	0	0	10975	10975	0	0	0	0	0	0	439	0	0	0	0	439	0	2024-07-21 09:15:55.622331	2024-07-21 09:16:58.709876	478630092	602559586	3630780547	SELECT * FROM `table_lock_waits_summary_by_table` ...	2024-07-21 09:16:58.210401	496043000
performance_schema	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	954	396095001000	234211000	415193000	2799574000	222127000000	0	0	0	0	2862	0	0	0	0	0	0	954	0	0	0	0	0	0	2024-07-21 09:15:55.625095	2024-07-21 09:16:58.713583	575439937	1000000000	2884031503	SELECT 1 FROM information_schema.VIEWS WHERE TABLE...	2024-07-21 09:16:48.729434	2799574000
performance_schema	1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631...	SELECT @@`lower_case_table_names`	468	21995929000	25850000	46999000	799745000	0	0	0	0	468	468	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.625489	2024-07-21 09:16:58.711095	69183097	87096358	831763771	SELECT @@lower_case_table_names	2024-07-21 09:16:14.623990	799745000
performance_schema	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	468	624814816000	863694000	1335074000	5727794000	235171000000	0	0	0	468	191880	0	468	468	0	0	0	468	0	0	468	468	468	0	2024-07-21 09:15:55.631456	2024-07-21 09:16:58.712184	1819700858	3019951720	5754399373	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAM...	2024-07-21 09:16:58.626422	1611376000
performance_schema	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	SELECT COUNT ( * ) FROM `performance_schema` . `ta...	439	169597625000	145768000	386327000	2496849000	17910000000	0	0	0	439	0	0	0	0	0	0	0	439	0	0	0	0	439	0	2024-07-21 09:15:55.632326	2024-07-21 09:16:58.712653	575439937	1000000000	2511886431	SELECT COUNT(*) FROM `performance_schema`.`table_l...	2024-07-21 09:16:48.210768	2496849000
performance_schema	118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b...	SHOW WARNINGS	468	12973108000	13062000	27720000	87351000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.632581	2024-07-21 09:16:58.712782	43651583	57543993	91201083	SHOW WARNINGS	2024-07-21 09:16:26.347990	87351000
performance_schema	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	935	1226043957000	486472000	1311276000	7051557000	403724000000	0	0	0	61886	312238	0	936	0	0	0	0	936	0	0	61886	936	0	0	2024-07-21 09:15:55.634812	2024-07-21 09:16:58.723505	2089296130	3311311214	7244359600	SHOW FULL COLUMNS FROM `performance_schema`.`table...	2024-07-21 09:16:53.153671	7051557000
performance_schema	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	468	348964809000	494197000	745651000	5382480000	191628000000	0	0	0	1398	7934	0	468	0	0	0	0	468	0	0	1398	468	0	0	2024-07-21 09:15:55.636235	2024-07-21 09:16:58.715637	1148153621	2290867652	5495408738	SHOW INDEXES FROM `performance_schema`.`table_lock...	2024-07-21 09:16:13.690088	5382480000
performance_schema	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	SHOW CREATE TABLE `performance_schema` . `table_lo...	439	109147189000	155652000	248626000	2644351000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.638023	2024-07-21 09:16:58.717106	363078054	602559586	2754228703	SHOW CREATE TABLE `performance_schema`.`table_lock...	2024-07-21 09:16:32.927957	2644351000
performance_schema	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	465	31697885000	28891000	68167000	850540000	0	0	0	0	465	465	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:55.754590	2024-07-21 09:16:58.736910	109647819	144543977	870963589	SELECT CURRENT_USER()	2024-07-21 09:16:48.985436	850540000
performance_schema	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	1863	1218507403000	285677000	654056000	4179747000	452940000000	0	0	0	15536	104089	0	4192	2795	0	0	0	4192	0	0	28278	932	1863	0	2024-07-21 09:15:55.755655	2024-07-21 09:16:58.762626	1380384264	1905460717	4168693834	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2024-07-21 09:16:51.743015	4179747000
performance_schema	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	464	306414917000	416830000	660376000	3868183000	111401000000	0	0	0	464	1856	0	3248	0	0	0	0	3248	0	0	0	0	464	0	2024-07-21 09:15:55.777404	2024-07-21 09:16:58.644946	1000000000	2187761623	3981071705	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2024-07-21 09:16:45.012606	3868183000
performance_schema	0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...	SELECT ? FROM `performance_schema` . `table_lock_w...	436	69539648000	79778000	159494000	690962000	31791000000	0	0	0	436	436	0	0	0	0	0	0	436	0	0	0	0	436	0	2024-07-21 09:15:55.793861	2024-07-21 09:16:58.687192	218776162	363078054	691830970	SELECT 1 FROM `performance_schema`.`table_lock_wai...	2024-07-21 09:16:04.648571	690962000
NULL	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	106	5876955000	28427000	55442000	141192000	0	0	0	0	106	106	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:56.184478	2024-07-21 09:16:58.707548	91201083	125892541	144543977	SELECT CURRENT_USER()	2024-07-21 09:16:58.707548	41199000
NULL	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	91	7152642000	49449000	78600000	234419000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-21 09:15:56.184800	2024-07-21 09:16:58.707812	114815362	239883291	239883291	SHOW GRANTS	2024-07-21 09:16:58.707812	59257000
NULL	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	322	202874757000	295312000	630045000	2187191000	76031000000	0	0	0	2771	18374	0	728	490	0	0	0	728	0	0	5066	168	322	0	2024-07-21 09:15:56.196348	2024-07-21 09:16:58.738466	1258925411	1659586907	2187761623	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2024-07-21 09:16:02.134479	2187191000

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!