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.0065 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		6552	0	0	7773063907000	8450315000	1186365000	2570166000000	419290	64	2116106	323	0	0	6552	0	419290	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-30 12:16:01.410323	2024-07-30 12:27:29.388967
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		5937	0	0	7370604857000	7873908000	1241469000	2530500000000	300798	51	1534691	258	0	0	5908	0	300722	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-30 12:16:01.552545	2024-07-30 12:27:29.892945
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	12868	0	66	7315502971000	6179313000	568503000	3216628000000	50043	4	297501	23	0	0	28829	0	79043	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 12:16:01.709484	2024-07-30 12:27:30.027476
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	13127	0	0	6465433081000	3895681000	492529000	2801274000000	48571	4	297326	23	0	0	29536	0	77452	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 12:16:01.483554	2024-07-30 12:27:29.563691
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	6564	0	0	5492619695000	7666381000	836779000	590171000000	6564	1	3767736	574	0	0	6564	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-30 12:16:01.384460	2024-07-30 12:27:29.535614
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		11921	0	0	5036895103000	7397385000	422522000	2845323000000	0	0	35763	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-30 12:16:01.551506	2024-07-30 12:27:29.886958
SHOW SESSION VARIABLES LIKE ?	mysql	*	4708	0	0	4440588439000	10669330000	943200000	425317000000	4708	1	2702392	574	0	0	4708	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-30 12:16:01.549634	2024-07-30 12:27:30.001023
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	3282	0	0	3809951183000	5433022000	1160862000	1661402000000	3282	1	697244	212	0	0	3282	0	3282	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 12:16:01.397352	2024-07-30 12:27:29.360231
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	2958	0	0	3794737288000	394499944000	1282872000	1502865000000	3438	1	567190	192	0	0	2946	0	3438	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 12:16:01.636428	2024-07-30 12:27:29.888179
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		7080	0	0	2974536094000	4406626000	420132000	1703431000000	0	0	21240	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-30 12:16:01.392092	2024-07-30 12:27:29.361551
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		2943	0	0	2426236762000	67871355000	824409000	1177851000000	5896	2	194003	66	0	0	2943	0	5896	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-30 12:16:01.604866	2024-07-30 12:27:29.870836
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	1817	0	0	2228427640000	7048540000	1226432000	244311000000	2687	1	76159	42	0	0	1792	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-30 12:16:10.773346	2024-07-30 12:27:20.662948
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		3282	0	0	2221493441000	4708643000	676871000	1170043000000	9672	3	55098	17	0	0	3282	0	9672	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-30 12:16:01.411711	2024-07-30 12:27:29.363634
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	3246	0	0	2061729631000	8133944000	635160000	706593000000	3246	1	12984	4	0	0	22722	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-30 12:16:01.736533	2024-07-30 12:27:30.045766
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	1986	0	0	1856742373000	4446419000	934915000	994271000000	65089	33	337606	170	0	0	174	0	65089	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 12:16:04.031074	2024-07-30 12:27:30.112534
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	2554	0	0	1449158181000	3567325000	567407000	622914000000	11620	5	69328	27	0	0	5858	0	19611	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 12:16:01.704070	2024-07-30 12:27:30.095242
SHOW CREATE TABLE `mysql` . `user`	mysql		2936	0	0	1356399247000	114643202000	461988000	0	0	0	0	0	0	0	0	0	0	0	9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2...	2024-07-30 12:16:01.606811	2024-07-30 12:27:29.872681
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	2236	0	0	1328608815000	3811760000	594189000	481150000000	2236	1	8944	4	0	0	15652	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-30 12:16:01.505624	2024-07-30 12:27:28.638816
SHOW TABLES FROM `phpmyadmin`	NULL		8853	8853	0	1259604375000	2306668000	142279000	516383000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-30 12:16:01.358480	2024-07-30 12:27:30.128395
DROP SCHEMA `sakila`	NULL		1	0	0	1187728208000	1187728208000	1187728208000	1342000000	0	0	0	0	23	23	0	0	0	0	a2587d785e1d8a8fd35a0bd14178b03ec5347fc6801413c03b...	2024-07-30 12:17:38.377472	2024-07-30 12:17:38.377472
ALTER TABLE `tblbloodgroup` ADD PRIMARY KEY ( `id`...	bbdms		2	0	2	1132529575000	630771526000	566264787000	254000000	0	0	0	0	0	0	0	0	0	0	796fbf91263655f842e5ae7b450a019817c854cf465942d075...	2024-07-30 12:19:47.949370	2024-07-30 12:25:07.515044
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	2819	0	0	995109827000	4744655000	353001000	233407000000	70475	25	70475	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-07-30 12:16:01.853058	2024-07-30 12:27:29.036654
ALTER TABLE `tblblooddonars` ADD PRIMARY KEY ( `id...	bbdms		2	0	0	982916513000	529488136000	491458256000	217000000	0	0	0	0	0	0	0	0	0	0	25a404ff480bd579b438048a6c7dcd0b2453bbceae58ceaa0a...	2024-07-30 12:19:47.314544	2024-07-30 12:25:07.009236
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		7294	0	0	978520502000	954737000	134154000	489788000000	7294	1	7294	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-30 12:16:01.375409	2024-07-30 12:27:30.154492
ALTER TABLE `tblbloodrequirer` ADD PRIMARY KEY ( `...	bbdms		2	0	0	970754607000	510732045000	485377303000	211000000	0	0	0	0	0	0	0	0	0	0	ca322073f11b0980a13ad8cb50f9e75173687fcb4973180fba...	2024-07-30 12:19:48.417338	2024-07-30 12:25:08.030272

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!