demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sys / x$statement_analysis

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 - ...

(Query took 0.0364 seconds.)

SELECT * FROM `x$statement_analysis`

Filter rows:

Partial texts

Full texts

Show binary contents

Show BLOB contents

Hide browser transformation

Well Known Text

Well Known Binary

query	db	full_scan	exec_count	err_count	warn_count	total_latency	max_latency	avg_latency	lock_latency	rows_sent	rows_sent_avg	rows_examined	rows_examined_avg	rows_affected	rows_affected_avg	tmp_tables	tmp_disk_tables	rows_sorted	sort_merge_passes	digest	first_seen	last_seen
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	4607	0	0	2890102067000	5310310000	627328000	1035618000000	43942	10	299204	65	0	0	10366	0	80974	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-31 09:30:55.044385	2024-07-31 09:36:21.594633
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		2304	0	0	2765687780000	7019038000	1200385000	921332000000	146932	64	741572	322	0	0	2304	0	146932	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-31 09:30:54.888229	2024-07-31 09:36:21.468444
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	3325	0	21	2101490417000	4858924000	632027000	762844000000	33079	10	217132	65	0	0	7393	0	59183	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-31 09:30:55.180268	2024-07-31 09:36:21.602640
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	2302	0	0	2008014393000	6653608000	872291000	212886000000	2302	1	1321348	574	0	0	2302	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-31 09:30:54.863943	2024-07-31 09:36:21.582271
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1498	0	0	1664944092000	5388371000	1111444000	586656000000	75746	51	386142	258	0	0	1492	0	75712	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-31 09:30:54.938768	2024-07-31 09:36:21.531340
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	992	0	0	1239769748000	8955882000	1249767000	136582000000	1360	1	41376	42	0	0	976	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-31 09:30:55.458822	2024-07-31 09:36:21.299325
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		3383	0	0	1231170587000	2219549000	363928000	687186000000	0	0	10149	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-31 09:30:54.937553	2024-07-31 09:36:21.529042
SHOW SESSION VARIABLES LIKE ?	mysql	*	1385	0	0	1216467300000	3892638000	878315000	126992000000	1385	1	794990	574	0	0	1385	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-31 09:30:54.935269	2024-07-31 09:36:21.591329
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	1745	0	0	1209813389000	4391309000	693302000	431614000000	18330	11	121201	69	0	0	3989	0	34168	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-31 09:30:54.811679	2024-07-31 09:36:20.911781
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	1153	0	0	1201219203000	3152683000	1041820000	546819000000	1153	1	163893	142	0	0	1153	0	1153	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-31 09:30:54.877128	2024-07-31 09:36:21.455561
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	749	0	0	1180978614000	446930843000	1576740000	328981000000	845	1	79759	106	0	0	747	0	845	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-31 09:30:55.095845	2024-07-31 09:36:21.530078
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		2521	0	0	984204144000	6873260000	390402000	546566000000	0	0	7563	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-31 09:30:54.874527	2024-07-31 09:36:21.457429
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1152	0	0	809421163000	5529968000	702622000	423140000000	3381	3	19285	17	0	0	1152	0	3381	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-31 09:30:54.890172	2024-07-31 09:36:21.460103
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		746	0	0	710153412000	102349255000	951948000	272375000000	1502	2	49105	66	0	0	746	0	1502	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-31 09:30:55.041516	2024-07-31 09:36:21.519879
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	1152	0	0	700980552000	3367047000	608490000	250263000000	1152	1	4608	4	0	0	8064	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-31 09:30:55.068114	2024-07-31 09:36:21.607538
SHOW TABLES FROM `phpmyadmin`	NULL		3449	3449	0	596138880000	973780000	172843000	242536000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-31 09:30:54.802444	2024-07-31 09:36:22.073661
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	837	0	0	502106012000	2415528000	599887000	178605000000	837	1	3348	4	0	0	5859	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-31 09:30:55.216746	2024-07-31 09:36:21.615458
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	446	0	0	481908953000	16751219000	1080513000	252787000000	13335	30	67942	152	0	0	36	0	13334	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-31 09:30:55.408600	2024-07-31 09:36:21.493014
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	668	0	0	383526062000	2668031000	574140000	127739000000	668	1	2672	4	0	0	4676	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-31 09:30:54.862431	2024-07-31 09:36:20.932142
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		2691	0	0	372842304000	914223000	138551000	185053000000	2691	1	2691	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-31 09:30:54.856347	2024-07-31 09:36:22.091202
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	983	0	0	323686411000	2255310000	329284000	38415000000	983	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-07-31 09:30:54.877690	2024-07-31 09:36:21.456123
SELECT @@`version` , @@`version_comment`	NULL		3448	0	0	300290779000	294919000	87091000	0	3448	1	3448	1	0	0	0	0	0	0	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	2024-07-31 09:30:54.799673	2024-07-31 09:36:22.072966
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	983	0	0	294079324000	2930664000	299165000	70681000000	24575	25	24575	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-07-31 09:30:54.867169	2024-07-31 09:36:21.453469
CREATE TABLE `test` ( NAME CHARACTER (?) )	test		1	0	0	289164897000	289164897000	289164897000	158000000	0	0	0	0	0	0	0	0	0	0	946d80b8166e604805745a2f88a2785308cf57087f15c508bd...	2024-07-31 09:35:59.179746	2024-07-31 09:35:59.179746
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	521	0	0	244646583000	2391925000	469571000	100946000000	3627	7	23390	45	0	0	707	0	6206	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-31 09:30:55.536515	2024-07-31 09:36:21.342137

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!