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 (309 total, Query took 0.0036 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	624590000	624590000	624590000	624590000	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:47.867386	2024-07-27 08:00:47.867386	630957344	630957344	630957344	SELECT @@skip_networking, @@skip_name_resolve, @@h...	2024-07-27 08:00:47.867386	624590000
NULL	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	SELECT @@`version` , @@`version_comment`	2088	161132350000	27259000	77170000	1295231000	0	0	0	0	2088	2088	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.241907	2024-07-27 08:04:58.125008	104712854	131825673	190546071	SELECT @@version, @@version_comment	2024-07-27 08:03:59.703563	1295231000
NULL	52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc...	SET NAMES ? COLLATE ?	2088	83837788000	16451000	40152000	545656000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.242088	2024-07-27 08:04:58.125157	57543993	75857757	125892541	SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'	2024-07-27 08:04:41.041856	125345000
NULL	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	SET `lc_messages` = ?	2011	98411129000	16863000	48936000	5395746000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.242199	2024-07-27 08:04:58.125253	50118723	109647819	2511886431	SET lc_messages = 'en_US'	2024-07-27 08:04:22.273895	1125641000
NULL	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	2088	322970905000	65778000	154679000	1640165000	130171000000	2088	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.243016	2024-07-27 08:04:58.125545	199526231	251188643	1513561248	SHOW TABLES FROM `phpmyadmin`	2024-07-27 08:04:54.102442	1640165000
NULL	d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10...	SET `collation_connection` = ?	2088	104923971000	19473000	50250000	211679000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.243906	2024-07-27 08:04:58.126665	83176377	114815362	190546071	SET collation_connection = 'utf8mb4_unicode_ci'	2024-07-27 08:04:49.106620	186313000
NULL	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	376	25926861000	23104000	68954000	542997000	0	0	0	0	376	376	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.260494	2024-07-27 08:04:58.042276	104712854	131825673	549540873	SELECT CURRENT_USER()	2024-07-27 08:04:26.201091	125628000
NULL	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	299	26272746000	46955000	87868000	354807000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.260799	2024-07-27 08:04:57.917436	131825673	208929613	363078054	SHOW GRANTS	2024-07-27 08:04:24.855704	206342000
NULL	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	1968	308292038000	52353000	156652000	391687000	152554000000	0	0	0	1968	1968	0	0	0	0	0	0	1968	0	0	0	0	0	0	2024-07-27 08:00:55.267907	2024-07-27 08:04:58.151060	218776162	251188643	363078054	SELECT 1 FROM mysql.user LIMIT 1	2024-07-27 08:04:35.039588	319038000
NULL	ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f...	SELECT SCHEMA ( )	1606	89495522000	23945000	55725000	164634000	0	0	0	0	1606	1606	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.268387	2024-07-27 08:04:58.151530	100000000	114815362	158489319	SELECT DATABASE()	2024-07-27 08:04:46.877277	111961000
NULL	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	1277	973818383000	326867000	762582000	7658735000	361751000000	0	0	0	11149	74323	0	2889	1947	0	0	0	2889	0	0	20414	670	1277	0	2024-07-27 08:00:55.268770	2024-07-27 08:04:58.044191	1513561248	1905460717	4786300923	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2024-07-27 08:04:11.073795	2048223000
performance_schema	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	2143	2168944837000	613946000	1012106000	5380596000	217076000000	0	0	0	2143	1230082	0	2143	0	0	0	0	4286	0	0	0	0	2143	0	2024-07-27 08:00:55.281839	2024-07-27 08:04:58.152751	1318256738	2511886431	4786300923	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2024-07-27 08:04:51.114809	1208133000
performance_schema	655b4753a0dac187bc653579603616fcda59e9d63159157fda...	SELECT * FROM `table_io_waits_summary_by_table` LI...	65	22242517000	164780000	342192000	2839063000	5145000000	0	0	0	1625	1625	0	0	0	0	0	0	65	0	0	0	0	65	0	2024-07-27 08:00:55.284904	2024-07-27 08:04:49.258809	416869383	2884031503	2884031503	SELECT * FROM `table_io_waits_summary_by_table` LI...	2024-07-27 08:04:22.263888	340150000
performance_schema	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	2355	1099897457000	228896000	467047000	5966309000	618897000000	0	0	0	0	7065	0	0	0	0	0	0	2355	0	0	0	0	0	0	2024-07-27 08:00:55.286504	2024-07-27 08:04:57.569116	630957344	1047128548	3019951720	SELECT 1 FROM information_schema.VIEWS WHERE TABLE...	2024-07-27 08:04:49.114876	1996093000
performance_schema	1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631...	SELECT @@`lower_case_table_names`	1071	54782026000	25335000	51150000	1045402000	0	0	0	0	1071	1071	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.286770	2024-07-27 08:04:57.565374	79432823	125892541	380189396	SELECT @@lower_case_table_names	2024-07-27 08:04:45.103298	1045402000
performance_schema	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	1071	1315904903000	762168000	1228669000	5965226000	600956000000	0	0	0	1071	147357	0	1071	1071	0	0	0	1071	0	0	1071	1071	1071	0	2024-07-27 08:00:55.290389	2024-07-27 08:04:57.567476	1584893192	2630267991	5248074602	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAM...	2024-07-27 08:04:55.693493	3842284000
performance_schema	696f372cde401cebf246d3df25ec3dc57b0631201839ba3d19...	SELECT COUNT ( * ) FROM `performance_schema` . `ta...	65	19890448000	167393000	306006000	450266000	3015000000	0	0	0	65	0	0	0	0	0	0	0	65	0	0	0	0	65	0	2024-07-27 08:00:55.290752	2024-07-27 08:04:49.261568	436515832	457088189	457088189	SELECT COUNT(*) FROM `performance_schema`.`table_i...	2024-07-27 08:04:01.029901	450266000
performance_schema	118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b...	SHOW WARNINGS	1071	32508895000	16589000	30353000	250176000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.290865	2024-07-27 08:04:57.568272	47863009	75857757	218776162	SHOW WARNINGS	2024-07-27 08:04:50.085369	250176000
performance_schema	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	2142	3143465792000	563863000	1467537000	7305590000	1054524000000	0	0	0	137986	696356	0	2142	0	0	0	0	2142	0	0	137986	2142	0	0	2024-07-27 08:00:55.295090	2024-07-27 08:04:57.579439	2290867652	3467368504	6918309709	SHOW FULL COLUMNS FROM `performance_schema`.`table...	2024-07-27 08:04:29.007148	7305590000
performance_schema	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	1071	896834190000	499885000	837380000	8162991000	482079000000	0	0	0	3141	17919	0	1071	0	0	0	0	1071	0	0	3141	1071	0	0	2024-07-27 08:00:55.298001	2024-07-27 08:04:57.570990	1148153621	1905460717	5495408738	SHOW INDEXES FROM `performance_schema`.`table_lock...	2024-07-27 08:04:45.118921	8162991000
performance_schema	f2c4024eae9443ab589b5a2579e6139e8b3c60a2d1771ec511...	SHOW CREATE TABLE `performance_schema` . `table_io...	65	12397146000	110233000	190725000	844747000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.300188	2024-07-27 08:04:49.266740	275422870	870963589	870963589	SHOW CREATE TABLE `performance_schema`.`table_io_w...	2024-07-27 08:04:43.118531	844747000
NULL	72d65068d798ec4bbb8caf499c62a0eaad967c33b862ee92d3...	SHOW TABLES FROM `SUTec`	27	5222799000	118153000	193437000	343186000	2602000000	27	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-27 08:00:55.354685	2024-07-27 08:04:50.302091	239883291	346736850	346736850	SHOW TABLES FROM `SUTec`	2024-07-27 08:04:49.099380	343186000
NULL	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	368	235610798000	391162000	640246000	2077215000	76011000000	0	0	0	368	1472	0	2576	0	0	0	0	2576	0	0	0	0	368	0	2024-07-27 08:00:55.362512	2024-07-27 08:04:58.060998	831763771	1584893192	2089296130	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2024-07-27 08:04:17.203193	1517632000
NULL	cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...	SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ...	524	139554464000	144907000	266325000	1435114000	31924000000	0	0	0	524	90652	0	524	0	0	0	0	524	0	0	0	0	524	0	2024-07-27 08:00:55.362994	2024-07-27 08:04:57.977899	398107170	549540873	1445439770	SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`....	2024-07-27 08:04:46.988610	498938000
performance_schema	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	SELECT * FROM `table_lock_waits_summary_by_table` ...	935	330445408000	178408000	353417000	4103101000	78006000000	0	0	0	23375	23375	0	0	0	0	0	0	935	0	0	0	0	935	0	2024-07-27 08:00:55.509236	2024-07-27 08:04:57.564263	478630092	691830970	4168693834	SELECT * FROM `table_lock_waits_summary_by_table` ...	2024-07-27 08:04:48.675543	3170784000

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!