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.3962 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		1425	0	0	1806235984000	12130464000	1267534000	586067000000	93428	66	471415	331	0	0	1425	0	93428	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-11 08:15:56.383738	2024-07-11 08:18:17.137149
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	2844	0	0	1783168869000	5975385000	626993000	668018000000	24013	8	160981	57	0	0	6399	0	43760	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 08:15:56.505489	2024-07-11 08:18:16.860131
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1424	0	0	1286775389000	6125730000	903634000	130105000000	1424	1	817376	574	0	0	1424	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-11 08:15:56.369501	2024-07-11 08:18:17.117083
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1930	0	10	1233851025000	4398119000	639301000	457976000000	17111	9	111255	58	0	0	4318	0	30480	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 08:15:57.329461	2024-07-11 08:18:17.151107
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		870	0	0	1030843132000	6590865000	1184877000	356614000000	44101	51	224880	258	0	0	868	0	44093	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-11 08:15:57.207131	2024-07-11 08:18:17.116944
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	438	0	0	909075454000	421411871000	2075514000	213153000000	534	1	44939	103	0	0	436	0	534	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 08:15:57.263816	2024-07-11 08:18:17.115440
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	713	0	0	794896566000	8128355000	1114861000	352910000000	713	1	98232	138	0	0	713	0	713	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 08:15:56.380330	2024-07-11 08:18:17.119884
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1742	0	0	682947912000	2064028000	392048000	386153000000	0	0	5226	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-11 08:15:57.206105	2024-07-11 08:18:17.114156
SHOW SESSION VARIABLES LIKE ?	mysql	*	699	0	0	636320318000	3336314000	910329000	64651000000	699	1	401226	574	0	0	699	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-11 08:15:57.204174	2024-07-11 08:18:17.103424
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1486	0	0	597464091000	2974789000	402061000	336242000000	0	0	4458	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-11 08:15:56.375996	2024-07-11 08:18:17.121696
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		713	0	0	503472036000	4858334000	706131000	261849000000	2120	3	12045	17	0	0	713	0	2120	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-11 08:15:56.384976	2024-07-11 08:18:17.123927
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	698	0	0	431035736000	2825216000	617529000	149773000000	698	1	2792	4	0	0	4886	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-11 08:15:56.528083	2024-07-11 08:18:16.873987
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		438	0	0	420781870000	75159871000	960689000	169157000000	866	2	28517	65	0	0	438	0	866	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-11 08:15:57.235875	2024-07-11 08:18:17.092047
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	267	0	0	348826659000	5899314000	1306466000	36699000000	313	1	11178	42	0	0	265	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-11 08:15:56.585444	2024-07-11 08:18:09.378233
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	486	0	0	294181034000	2653814000	605310000	101489000000	486	1	1944	4	0	0	3402	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-11 08:15:57.351788	2024-07-11 08:18:17.170027
SHOW TABLES FROM `phpmyadmin`	NULL		1378	1378	0	217992983000	1724331000	158195000	90129000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-11 08:15:56.346914	2024-07-11 08:18:17.088219
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	653	0	0	204927681000	3514717000	313824000	46892000000	16325	25	16325	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-07-11 08:15:56.372352	2024-07-11 08:18:17.117761
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	653	0	0	201953411000	2068940000	309270000	26691000000	653	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-07-11 08:15:56.381249	2024-07-11 08:18:17.120355
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL		199	0	0	198374038000	4834688000	996854000	100899000000	7110	36	35600	179	0	0	0	0	7110	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 08:15:57.571805	2024-07-11 08:18:13.088192
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		1223	0	0	178161496000	3298424000	145675000	87194000000	1223	1	1223	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-11 08:15:56.363493	2024-07-11 08:18:17.115758
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		653	0	0	156381324000	2888063000	239481000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-07-11 08:15:56.386819	2024-07-11 08:18:17.127200
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	223	0	0	136948600000	4676670000	614119000	55185000000	1619	7	10604	48	0	0	393	0	2886	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 08:15:56.646781	2024-07-11 08:18:09.332642
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		8	0	0	130891842000	58656051000	16361480000	3484000000	20	3	242	30	0	0	8	0	20	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-11 08:16:03.415031	2024-07-11 08:18:15.087376
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		159	0	0	123166228000	3045530000	774630000	61824000000	2769	17	13304	84	0	0	86	0	2260	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-11 08:15:56.573037	2024-07-11 08:18:09.275738
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ...	mysql	*	436	0	0	117691132000	1777119000	269933000	28332000000	436	1	75428	173	0	0	436	0	0	0	cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...	2024-07-11 08:15:57.352301	2024-07-11 08:18:15.774692

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!