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.

Your SQL query has been executed successfully.

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		5090	0	0	1745172269000	12314084000	342862000	958942000000	5082	1	30516	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:03:34.734570	2025-07-01 00:04:06.145268
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	12	0	1	890038224000	530428867000	74169852000	3910000000	104	9	72081	6007	0	0	68	8	3084	8	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2025-07-01 00:03:34.876784	2025-07-01 00:04:06.169688
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	461	0	5	289788447000	3113995000	628608000	103463000000	4333	9	27440	60	0	0	1034	0	7555	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:02:04.413736	2025-07-01 00:06:26.681274
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		169	0	0	240287808000	3974229000	1421821000	83834000000	8619	51	43940	260	0	0	169	0	8619	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-01 00:02:04.298427	2025-07-01 00:06:26.650832
SHOW SESSION VARIABLES LIKE ?	mysql	*	197	0	0	219223309000	5577338000	1112808000	20702000000	197	1	113078	574	0	0	197	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-01 00:02:04.295176	2025-07-01 00:06:26.063268
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		8	0	0	203432480000	74231440000	25429060000	6090000000	11	1	161	20	0	0	8	0	11	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:03:09.831134	2025-07-01 00:04:44.241265
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		417	0	0	183696560000	1599473000	440519000	103374000000	0	0	1251	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:02:04.297328	2025-07-01 00:06:26.684381
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		98	0	0	146121218000	3287822000	1491032000	49034000000	6072	62	30654	313	0	0	98	0	6072	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-01 00:02:04.153606	2025-07-01 00:06:25.660936
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	162	0	0	133638985000	4492250000	824932000	46771000000	1516	9	10023	62	0	0	370	0	2800	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:02:07.780329	2025-07-01 00:06:27.886533
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	196	0	0	116160204000	1849175000	592654000	39991000000	1640	8	11013	56	0	0	441	0	2986	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:02:04.263335	2025-07-01 00:06:25.715875
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	98	0	0	108205370000	6497230000	1104136000	12094000000	98	1	56252	574	0	0	98	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-01 00:02:04.133662	2025-07-01 00:06:25.707684
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	85	0	0	104259014000	14121042000	1226576000	44698000000	85	1	8615	101	0	0	85	0	85	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:02:04.360977	2025-07-01 00:06:26.685820
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		85	0	0	103494600000	25607947000	1217583000	41738000000	170	2	5608	66	0	0	85	0	170	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:02:04.324259	2025-07-01 00:06:26.652476
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	59	0	0	92271678000	3002231000	1563926000	11622000000	128	2	2424	41	0	0	56	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2025-07-01 00:03:15.448627	2025-07-01 00:06:27.476909
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	49	0	0	74374338000	4389761000	1517843000	33454000000	49	1	6736	137	0	0	49	0	49	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:02:04.148310	2025-07-01 00:06:25.657847
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	mysql	*	35	0	0	70340631000	4059777000	2009732000	8125000000	9520	272	10955	313	0	0	35	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2025-07-01 00:02:07.206506	2025-07-01 00:06:20.419317
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	123	0	0	66223195000	1191438000	538399000	21920000000	123	1	492	4	0	0	861	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2025-07-01 00:02:04.421499	2025-07-01 00:06:26.687024
CREATE SCHEMA `mtaserver` DEFAULT CHARSET = `utf8m...	NULL		1	0	0	65082362000	65082362000	65082362000	7602000000	0	0	0	0	1	1	0	0	0	0	06100da86a80060bae762d1586ad2f11253ee01766f72fa260...	2025-07-01 00:04:39.026649	2025-07-01 00:04:39.026649
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		101	0	0	58270060000	3102815000	576931000	30872000000	0	0	303	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:02:04.143174	2025-07-01 00:06:25.655028
SHOW TABLES FROM `phpmyadmin`	NULL		267	267	0	55895558000	1177295000	209346000	23522000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2025-07-01 00:02:04.113370	2025-07-01 00:06:33.180563
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	68	0	0	46995321000	1743680000	691107000	15207000000	68	1	272	4	0	0	476	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2025-07-01 00:02:07.789714	2025-07-01 00:06:27.891343
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		49	0	0	46970459000	2061843000	958580000	23795000000	146	3	829	17	0	0	49	0	146	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:02:04.155808	2025-07-01 00:06:25.638370
SELECT ? FROM `sakila` . `city` LIMIT ?	sakila		2	0	0	46316755000	46158905000	23158377000	448000000	2	1	2	1	0	0	0	0	0	0	09bdb47922bd9488efa9aece2088049088adeb5017089a26f7...	2025-07-01 00:03:09.754433	2025-07-01 00:03:09.936854
SET `lc_messages` = ?	NULL		267	0	0	43747695000	5008203000	163849000	0	0	0	0	0	0	0	0	0	0	0	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	2025-07-01 00:02:04.110973	2025-07-01 00:06:33.179291
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		250	0	0	39790608000	954483000	159162000	19430000000	250	1	250	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2025-07-01 00:02:04.124318	2025-07-01 00:06:33.194909

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-5377-g8e721911f0 from the master branch.