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` ....	mysql		220	0	0	1509271037000	126426209000	6860322000	146495000000	453	2	12344	56	0	0	220	0	453	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:15:48.977828	2025-07-01 00:25:21.650737
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	210	0	0	925435198000	565650550000	4406834000	116253000000	1170	6	83390	397	0	0	186	0	1171	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:15:49.055052	2025-07-01 00:25:21.661762
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		2441	0	0	644664702000	1634405000	264098000	350999000000	2437	1	14634	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:16:31.824640	2025-07-01 00:25:12.502448
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		431	0	0	588145359000	7045436000	1364606000	220268000000	18107	42	92060	214	0	0	390	0	17800	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-01 00:15:48.947689	2025-07-01 00:25:21.663090
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1018	0	2	579710586000	3454543000	569460000	204838000000	9593	9	62834	62	0	0	2280	0	17243	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:15:49.128641	2025-07-01 00:25:21.697421
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	3	0	1	556488835000	522308919000	185496278000	504000000	26	9	19220	6407	0	0	17	2	1370	2	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2025-07-01 00:25:05.942557	2025-07-01 00:25:06.470696
CREATE TABLE `Prestamo` ( `ID_Prestamo` INTEGER PR...	prestamos_biblioteca		1	0	0	470450489000	470450489000	470450489000	550000000	0	0	0	0	0	0	0	0	0	0	23d94baf10d266885b9bb79c33456286d083675678d3978bec...	2025-07-01 00:19:06.844966	2025-07-01 00:19:06.844966
SHOW SESSION VARIABLES LIKE ?	mysql	*	416	0	0	460879483000	3903040000	1107883000	44400000000	416	1	238784	574	0	0	416	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-01 00:15:48.944856	2025-07-01 00:25:21.691113
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		866	0	0	433676081000	2055251000	500780000	242043000000	0	0	2598	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:15:48.946728	2025-07-01 00:25:21.660503
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	148	0	0	397342263000	88890791000	2684745000	98012000000	1984	13	60775	411	0	0	133	0	1984	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:15:48.653319	2025-07-01 00:25:17.612479
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		255	0	0	378153961000	3921056000	1482956000	129463000000	14775	58	74640	293	0	0	255	0	14775	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-01 00:15:48.656939	2025-07-01 00:25:17.622880
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	387	0	0	372157955000	4055819000	961648000	130782000000	3871	10	25140	65	0	0	888	0	7196	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:15:49.245188	2025-07-01 00:25:13.158385
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	542	0	0	269116916000	3203066000	496525000	95514000000	4690	9	31533	58	0	0	1210	0	8568	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:15:48.771103	2025-07-01 00:25:17.719895
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	249	0	0	254141977000	4352367000	1020650000	27516000000	249	1	142926	574	0	0	249	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-01 00:15:48.640528	2025-07-01 00:25:17.713826
CREATE TABLE `Alumno` ( `ID_Alumno` INTEGER PRIMAR...	prestamos_biblioteca		1	0	0	203022985000	203022985000	203022985000	575000000	0	0	0	0	0	0	0	0	0	0	aca583164bcac83128471db64d6c55e00181c272ab08f6f152...	2025-07-01 00:19:06.358468	2025-07-01 00:19:06.358468
CREATE TABLE `Libro` ( `ID_Libro` INTEGER PRIMARY ...	prestamos_biblioteca		1	0	0	201951215000	201951215000	201951215000	140000000	0	0	0	0	0	0	0	0	0	0	8f478c262883079cd57d2c12c3949c79639cde2eb055f6b024...	2025-07-01 00:19:06.137160	2025-07-01 00:19:06.137160
SHOW TABLES FROM `phpmyadmin`	NULL		650	650	0	174145086000	1709532000	267915000	71111000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2025-07-01 00:15:48.628349	2025-07-01 00:25:22.089246
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		3	0	0	173708097000	66131729000	57902699000	1732000000	10	3	95	32	0	0	3	0	10	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:15:55.725546	2025-07-01 00:24:56.449691
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	109	0	0	171800710000	4821576000	1576153000	90931000000	4381	40	14884	137	0	0	2	0	4381	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:17:16.437159	2025-07-01 00:24:55.758639
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	132	0	0	157453509000	3784966000	1192829000	19280000000	2312	18	7396	56	0	0	124	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2025-07-01 00:16:04.413037	2025-07-01 00:25:21.433945
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		257	0	0	141627066000	2229193000	551078000	78050000000	0	0	771	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:15:48.646782	2025-07-01 00:25:17.613999
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	mysql	*	74	0	0	138868919000	3999635000	1876607000	20369000000	20128	272	23162	313	0	0	74	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2025-07-01 00:15:52.215011	2025-07-01 00:25:16.089692
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	272	0	0	137577081000	1774138000	505798000	44975000000	272	1	1088	4	0	0	1904	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2025-07-01 00:15:49.135537	2025-07-01 00:25:21.699490
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		128	0	0	126929626000	2614540000	991637000	66301000000	384	3	2182	17	0	0	128	0	384	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:15:48.658899	2025-07-01 00:25:17.615816
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	143	0	0	116852207000	2072577000	817148000	37834000000	143	1	572	4	0	0	1001	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2025-07-01 00:15:49.253672	2025-07-01 00:25:13.161496

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.