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.0253 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` . ...	mysql	*	542	0	9	313923897000	4461744000	579195000	116102000000	5357	10	33126	61	0	0	1197	0	9103	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 18:15:56.249118	2024-07-30 18:16:59.697449
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	433	0	0	296565098000	5933162000	684907000	108342000000	4095	9	27164	63	0	0	987	0	7566	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 18:15:56.068032	2024-07-30 18:16:58.966424
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		200	0	0	200885551000	2820357000	1004427000	72146000000	9861	49	50350	252	0	0	198	0	9853	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-30 18:15:56.127212	2024-07-30 18:16:59.570743
SHOW SESSION VARIABLES LIKE ?	mysql	*	217	0	0	199445666000	3713852000	919104000	19460000000	217	1	124558	574	0	0	217	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-30 18:15:56.123321	2024-07-30 18:16:59.617181
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		152	0	0	174650026000	3791940000	1149013000	59916000000	9688	64	48896	322	0	0	152	0	9688	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-30 18:15:56.338124	2024-07-30 18:16:59.931830
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		476	0	0	165537547000	1250751000	347767000	92463000000	0	0	1428	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-30 18:15:56.125883	2024-07-30 18:16:59.568661
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	304	0	0	164025611000	1592700000	539557000	59758000000	2604	9	17544	58	0	0	684	0	4752	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 18:15:56.472683	2024-07-30 18:17:00.071212
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		96	0	0	143015500000	53995926000	1489744000	35564000000	194	2	6317	66	0	0	96	0	194	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-30 18:15:56.151805	2024-07-30 18:16:59.558729
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	152	0	0	130725395000	2790337000	860035000	13826000000	152	1	87248	574	0	0	152	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-30 18:15:56.319080	2024-07-30 18:17:00.054605
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	104	0	0	124038723000	22056039000	1192680000	44006000000	332	3	11221	108	0	0	96	0	332	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 18:15:56.186996	2024-07-30 18:16:59.569599
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	174	0	0	96279520000	1997691000	553330000	31829000000	174	1	696	4	0	0	1218	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-30 18:15:56.087995	2024-07-30 18:16:58.981691
SHOW TABLES FROM `phpmyadmin`	NULL		433	433	0	85961730000	604732000	198525000	35298000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-30 18:15:56.059410	2024-07-30 18:17:00.504142
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	141	0	0	82854266000	1376383000	587618000	29262000000	141	1	564	4	0	0	987	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-30 18:15:56.271805	2024-07-30 18:16:59.707589
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	76	0	0	79921028000	1884475000	1051592000	36470000000	76	1	10508	138	0	0	76	0	76	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 18:15:56.335934	2024-07-30 18:16:59.920338
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	63	0	0	79247960000	4283772000	1257904000	40576000000	1281	20	7846	125	0	0	21	0	1281	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 18:15:56.382993	2024-07-30 18:16:59.518805
CREATE SCHEMA `practice` DEFAULT CHARSET = `utf8mb...	NULL		1	0	0	71755731000	71755731000	71755731000	2371000000	0	0	0	0	1	1	0	0	0	0	abd8cef4129bba5007bc117204d35a810d1e4aba4b3e01d76f...	2024-07-30 18:16:46.028832	2024-07-30 18:16:46.028832
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		1	0	0	67029410000	67029410000	67029410000	317000000	4	4	45	45	0	0	1	0	4	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-30 18:16:03.259153	2024-07-30 18:16:03.259153
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		164	0	0	66236814000	1854744000	403883000	36561000000	0	0	492	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-30 18:15:56.334665	2024-07-30 18:16:59.922034
SET `lc_messages` = ?	NULL		398	0	0	63642656000	10807886000	159906000	0	0	0	0	0	0	0	0	0	0	0	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	2024-07-30 18:15:56.058606	2024-07-30 18:17:00.503738
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		398	0	0	54528237000	420155000	137005000	26677000000	398	1	398	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-30 18:15:56.087166	2024-07-30 18:17:00.521538
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	StdMdDB	*	3	0	0	52560270000	51027756000	17520090000	1417000000	12	4	90	30	0	0	1	0	12	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 18:16:54.959473	2024-07-30 18:16:55.116779
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	mysql	*	35	0	0	51273205000	4104472000	1464948000	6865000000	9520	272	10955	313	0	0	35	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-30 18:16:02.853059	2024-07-30 18:16:59.657648
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		76	0	0	50781123000	1117214000	668172000	27193000000	225	3	1280	17	0	0	76	0	225	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-30 18:15:56.339272	2024-07-30 18:16:59.924048
CREATE SCHEMA `codeyad` DEFAULT CHARSET = `utf8mb4...	NULL		2	1	0	46718249000	46605419000	23359124000	103000000	0	0	0	0	1	1	0	0	0	0	062cb11326ea6fb117945303a3a6c5984104235b175fd8f858...	2024-07-30 18:15:56.207904	2024-07-30 18:15:57.177417
SELECT @@`version` , @@`version_comment`	NULL		433	0	0	44434492000	316688000	102620000	0	433	1	433	1	0	0	0	0	0	0	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	2024-07-30 18:15:56.058313	2024-07-30 18:17:00.503369

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!