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.8832 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		4256	0	0	1051506264000	1911927000	247064000	569850000000	4248	1	25512	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-27 23:31:34.933299	2024-06-27 23:39:30.539234
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	1058	0	0	543836275000	3412014000	514022000	196352000000	9318	9	63059	60	0	0	2381	0	17050	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 23:31:02.574627	2024-06-27 23:41:47.101271
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		528	0	0	526491408000	2745791000	997142000	180973000000	30076	57	151964	288	0	0	528	0	30076	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-27 23:31:02.453095	2024-06-27 23:41:46.977132
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	639	0	0	470753844000	5869078000	736703000	168416000000	6215	10	40510	63	0	0	1461	0	11518	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 23:31:02.236537	2024-06-27 23:41:45.861346
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	526	0	0	434288600000	4153103000	825643000	48288000000	526	1	301924	574	0	0	526	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-27 23:31:02.435528	2024-06-27 23:41:47.087599
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		27	0	0	416906916000	88368434000	15440996000	11629000000	49	2	600	22	0	0	27	0	49	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-27 23:31:05.308923	2024-06-27 23:41:40.663908
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	367	0	0	367869932000	2987054000	1002370000	44567000000	804	2	15072	41	0	0	348	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-06-27 23:31:03.146162	2024-06-27 23:41:22.211161
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	265	0	0	317483263000	9900001000	1198050000	116776000000	265	1	108861	411	0	0	265	0	265	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-27 23:31:02.450009	2024-06-27 23:41:46.965600
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	502	0	7	275904844000	2160815000	549611000	99500000000	5068	10	31870	63	0	0	1111	0	8769	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 23:31:03.086487	2024-06-27 23:41:47.668496
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	12	0	3	269590305000	72835019000	22465858000	5300000000	38	3	201	17	0	0	32	0	708	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-06-27 23:31:34.925600	2024-06-27 23:39:30.585639
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		82	0	0	233971970000	69162279000	2853316000	28380000000	166	2	5261	64	0	0	82	0	166	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-27 23:31:04.201699	2024-06-27 23:41:47.595822
SHOW TABLES FROM `phpmyadmin`	NULL		994	994	0	221860112000	1561992000	223199000	90934000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-06-27 23:31:02.182578	2024-06-27 23:41:48.352436
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	universidad		10	0	0	213667409000	132476158000	21366740000	4883000000	10	1	35	4	0	0	5	0	0	0	251552b68e8f44795ca803316d221e604ec58591e3d9d3654e...	2024-06-27 23:38:44.182741	2024-06-27 23:40:40.133168
CREATE TABLE `Funcionarios` ( `id` INTEGER AUTO_IN...	devv		2	1	0	212516261000	211736562000	106258130000	572000000	0	0	0	0	0	0	0	0	0	0	6f2f02adab0e958bb9d8af1407bbb516d7dec125af812b0cda...	2024-06-27 23:36:18.584145	2024-06-27 23:37:11.548337
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		543	0	0	196575424000	1340770000	362017000	108885000000	0	0	1629	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-27 23:31:02.439571	2024-06-27 23:41:46.966944
CREATE TABLE `universidad` . `Alumnos` ( `id de es...	universidad		1	0	0	192880739000	192880739000	192880739000	98000000	0	0	0	0	0	0	0	0	0	0	7f3a75263db1e907ce97e025f04393dc612cf56307fb3f8396...	2024-06-27 23:38:43.609240	2024-06-27 23:38:43.609240
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		183	0	0	180828577000	3084626000	988134000	67301000000	8556	47	44115	241	0	0	170	0	8522	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-27 23:31:03.036385	2024-06-27 23:41:47.608379
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	20	0	0	179757630000	43675000000	8987881000	12279000000	20	1	8237	412	0	0	20	0	20	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-27 23:31:05.282346	2024-06-27 23:41:40.660428
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	Universidad	*	320	0	0	172631840000	1428450000	539474000	65274000000	2690	8	17870	56	0	0	711	0	4898	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 23:31:39.560268	2024-06-27 23:33:27.240816
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		265	0	0	166705161000	3509652000	629076000	86812000000	785	3	4465	17	0	0	265	0	785	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-27 23:31:02.454338	2024-06-27 23:41:46.968915
SHOW SESSION VARIABLES LIKE ?	mysql	*	190	0	0	159336487000	2632940000	838613000	17048000000	190	1	109060	574	0	0	190	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-27 23:31:04.173207	2024-06-27 23:41:47.656079
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	86	0	0	154829934000	19730701000	1800348000	38645000000	246	3	34508	401	0	0	81	0	246	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-27 23:31:04.240392	2024-06-27 23:41:47.607091
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	424	0	0	152766870000	1714632000	360299000	62226000000	2347	6	14950	35	0	0	492	0	3874	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-27 23:31:03.195426	2024-06-27 23:41:43.858777
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	265	0	0	142558798000	2621344000	537957000	52346000000	265	1	1060	4	0	0	1855	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-06-27 23:31:02.596852	2024-06-27 23:41:47.114506
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	Universidad	*	147	0	0	139127894000	4543640000	946448000	83875000000	0	0	12338	84	0	0	32	0	0	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-27 23:31:26.286540	2024-06-27 23:33:27.253598

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!