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.0031 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		44597	0	0	11144484052000	3400323000	249893000	5988196000000	44538	1	267405	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-23 05:31:02.788415	2024-06-23 05:40:01.490886
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ...	information_schema	*	10	0	0	2815171004000	814808471000	281517100000	706000000	250	25	250	25	0	0	10	10	0	0	9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...	2024-06-23 05:31:05.852718	2024-06-23 05:40:23.096247
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	2066	0	0	2182259424000	34354293000	1056272000	237881000000	3034	1	86674	42	0	0	2040	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-06-23 05:31:03.446027	2024-06-23 05:40:20.334277
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	17	0	0	1265408395000	262136840000	74435787000	4827000000	132	8	4367	257	0	0	1	0	0	0	251552b68e8f44795ca803316d221e604ec58591e3d9d3654e...	2024-06-23 05:31:28.456881	2024-06-23 05:38:43.243547
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	18	0	0	1118929633000	705724611000	62162757000	4864000000	156	9	74312	4128	0	0	86	12	6278	12	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-06-23 05:33:03.521100	2024-06-23 05:39:43.434807
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	42	0	7	993288117000	122736491000	23649717000	20274000000	254	6	527	13	0	0	112	0	2516	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-06-23 05:31:02.787464	2024-06-23 05:40:01.534516
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		972	0	0	981018325000	415794608000	1009278000	338385000000	78	0	4401	5	0	0	963	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-23 05:31:02.046773	2024-06-23 05:40:26.296585
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	2180	0	0	788502893000	7065637000	361698000	339992000000	10344	5	64360	30	0	0	2252	0	16320	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-23 05:31:02.125088	2024-06-23 05:40:26.328143
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		941	0	0	616373754000	2788917000	655019000	318485000000	12740	14	60345	64	0	0	487	0	9594	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-23 05:31:02.045871	2024-06-23 05:40:26.295792
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		223	0	0	545239071000	84746295000	2445018000	78257000000	400	2	8164	37	0	0	223	0	400	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-23 05:31:02.211516	2024-06-23 05:40:22.335600
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	1039	0	0	536862267000	2125837000	516710000	195548000000	8579	8	57450	55	0	0	2338	0	15600	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-23 05:31:01.940924	2024-06-23 05:40:27.275219
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		519	0	0	536472842000	6034544000	1033666000	186217000000	29874	58	150927	291	0	0	519	0	29874	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-23 05:31:01.812860	2024-06-23 05:40:27.153539
SHOW SESSION VARIABLES LIKE ?	information_schema	*	512	0	0	448720361000	30183200000	876406000	44496000000	512	1	293888	574	0	0	512	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-23 05:31:02.040801	2024-06-23 05:40:26.317275
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	518	0	0	430679367000	5104461000	831427000	47563000000	518	1	297332	574	0	0	518	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-23 05:31:01.788011	2024-06-23 05:40:27.263442
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	830	0	0	408295817000	5308154000	491922000	156995000000	7511	9	45065	54	0	0	1551	0	11580	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-23 05:31:02.261728	2024-06-23 05:40:27.898154
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	40	0	0	339132641000	301045515000	8478316000	13446000000	339	8	1765	44	0	0	1	0	1	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-23 05:31:03.400017	2024-06-23 05:37:38.732894
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		359	0	0	300090466000	7454517000	835906000	130830000000	10098	28	51545	144	0	0	284	0	9714	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-23 05:31:02.175010	2024-06-23 05:40:22.346789
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	260	0	0	274547623000	15235830000	1055952000	128294000000	260	1	35620	137	0	0	260	0	260	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-23 05:31:01.803667	2024-06-23 05:40:27.141815
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	157	0	0	235161962000	29343305000	1497846000	101484000000	8387	53	21884	139	0	0	12	0	8387	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-23 05:31:02.098309	2024-06-23 05:40:27.757126
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co...	information_schema	*	1612	0	0	231917112000	1357156000	143869000	139221000000	2175	1	2844	2	0	0	0	0	41	0	878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...	2024-06-23 05:31:04.414239	2024-06-23 05:40:20.280199
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		56	0	0	228978430000	83676911000	4088900000	19607000000	107	2	1310	23	0	0	56	0	107	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-23 05:31:07.315826	2024-06-23 05:39:50.692572
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	test19		7	0	0	215510622000	63210756000	30787231000	5004000000	14	2	125	18	0	0	7	0	14	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-23 05:31:07.369463	2024-06-23 05:31:07.522959
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	145	0	0	212740398000	28254944000	1467175000	57927000000	177	1	14741	102	0	0	144	0	177	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-23 05:31:02.158350	2024-06-23 05:40:22.345631
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		552	0	0	208473546000	6097532000	377669000	113957000000	0	0	1656	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-23 05:31:01.798703	2024-06-23 05:40:27.143519
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		494	0	0	205638740000	1556275000	416272000	112058000000	78	0	3495	7	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-23 05:31:02.044807	2024-06-23 05:40:26.339942

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!