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.0033 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` ....	sys		22093	0	0	6067965389000	4085470000	274655000	3270928000000	22061	1	132462	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-27 22:31:02.810544	2024-06-27 22:39:14.039956
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	9	0	0	1474565022000	900120698000	163840558000	3302000000	78	9	56174	6242	0	0	51	6	3554	6	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-06-27 22:38:45.170669	2024-06-27 22:38:56.478914
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	30	0	2	831703590000	178431937000	27723453000	11070000000	140	5	460	15	0	0	80	0	1842	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-06-27 22:38:28.844699	2024-06-27 22:39:12.193485
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	9	0	0	766601243000	281378321000	85177915000	2933000000	78	9	2640	293	0	0	0	0	0	0	251552b68e8f44795ca803316d221e604ec58591e3d9d3654e...	2024-06-27 22:38:36.361313	2024-06-27 22:39:04.697917
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		641	0	0	722030139000	4822943000	1126412000	237544000000	39349	61	198668	310	0	0	641	0	39349	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-27 22:31:02.475820	2024-06-27 22:39:19.845809
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	1284	0	0	700574143000	2869733000	545618000	251261000000	11206	9	75845	59	0	0	2889	0	20486	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 22:31:02.592691	2024-06-27 22:39:19.981443
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	596	0	0	666006215000	2731579000	1117460000	75853000000	918	2	24780	42	0	0	582	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-06-27 22:31:01.720293	2024-06-27 22:39:19.580398
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		158	0	0	661930427000	256913535000	4189433000	57814000000	302	2	7477	47	0	0	158	0	302	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-27 22:31:03.355806	2024-06-27 22:39:19.950721
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	908	0	0	654205444000	7920375000	720490000	235226000000	8611	9	56106	62	0	0	2072	0	15918	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 22:31:01.616455	2024-06-27 22:39:18.921367
SELECT `performance_schema` . `events_statements_s...	sys	*	6	0	0	609107001000	594210773000	101517833000	950000000	52	9	1665	278	0	0	0	0	52	0	8b22b06fe671437418edb1a3633c0f481cc712f261f1eb7654...	2024-06-27 22:38:32.958463	2024-06-27 22:38:50.190936
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	Tf2	*	1066	0	0	594271383000	2872995000	557477000	220515000000	9429	9	61145	57	0	0	2311	0	16562	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 22:31:43.673935	2024-06-27 22:39:19.529920
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		37	0	0	577192074000	114239521000	15599785000	19203000000	93	3	1087	29	0	0	37	0	93	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-27 22:31:46.621589	2024-06-27 22:39:20.168423
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	640	0	0	538652924000	2652181000	841645000	56869000000	640	1	367360	574	0	0	640	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-27 22:31:02.467977	2024-06-27 22:39:19.970667
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	781	0	2	409327358000	1726066000	524106000	149328000000	7516	10	47628	61	0	0	1614	0	12810	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 22:31:03.153084	2024-06-27 22:39:20.003986
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	TOPPERSON	*	634	0	0	355902018000	2165823000	561359000	132357000000	5470	9	35916	57	0	0	1396	0	9984	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 22:32:07.126570	2024-06-27 22:39:00.713908
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	27	0	0	351292828000	325713408000	13010845000	9705000000	234	9	1152	43	0	0	0	0	0	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-27 22:38:17.404038	2024-06-27 22:39:19.693327
SHOW TABLES FROM `phpmyadmin`	NULL		1572	1572	0	348383488000	1183062000	221617000	141806000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-06-27 22:31:01.602712	2024-06-27 22:39:20.294740
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	321	0	0	339274755000	8831741000	1056930000	157294000000	321	1	44590	139	0	0	321	0	321	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-27 22:31:02.473558	2024-06-27 22:39:19.829416
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	Tf2	*	392	0	0	338915879000	24456565000	864581000	195128000000	315	1	6632	17	0	0	156	0	305	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-27 22:31:41.344191	2024-06-27 22:39:19.550134
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	822	0	0	332620461000	2663131000	404647000	137602000000	4611	6	29605	36	0	0	1003	0	7728	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 22:31:01.773257	2024-06-27 22:39:19.677413
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		468	0	0	314836350000	2311069000	672727000	160252000000	6813	15	32027	68	0	0	217	0	5059	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-27 22:31:01.722941	2024-06-27 22:39:19.631583
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		313	0	0	302924145000	2849372000	967808000	124249000000	11237	36	58124	186	0	0	255	0	11003	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-27 22:31:03.307112	2024-06-27 22:39:19.959454
CREATE TABLE `ALUNO` ( `NOME` VARCHARACTER (?) , `...	TOPPERSON		1	0	0	280671478000	280671478000	280671478000	134000000	0	0	0	0	0	0	0	0	0	0	ecbea690c26de125e4115f9157bd36ce6ca0add31a9f08bec4...	2024-06-27 22:37:03.779112	2024-06-27 22:37:03.779112
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		434	0	0	252034662000	1560609000	580725000	147476000000	0	0	1302	3	0	0	434	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-27 22:31:01.723955	2024-06-27 22:39:19.632702
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		665	0	0	243372694000	744751000	365973000	135401000000	0	0	1995	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-27 22:31:02.471390	2024-06-27 22:39:19.831353

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!