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 (646 total, Query took 0.0007 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	1966306000	1966306000	1966306000	1966306000	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:45:47.844551	2024-07-17 06:45:47.844551	1995262314	1995262314	1995262314	SELECT @@skip_networking, @@skip_name_resolve, @@h...	2024-07-17 06:45:47.844551	1966306000
NULL	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	SELECT @@`version` , @@`version_comment`	1669	182962620000	24619000	109624000	410654000	0	0	0	0	1669	1669	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.030585	2024-07-17 06:53:11.209219	229086765	275422870	346736850	SELECT @@version, @@version_comment	2024-07-17 06:52:36.647812	289039000
NULL	52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc...	SET NAMES ? COLLATE ?	1669	145675345000	15180000	87283000	13462434000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.030835	2024-07-17 06:53:11.209360	144543977	181970085	13803842646	SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'	2024-07-17 06:52:58.708387	183627000
NULL	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	SET `lc_messages` = ?	1643	221571848000	13036000	134858000	26776742000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.030983	2024-07-17 06:53:11.209454	151356124	1445439770	27542287033	SET lc_messages = 'en_US'	2024-07-17 06:52:17.563828	233646000
NULL	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	1669	408859725000	69688000	244972000	18436114000	194441000000	1669	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.032597	2024-07-17 06:53:11.209707	457088189	549540873	19054607179	SHOW TABLES FROM `phpmyadmin`	2024-07-17 06:52:26.650463	1408307000
NULL	d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10...	SET `collation_connection` = ?	1669	108474999000	16558000	64994000	330518000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.033761	2024-07-17 06:53:11.210679	151356124	190546071	275422870	SET collation_connection = 'utf8mb4_unicode_ci'	2024-07-17 06:53:11.168919	199980000
NULL	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	1429	196180345000	45422000	137285000	834823000	95160000000	0	0	0	1429	1429	0	0	0	0	0	0	1429	0	0	0	0	0	0	2024-07-17 06:46:01.049008	2024-07-17 06:53:11.224752	208929613	316227766	398107170	SELECT 1 FROM mysql.user LIMIT 1	2024-07-17 06:52:32.064313	347581000
NULL	ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f...	SELECT SCHEMA ( )	1046	45837615000	15119000	43821000	430502000	0	0	0	0	1046	1046	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.049928	2024-07-17 06:53:11.225088	63095734	75857757	120226443	SELECT DATABASE()	2024-07-17 06:52:53.769599	73444000
information_schema	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	204	174369120000	606839000	854750000	4429682000	18163000000	0	0	0	204	117096	0	204	0	0	0	0	408	0	0	0	0	204	0	2024-07-17 06:46:01.054929	2024-07-17 06:53:08.951175	1258925411	2754228703	4570881896	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2024-07-17 06:53:04.828256	1327232000
information_schema	878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...	SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co...	611	92487947000	89613000	151371000	1809727000	53077000000	0	0	0	1835	3642	0	0	0	0	0	0	42	0	0	533	13	34	0	2024-07-17 06:46:01.057185	2024-07-17 06:53:10.120570	263026799	398107170	1819700858	SELECT * FROM `CHARACTER_SETS` LIMIT 0, 25	2024-07-17 06:52:39.409615	279232000
information_schema	118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b...	SHOW WARNINGS	93	3008919000	19543000	32353000	67183000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.057617	2024-07-17 06:53:08.776008	45708818	69183097	69183097	SHOW WARNINGS	2024-07-17 06:52:53.772606	43056000
information_schema	1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631...	SELECT @@`lower_case_table_names`	101	4564319000	31091000	45191000	114600000	0	0	0	0	101	101	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.057914	2024-07-17 06:53:08.776368	63095734	95499258	114815362	SELECT @@lower_case_table_names	2024-07-17 06:52:53.773094	67536000
information_schema	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	240	102070252000	163211000	425292000	3415950000	54547000000	0	0	0	30	852	0	0	0	0	0	0	238	0	0	0	0	0	0	2024-07-17 06:46:01.059933	2024-07-17 06:53:10.178578	575439937	1380384264	3467368504	SELECT 1 FROM information_schema.VIEWS WHERE TABLE...	2024-07-17 06:52:51.110092	3415950000
information_schema	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	395	277901786000	416943000	703548000	7011302000	142010000000	0	0	0	4439	21330	0	246	0	0	0	0	395	0	0	3414	246	0	0	2024-07-17 06:46:01.061758	2024-07-17 06:53:10.110106	1148153621	2884031503	7244359600	SHOW FULL COLUMNS FROM `information_schema`.`ROUTI...	2024-07-17 06:53:10.070542	2862529000
information_schema	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	589	448210569000	252446000	760968000	90382770000	205287000000	0	0	0	118	6406	0	560	22	0	0	0	582	0	0	0	560	22	0	2024-07-17 06:46:01.063089	2024-07-17 06:53:10.125036	1000000000	2187761623	91201083935	SELECT * FROM `STATISTICS` LIMIT 0, 25	2024-07-17 06:52:42.975046	2156507000
information_schema	1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923...	SELECT @@`have_profiling`	91	4787594000	34113000	52610000	110159000	0	0	91	0	91	91	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.065033	2024-07-17 06:53:08.780754	95499258	114815362	114815362	SELECT @@have_profiling	2024-07-17 06:52:46.837109	96889000
information_schema	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	778	780641660000	107613000	1003395000	3179261000	87667000000	0	0	0	5354	36842	0	768	0	0	0	0	818	0	0	0	0	50	0	2024-07-17 06:46:01.075954	2024-07-17 06:53:10.126207	1659586907	2089296130	3311311214	SELECT `COLLATION_NAME` FROM `information_schema`....	2024-07-17 06:53:01.059285	2061777000
information_schema	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	156	9414400000	27660000	60348000	243640000	0	0	0	0	156	156	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.126629	2024-07-17 06:53:10.133336	91201083	120226443	251188643	SELECT CURRENT_USER()	2024-07-17 06:53:08.253714	114833000
information_schema	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	154	11464498000	48884000	74444000	437276000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.127015	2024-07-17 06:53:10.133710	100000000	288403150	457088189	SHOW GRANTS	2024-07-17 06:53:08.254109	98302000
information_schema	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	1428	493525001000	114931000	345605000	2181790000	210756000000	0	0	0	7267	41792	0	1312	958	0	0	0	2153	0	0	10020	334	646	0	2024-07-17 06:46:01.133375	2024-07-17 06:53:10.164522	912010839	1318256738	2089296130	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2024-07-17 06:52:52.965920	2181790000
information_schema	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	156	74939473000	387880000	480381000	4937923000	23151000000	0	0	0	156	624	0	1092	0	0	0	0	1092	0	0	0	0	156	0	2024-07-17 06:46:01.152186	2024-07-17 06:53:10.179370	630957344	1380384264	5011872336	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2024-07-17 06:52:51.115646	4937923000
performance_schema	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	1208	1045133835000	598739000	865177000	25676566000	119068000000	0	0	0	1208	693392	0	1208	0	0	0	0	2416	0	0	0	0	1208	0	2024-07-17 06:46:01.196018	2024-07-17 06:53:11.226299	1202264434	1819700858	10964781961	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2024-07-17 06:53:00.145865	1187151000
performance_schema	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	SELECT * FROM `table_lock_waits_summary_by_table` ...	515	152645318000	184735000	296398000	6626102000	34021000000	0	0	0	12875	12875	0	0	0	0	0	0	515	0	0	0	0	515	0	2024-07-17 06:46:01.202958	2024-07-17 06:53:10.177855	457088189	1000000000	6918309709	SELECT * FROM `table_lock_waits_summary_by_table` ...	2024-07-17 06:52:46.087527	389878000
performance_schema	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	1260	473693234000	226460000	375947000	2576249000	265356000000	0	0	0	0	3780	0	0	0	0	0	0	1260	0	0	0	0	0	0	2024-07-17 06:46:01.204027	2024-07-17 06:53:10.697007	549540873	724435960	2511886431	SELECT 1 FROM information_schema.VIEWS WHERE TABLE...	2024-07-17 06:52:11.399898	1160263000
performance_schema	1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631...	SELECT @@`lower_case_table_names`	604	27356798000	25272000	45292000	186559000	0	0	0	0	604	604	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 06:46:01.204387	2024-07-17 06:53:10.693901	66069344	83176377	190546071	SELECT @@lower_case_table_names	2024-07-17 06:52:40.448973	76729000

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!