20.235.98.55 / 127.0.0.1:3307 / performance_schema / events_statements_summary_by_digest

There are no favorite tables.

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 (10000 total, Query took 0.0006 seconds.)

SELECT * FROM `events_statements_summary_by_digest`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

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	SUM_CPU_TIME	MAX_CONTROLLED_MEMORY	MAX_TOTAL_MEMORY	COUNT_SECONDARY	FIRST_SEEN	LAST_SEEN	QUANTILE_95	QUANTILE_99	QUANTILE_999	QUERY_SAMPLE_TEXT	QUERY_SAMPLE_SEEN	QUERY_SAMPLE_TIMER_WAIT
NULL	NULL	NULL	21905	31358239200000	42000000	1431500000	3489405600000	45120000000	0	435	0	87989	1007430	65	12152	184	2	8	0	16448	73	0	138069	11478	1786	0	0	12174672	19495004	0	2026-11-02 18:19:46.570261	2026-11-02 19:29:58.941647	1318256738	3630780547	87096358995	SELECT COUNT(*) FROM `performance_schema`.`events_...	2026-11-02 19:29:02.875599	641942700000
NULL	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	SELECT @@`version` , @@`version_comment`	10343	1278926000000	61000000	123600000	271100000	0	0	0	0	10343	10343	0	0	0	0	0	0	0	0	0	0	0	0	0	0	17208	72808	0	2026-10-29 11:46:56.327740	2026-11-02 19:29:59.069061	158489319	181970085	208929613	SELECT @@version, @@version_comment	2026-11-02 19:29:04.650423	209900000
NULL	52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc...	SET NAMES ? COLLATE ?	10342	668242800000	39200000	64600000	188100000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8968	56632	0	2026-10-29 11:46:56.391178	2026-11-02 19:29:59.069194	91201083	104712854	138038426	SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'	2026-11-02 19:29:42.006322	104100000
NULL	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	SET `lc_messages` = ?	10343	613628800000	36000000	59300000	7955400000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8968	56632	0	2026-10-29 11:46:56.391294	2026-11-02 19:29:59.069284	75857757	95499258	120226443	SET lc_messages = 'en_US'	2026-11-02 19:29:09.881347	109700000
NULL	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	20670	4046674800000	99900000	195700000	92147800000	26929000000	20670	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	48024	31062372	0	2026-10-29 11:46:56.525210	2026-11-02 19:29:59.092000	288403150	316227766	457088189	SHOW TABLES FROM `phpmyadmin`	2026-11-02 19:29:34.584714	428000000
NULL	d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10...	SET `collation_connection` = ?	10323	723684800000	41700000	70100000	203500000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	8968	56632	0	2026-10-29 11:46:56.919097	2026-11-02 19:29:59.091739	100000000	109647819	138038426	SET collation_connection = 'utf8mb4_unicode_ci'	2026-11-02 19:29:04.033502	122100000
NULL	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	6405	1015537500000	104800000	158500000	1115500000	9658000000	0	0	0	6405	6405	0	0	0	0	0	0	6405	0	0	0	0	0	0	0	1079424	2729071	0	2026-10-29 11:46:57.038971	2026-11-02 19:29:59.096598	239883291	275422870	380189396	SELECT 1 FROM mysql.user LIMIT 1	2026-11-02 19:29:09.861652	211100000
mysql	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	1032	71428300000	51600000	69200000	187900000	0	0	0	0	1032	1032	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1069184	2592023	0	2026-10-29 11:46:57.100247	2026-11-02 19:29:58.316705	91201083	181970085	190546071	SELECT CURRENT_USER()	2026-11-02 19:29:30.390227	73900000
mysql	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	131	13416300000	88000000	102400000	186100000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1067088	2593911	0	2026-10-29 11:46:57.100546	2026-11-02 19:29:30.432917	138038426	173780082	190546071	SHOW GRANTS	2026-11-02 19:29:09.539882	92500000
mysql	3c2243713616c5d54c930474c1c2ed040ceb17653233d60560...	SELECT `CHARACTER_SET_NAME` AS `Charset` , `DEFAUL...	788	302668600000	302400000	384000000	2551900000	1249000000	0	0	0	32308	64616	0	0	0	0	0	0	788	0	0	0	0	788	0	0	1263552	1342002	0	2026-10-29 11:46:57.122306	2026-11-02 19:29:57.830094	416869383	549540873	2630267991	SELECT `CHARACTER_SET_NAME` AS `Charset`, `DEFAULT...	2026-11-02 19:29:44.177261	424100000
mysql	bf17257c7ad5ebc2735f9149127bc67c806ea62ea7a54e6669...	SELECT `COLLATION_NAME` AS `Collation` , `CHARACTE...	823	1486278200000	1729500000	1805900000	3296000000	1116000000	0	0	0	235378	269121	0	823	0	0	0	0	1646	0	0	0	0	823	0	0	1198560	1554350	0	2026-10-29 11:46:57.140750	2026-11-02 19:29:57.831958	1905460717	2187761623	3311311214	SELECT `COLLATION_NAME` AS `Collation`, `CHARACTER...	2026-11-02 19:29:01.957705	1804700000
mysql	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	840	1087384100000	984300000	1294500000	5474100000	814000000	0	0	0	840	840	0	840	0	0	0	0	1680	0	0	0	0	840	0	0	1136304	1749388	0	2026-10-29 11:46:57.168347	2026-11-02 19:29:44.399019	1513561248	1819700858	5495408738	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2026-11-02 19:29:09.975975	1470200000
mysql	c9871d1fb65a3d7607814b7e30013cad125215e23e190a170c...	SELECT SYSTEM_USER ( )	774	52486200000	61900000	67800000	149900000	0	0	0	0	774	774	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1069912	1452225	0	2026-10-29 11:46:57.168806	2026-11-02 19:29:01.961160	83176377	100000000	151356124	SELECT USER()	2026-11-02 19:29:01.961160	72500000
mysql	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	1104	1059762000000	676200000	959900000	2859300000	3248000000	0	0	0	9923	50719	0	3312	3312	0	0	0	3312	0	0	19846	2208	1104	0	0	2603352	4135623	0	2026-10-29 11:46:57.649023	2026-11-02 19:29:58.321978	1202264434	1513561248	1995262314	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2026-11-02 19:29:01.013660	1365900000
mysql	5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33...	SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS...	2208	846117300000	338000000	383200000	1079900000	3297000000	0	0	0	2208	19846	0	4416	2208	0	0	0	4416	0	0	0	0	2208	0	0	1484152	3015623	0	2026-10-29 11:46:57.737170	2026-11-02 19:29:58.323916	457088189	724435960	954992586	SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I...	2026-11-02 19:29:39.355856	1079900000
mysql	a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	1105	595050400000	418400000	538500000	1123900000	284000000	0	0	0	1105	1105	0	6630	0	0	0	0	6630	0	0	0	0	1105	0	0	1313224	3487205	0	2026-10-29 11:46:58.009603	2026-11-02 19:29:58.328191	724435960	1047128548	1148153621	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2026-11-02 19:29:43.346010	860600000
mysql	aec37a23f9a4703622883bf7822fa102227ffa11d6a23f10be...	SHOW MASTER LOGS	157	83125100000	149700000	529400000	6729600000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1057576	1506652	0	2026-10-29 11:46:58.009880	2026-11-02 19:29:39.229181	5754399373	6606934480	6918309709	SHOW MASTER LOGS	2026-11-02 19:29:01.975244	194400000
NULL	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	5877	427604000000	55900000	72700000	226900000	0	0	0	0	5877	5877	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1069184	2729071	0	2026-10-29 11:47:01.500366	2026-11-02 19:29:59.092387	91201083	120226443	190546071	SELECT CURRENT_USER()	2026-11-02 19:29:57.622533	93100000
NULL	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	115	12562900000	85100000	109200000	177500000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1060944	2447611	0	2026-10-29 11:47:01.500587	2026-11-02 19:29:57.941844	151356124	151356124	181970085	SHOW GRANTS	2026-11-02 19:29:57.941844	144500000
mysql	fe219218c4249a2b7359e16fe5d3b48ae7c93e3e412600bedb...	SHOW MASTER STATUS	35	2022100000	38300000	57700000	131800000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1067088	1105430	0	2026-10-29 11:47:01.533139	2026-11-02 18:57:39.360309	120226443	138038426	138038426	SHOW MASTER STATUS	2026-11-02 18:57:27.479468	52500000
mysql	aeea8d14c430e6eaaf2ffc1c542f366c21a261cbe130323702...	SHOW SLAVE STATUS	35	3070400000	65600000	87700000	134000000	0	0	35	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1079424	1117624	0	2026-10-29 11:47:01.533363	2026-11-02 18:57:39.360433	120226443	138038426	138038426	SHOW SLAVE STATUS	2026-11-02 18:57:27.479610	91800000
mysql	5f43fa7094cffea337a9dacbf1746317e6d7f6b51a081d32eb...	SELECT * , CAST ( `BIN_NAME` AS CHARACTER CHARACTE...	9	7088000000	574000000	787500000	1029500000	19000000	0	36	0	75	75	0	18	9	0	0	0	18	0	0	75	9	9	0	0	1495984	1588785	0	2026-10-29 11:47:01.534619	2026-11-02 18:19:28.384314	1047128548	1047128548	1047128548	SELECT *, CAST(BIN_NAME AS CHAR CHARACTER SET utf8...	2026-11-02 18:19:16.265325	615900000
mysql	a542eb4d4e8e1ce60fb822fa955e14dfa2bef76ec06dbabd6a...	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	28	10829200000	293400000	386700000	674500000	56000000	0	0	0	246	766	0	0	28	0	0	0	28	0	0	0	0	28	0	0	1475184	1522750	0	2026-10-29 11:47:01.583876	2026-11-02 19:29:57.836532	660693448	691830970	691830970	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2026-11-02 19:29:57.836532	349000000
mysql	9401c428feef9d4199bdff05df8f6d31a7ab74215ea95385eb...	SELECT @@`collation_server`	9	703400000	66900000	78100000	85600000	0	0	0	0	9	9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1069184	1168754	0	2026-10-29 11:47:01.588783	2026-11-02 18:19:28.388998	87096358	87096358	87096358	SELECT @@collation_server	2026-11-02 18:19:16.270185	83600000
NULL	1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631...	SELECT @@`lower_case_table_names`	670	47464500000	55200000	70800000	192100000	0	0	0	0	670	670	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1069184	1142175	0	2026-10-29 11:47:30.742327	2026-11-02 19:29:58.867399	87096358	104712854	199526231	SELECT @@lower_case_table_names	2026-11-02 19:29:44.090292	98300000

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.