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.0451 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 `TABLE_CATALOG` , `sch` ....	performance_schema		1557	0	0	1934828351000	7264935000	1242664000	620860000000	104388	67	526611	338	0	0	1557	0	104388	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-13 10:30:55.180884	2024-07-13 10:33:00.259889
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	3115	0	0	1901616758000	4712810000	610470000	707613000000	25707	8	172159	55	0	0	7011	0	46740	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-13 10:30:55.302702	2024-07-13 10:33:00.429906
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1556	0	0	1410127636000	6757104000	906251000	139783000000	1556	1	893144	574	0	0	1556	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-13 10:30:55.164976	2024-07-13 10:33:00.415259
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		4217	0	0	1016195273000	563335000	240975000	550417000000	4215	1	25296	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-13 10:31:53.608576	2024-07-13 10:31:55.083261
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	779	0	0	1012449674000	5751078000	1299678000	383709000000	779	1	319390	410	0	0	779	0	779	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-13 10:30:55.177167	2024-07-13 10:33:00.235194
SELECT * FROM `country` LIMIT ?, ...	sakila	*	1	0	0	701761680000	701761680000	701761680000	129000000	25	25	25	25	0	0	0	0	0	0	d7530f91b1e370283b7520ecf25b5bf015e9f9fef6b4d88d0a...	2024-07-13 10:32:06.290637	2024-07-13 10:32:06.290637
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1563	0	0	626930718000	3825760000	401107000	351706000000	0	0	4689	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-13 10:30:55.170814	2024-07-13 10:33:00.236944
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		779	0	0	538570635000	3132442000	691361000	287642000000	2332	3	13222	17	0	0	779	0	2332	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-13 10:30:55.182085	2024-07-13 10:33:00.239466
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	774	0	0	469373266000	2039910000	606425000	170390000000	774	1	3096	4	0	0	5418	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-13 10:30:55.324940	2024-07-13 10:33:00.441987
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	673	0	0	425280392000	4209646000	631917000	155637000000	6237	9	41323	61	0	0	1518	0	11520	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-13 10:30:57.109185	2024-07-13 10:33:00.290209
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	507	0	0	314579841000	2252072000	620473000	119622000000	4335	9	29147	57	0	0	1146	0	7920	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-13 10:30:56.037092	2024-07-13 10:32:56.173949
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		125	0	0	298559386000	116687688000	2388475000	51887000000	254	2	5574	45	0	0	125	0	254	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-13 10:30:57.054299	2024-07-13 10:33:00.107754
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		288	0	0	271405633000	3114468000	942380000	118557000000	8164	28	42040	146	0	0	244	0	7986	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-13 10:30:57.023742	2024-07-13 10:33:00.133228
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	199	0	0	244480008000	17893958000	1228542000	92817000000	3783	19	57971	291	0	0	87	0	3783	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-13 10:30:57.143999	2024-07-13 10:33:00.119295
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	754	0	0	206169621000	2588420000	273434000	52070000000	18850	25	18850	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-07-13 10:30:55.167993	2024-07-13 10:33:00.231186
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	754	0	0	185163616000	1224331000	245575000	30641000000	754	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-07-13 10:30:55.178206	2024-07-13 10:33:00.235970
SHOW TABLES FROM `phpmyadmin`	NULL		1156	1156	0	178950183000	511300000	154801000	72941000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-13 10:30:55.142032	2024-07-13 10:33:00.395779
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		754	0	0	175987574000	2672953000	233405000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-07-13 10:30:55.183908	2024-07-13 10:33:00.241502
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	118	0	0	155284012000	2860122000	1315966000	17138000000	256	2	4848	41	0	0	112	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-13 10:31:04.505898	2024-07-13 10:32:46.956038
SHOW SESSION VARIABLES LIKE ?	mysql	*	165	0	0	151004826000	3499823000	915180000	15472000000	165	1	94710	574	0	0	165	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-13 10:30:57.188445	2024-07-13 10:33:00.271884
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		1128	0	0	150050383000	1264961000	133023000	73455000000	1128	1	1128	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-13 10:30:55.159303	2024-07-13 10:33:00.410523
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	4	0	0	142146913000	103422185000	35536728000	3476000000	4	1	1644	411	0	0	4	0	4	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-13 10:32:06.398323	2024-07-13 10:32:47.457398
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		338	0	0	129912929000	1615936000	384357000	72776000000	0	0	1014	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-13 10:30:57.130689	2024-07-13 10:33:00.117777
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	192	0	0	120815069000	2480067000	629245000	41430000000	192	1	768	4	0	0	1344	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-13 10:30:57.145376	2024-07-13 10:33:00.310615
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		4	0	0	107544307000	49294468000	26886076000	1275000000	12	3	140	35	0	0	4	0	12	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-13 10:32:06.411559	2024-07-13 10:32:47.467716

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!