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 (363 total, Query took 0.0016 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	1046821000	1046821000	1046821000	1046821000	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:48.607749	2024-07-17 07:00:48.607749	1047128548	1047128548	1047128548	SELECT @@skip_networking, @@skip_name_resolve, @@h...	2024-07-17 07:00:48.607749	1046821000
NULL	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	SELECT @@`version` , @@`version_comment`	324	29277204000	34329000	90361000	293915000	0	0	0	0	324	324	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.851678	2024-07-17 07:01:49.030431	218776162	239883291	301995172	SELECT @@version, @@version_comment	2024-07-17 07:01:08.592122	293915000
NULL	52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc...	SET NAMES ? COLLATE ?	324	16687105000	23985000	51503000	189787000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.851860	2024-07-17 07:01:49.031301	144543977	181970085	190546071	SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'	2024-07-17 07:01:31.042160	189787000
NULL	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	SET `lc_messages` = ?	322	392440065000	20765000	1218757000	354257833000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.853892	2024-07-17 07:01:49.032070	144543977	3630780547	363078054770	SET lc_messages = 'es_ES'	2024-07-17 07:01:09.372640	354257833000
NULL	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	SHOW TABLES FROM `phpmyadmin`	324	58365879000	101487000	180141000	716037000	23946000000	324	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.854969	2024-07-17 07:01:49.033511	416869383	501187233	724435960	SHOW TABLES FROM `phpmyadmin`	2024-07-17 07:00:56.854969	716037000
NULL	d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10...	SET `collation_connection` = ?	324	18214450000	18712000	56217000	288593000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.856356	2024-07-17 07:01:49.038572	144543977	181970085	301995172	SET collation_connection = 'utf8mb4_unicode_ci'	2024-07-17 07:01:06.130002	288593000
NULL	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	SELECT ? FROM `mysql` . `user` LIMIT ?	245	36928262000	57370000	150727000	839150000	18620000000	0	0	0	245	245	0	0	0	0	0	0	245	0	0	0	0	0	0	2024-07-17 07:00:56.871539	2024-07-17 07:01:49.060579	229086765	331131121	870963589	SELECT 1 FROM mysql.user LIMIT 1	2024-07-17 07:00:56.871539	839150000
NULL	ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f...	SELECT SCHEMA ( )	178	8861356000	26178000	49782000	470756000	0	0	0	0	178	178	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.872524	2024-07-17 07:01:49.061131	87096358	100000000	478630092	SELECT DATABASE()	2024-07-17 07:00:56.872524	470756000
performance_schema	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	216	208968373000	646126000	967446000	4724463000	20705000000	0	0	0	216	123984	0	216	0	0	0	0	432	0	0	0	0	216	0	2024-07-17 07:00:56.877912	2024-07-17 07:01:49.062510	1659586907	3162277660	4786300923	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2024-07-17 07:00:56.877912	4724463000
performance_schema	0358d97188739cab939e7b5d195ecc23ca693443f8dcc295f0...	SELECT * FROM `session_status` LIMIT ?, ...	2	1146201000	338360000	573100000	807841000	233000000	0	0	0	50	50	0	0	0	0	0	0	2	0	0	0	0	2	0	2024-07-17 07:00:56.879101	2024-07-17 07:00:58.344057	831763771	831763771	831763771	SELECT * FROM `session_status` LIMIT 0, 25	2024-07-17 07:00:56.879101	807841000
performance_schema	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	266	108477646000	219453000	407810000	2471275000	60839000000	0	0	0	0	798	0	0	0	0	0	0	266	0	0	0	0	0	0	2024-07-17 07:00:56.881991	2024-07-17 07:01:48.097379	575439937	1202264434	2511886431	SELECT 1 FROM information_schema.VIEWS WHERE TABLE...	2024-07-17 07:00:56.881991	2471275000
performance_schema	1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631...	SELECT @@`lower_case_table_names`	132	6065028000	27299000	45947000	121127000	0	0	0	0	132	132	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.882307	2024-07-17 07:01:48.094319	63095734	91201083	125892541	SELECT @@lower_case_table_names	2024-07-17 07:01:05.061494	121127000
performance_schema	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	146	224642104000	699260000	1538644000	62099614000	72267000000	0	0	0	554	20801	0	143	142	0	0	0	146	0	0	554	146	142	0	2024-07-17 07:00:56.887974	2024-07-17 07:01:48.095463	1905460717	5495408738	63095734448	SHOW TABLE STATUS FROM `performance_schema`	2024-07-17 07:00:59.611264	62099614000
performance_schema	47a6a93c8b8afbc6e5ef16a9a82c87aacd7a30a4322128c9cd...	SELECT COUNT ( * ) FROM `performance_schema` . `se...	2	1212128000	227359000	606064000	984769000	740000000	0	0	0	2	0	0	0	0	0	0	0	2	0	0	0	0	2	0	2024-07-17 07:00:56.889272	2024-07-17 07:00:58.346791	1000000000	1000000000	1000000000	SELECT COUNT(*) FROM `performance_schema`.`session...	2024-07-17 07:00:56.889272	984769000
performance_schema	118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b...	SHOW WARNINGS	107	2922453000	16381000	27312000	66422000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.889579	2024-07-17 07:01:48.096601	41686938	47863009	69183097	SHOW WARNINGS	2024-07-17 07:01:03.337471	66422000
performance_schema	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	255	279842403000	469730000	1097421000	6915529000	109012000000	0	0	0	11635	58934	0	254	0	0	0	0	255	0	0	11632	254	0	0	2024-07-17 07:00:56.891233	2024-07-17 07:01:48.107283	1995262314	3467368504	6918309709	SHOW FULL COLUMNS FROM `performance_schema`.`table...	2024-07-17 07:01:06.414981	6915529000
performance_schema	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	148	106828209000	439888000	721812000	2287502000	56443000000	0	0	0	386	2304	0	148	0	0	0	0	148	0	0	386	148	0	0	2024-07-17 07:00:56.892332	2024-07-17 07:01:48.099503	1047128548	1202264434	2290867652	SHOW INDEXES FROM `performance_schema`.`table_lock...	2024-07-17 07:01:03.189354	2287502000
performance_schema	1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923...	SELECT @@`have_profiling`	79	4732834000	40502000	59909000	104634000	0	0	79	0	79	79	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.893383	2024-07-17 07:01:44.886158	91201083	104712854	104712854	SELECT @@have_profiling	2024-07-17 07:01:07.915991	104634000
performance_schema	9b5cdf2c07546fd6a7321c08f879cccfe19ef7f44c48cf60f6...	SHOW CREATE TABLE `performance_schema` . `session_...	2	154953000	76055000	77476000	78898000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.894300	2024-07-17 07:00:58.351543	79432823	79432823	79432823	SHOW CREATE TABLE `performance_schema`.`session_st...	2024-07-17 07:00:56.894300	78898000
performance_schema	3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f...	SELECT CURRENT_USER ( )	133	9200378000	29903000	69175000	125655000	0	0	0	0	133	133	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.917203	2024-07-17 07:01:48.234171	109647819	120226443	125892541	SELECT CURRENT_USER()	2024-07-17 07:01:05.933900	125655000
performance_schema	357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178...	SHOW GRANTS	105	9359809000	52013000	89141000	1571921000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2024-07-17 07:00:56.917492	2024-07-17 07:01:45.009257	114815362	144543977	1584893192	SHOW GRANTS	2024-07-17 07:01:05.471811	1571921000
performance_schema	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	514	328569693000	276394000	639240000	4781615000	126655000000	0	0	0	4400	29294	0	1159	780	0	0	0	1160	0	0	7980	266	514	0	2024-07-17 07:00:56.923037	2024-07-17 07:01:48.245459	1380384264	1819700858	4786300923	SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC...	2024-07-17 07:01:08.144156	4781615000
performance_schema	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	133	88080408000	391757000	662258000	8354974000	33005000000	0	0	0	133	532	0	931	0	0	0	0	931	0	0	0	0	133	0	2024-07-17 07:00:56.940178	2024-07-17 07:01:48.258858	870963589	1819700858	8709635899	SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR...	2024-07-17 07:01:04.331009	8354974000
performance_schema	d2340f5cbd00f9bca0926d9a88b42f5f96e74d6349790773aa...	SELECT ? FROM `performance_schema` . `session_stat...	4	1252240000	292090000	313060000	337726000	327000000	0	0	0	4	4	0	0	0	0	0	0	4	0	0	0	0	4	0	2024-07-17 07:00:56.957785	2024-07-17 07:00:58.413096	346736850	346736850	346736850	SELECT 1 FROM `performance_schema`.`session_status...	2024-07-17 07:00:57.438748	337726000
mysql	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	SHOW SESSION VARIABLES LIKE ?	128	120269699000	642187000	939607000	2037929000	11719000000	0	0	0	128	73472	0	128	0	0	0	0	256	0	0	0	0	128	0	2024-07-17 07:00:56.984122	2024-07-17 07:01:48.738673	1445439770	1819700858	2089296130	SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'	2024-07-17 07:01:26.054559	2037929000

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!