20.235.98.55 / 127.0.0.1:3307 / performance_schema / events_statements_summary_by_digest

`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.0004 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	25714	34844534600000	42000000	1355000000	3489405600000	52397000000	0	464	0	102289	1101294	80	13739	193	2	8	0	19435	83	0	159784	13148	1973	0	0	12174672	19495004	0	2026-11-02 18:19:46.570261	2026-11-02 19:32:19.503355	1258925411	2630267991	72443596007	SELECT COUNT(*) FROM `performance_schema`.`events_...	2026-11-02 19:32:08.770524	637547400000
NULL	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	SELECT @@`version` , @@`version_comment`	10949	1350873400000	59600000	123300000	271100000	0	0	0	0	10949	10949	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:32:19.536457	158489319	181970085	208929613	SELECT @@version, @@version_comment	2026-11-02 19:31:34.593037	197400000
NULL	52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc...	SET NAMES ? COLLATE ?	10948	707067800000	39200000	64500000	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:32:19.536580	91201083	104712854	138038426	SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'	2026-11-02 19:31:34.593316	134600000
NULL	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	SET `lc_messages` = ?	10949	649004500000	36000000	59200000	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:32:19.536665	75857757	95499258	120226443	SET lc_messages = 'en_US'	2026-11-02 19:32:11.830936	76100000
NULL	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	21882	4274915700000	99900000	195300000	92147800000	28433000000	21882	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:32:19.554059	288403150	316227766	478630092	SHOW TABLES FROM `phpmyadmin`	2026-11-02 19:31:39.826418	1505000000
NULL	d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10...	SET `collation_connection` = ?	10929	766281500000	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:32:19.553790	100000000	109647819	138038426	SET collation_connection = 'utf8mb4_unicode_ci'	2026-11-02 19:32:19.553790	90000000
NULL	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	6592	1042706700000	104800000	158100000	1115500000	9912000000	0	0	0	6592	6592	0	0	0	0	0	0	6592	0	0	0	0	0	0	0	1079424	2729071	0	2026-10-29 11:46:57.038971	2026-11-02 19:32:19.561401	239883291	275422870	380189396	SELECT 1 FROM mysql.user LIMIT 1	2026-11-02 19:32:12.522204	214700000
mysql	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	1174	81250600000	51600000	69200000	187900000	0	0	0	0	1174	1174	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:32:19.490231	91201083	181970085	190546071	SELECT CURRENT_USER()	2026-11-02 19:31:42.393668	91100000
mysql	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	151	15277800000	86600000	101100000	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:32:19.490377	131825673	173780082	190546071	SHOW GRANTS	2026-11-02 19:31:57.354427	107600000
mysql	3c2243713616c5d54c930474c1c2ed040ceb17653233d60560...	SELECT `CHARACTER_SET_NAME` AS `Charset` , `DEFAUL...	854	323397600000	291200000	378600000	2551900000	1332000000	0	0	0	35014	70028	0	0	0	0	0	0	854	0	0	0	0	854	0	0	1263552	1357446	0	2026-10-29 11:46:57.122306	2026-11-02 19:32:12.566585	416869383	549540873	2630267991	SELECT `CHARACTER_SET_NAME` AS `Charset`, `DEFAULT...	2026-11-02 19:32:12.357328	400500000
mysql	bf17257c7ad5ebc2735f9149127bc67c806ea62ea7a54e6669...	SELECT `COLLATION_NAME` AS `Collation` , `CHARACTE...	856	1544116900000	1715600000	1803800000	3296000000	1161000000	0	0	0	244816	279912	0	856	0	0	0	0	1712	0	0	0	0	856	0	0	1198560	1554350	0	2026-10-29 11:46:57.140750	2026-11-02 19:32:12.568425	1905460717	2187761623	3311311214	SELECT `COLLATION_NAME` AS `Collation`, `CHARACTER...	2026-11-02 19:31:33.808919	1954800000
mysql	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	914	1177407100000	961300000	1288100000	5474100000	882000000	0	0	0	914	914	0	914	0	0	0	0	1828	0	0	0	0	914	0	0	1136304	1749388	0	2026-10-29 11:46:57.168347	2026-11-02 19:32:12.844337	1513561248	1819700858	5495408738	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2026-11-02 19:32:12.639328	1381900000
mysql	c9871d1fb65a3d7607814b7e30013cad125215e23e190a170c...	SELECT SYSTEM_USER ( )	785	53219800000	61900000	67700000	149900000	0	0	0	0	785	785	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:32:12.099733	83176377	100000000	151356124	SELECT USER()	2026-11-02 19:32:11.294731	87900000
mysql	61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e...	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	1326	1248334300000	676200000	941400000	2859300000	3745000000	0	0	0	11921	60931	0	3978	3978	0	0	0	3978	0	0	23842	2652	1326	0	0	2603352	4135623	0	2026-10-29 11:46:57.649023	2026-11-02 19:32:19.496621	1202264434	1513561248	1995262314	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2026-11-02 19:31:44.452781	1450500000
mysql	5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33...	SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS...	2652	1013362300000	338000000	382100000	1079900000	3911000000	0	0	0	2652	23842	0	5304	2652	0	0	0	5304	0	0	0	0	2652	0	0	1484152	3015623	0	2026-10-29 11:46:57.737170	2026-11-02 19:32:19.499141	457088189	724435960	1000000000	SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I...	2026-11-02 19:31:59.028994	998500000
mysql	a112269de2b100dcc9877e5a4740ed1658e78ae5c3be5564fa...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	1325	707829300000	412000000	534200000	1177400000	343000000	0	0	0	1325	1325	0	7950	0	0	0	0	7950	0	0	0	0	1325	0	0	1313224	3487205	0	2026-10-29 11:46:58.009603	2026-11-02 19:32:19.504555	724435960	1047128548	1148153621	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2026-11-02 19:32:02.241284	748800000
mysql	aec37a23f9a4703622883bf7822fa102227ffa11d6a23f10be...	SHOW MASTER LOGS	166	84727200000	149700000	510400000	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:32:09.443364	5754399373	6606934480	6918309709	SHOW MASTER LOGS	2026-11-02 19:31:35.359211	201900000
NULL	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	6096	443100800000	53300000	72600000	226900000	0	0	0	0	6096	6096	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:32:19.557107	91201083	120226443	181970085	SELECT CURRENT_USER()	2026-11-02 19:32:08.093728	113300000
NULL	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	142	15383500000	85100000	108300000	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:32:19.557287	144543977	151356124	181970085	SHOW GRANTS	2026-11-02 19:32:07.740705	119000000
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` . `...	91	32746700000	293400000	359800000	674500000	156000000	0	0	0	813	2530	0	0	91	0	0	0	91	0	0	0	0	91	0	0	1475184	1585870	0	2026-10-29 11:47:01.583876	2026-11-02 19:32:12.572554	575439937	691830970	691830970	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2026-11-02 19:32:02.792716	533800000
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`	858	60976300000	55200000	71000000	192100000	0	0	0	0	858	858	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:32:12.561690	91201083	104712854	199526231	SELECT @@lower_case_table_names	2026-11-02 19:31:40.359952	96400000

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.