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.0089 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` . ...	performance_schema	*	2110	0	0	1112638423000	3056954000	527316000	409465000000	17567	8	117543	56	0	0	4743	0	31980	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 06:16:01.270885	2024-07-01 06:21:33.919711
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1006	0	0	1050378069000	4061327000	1044113000	390323000000	50052	50	253024	252	0	0	995	0	49925	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 06:16:01.049106	2024-07-01 06:21:33.866206
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL		161	0	0	1039837231000	128128756000	6458616000	89956000000	333	2	5048	31	0	0	161	0	333	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 06:16:03.300404	2024-07-01 06:20:52.740914
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	856	0	0	899340625000	8218188000	1050631000	99556000000	1247	1	35646	42	0	0	839	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-01 06:16:01.271176	2024-07-01 06:21:24.308471
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	921	0	0	767948258000	5645083000	833820000	83805000000	921	1	528654	574	0	0	921	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-01 06:16:01.036724	2024-07-01 06:21:33.349851
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	557	0	0	658957262000	58370951000	1183047000	246026000000	2087	4	79521	143	0	0	547	0	2087	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 06:16:01.045669	2024-07-01 06:21:33.934853
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir...	sakila	*	2	0	0	559191427000	283250449000	279595713000	358000000	2	1	645797	322899	0	0	6	0	400	0	91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6...	2024-07-01 06:18:36.683276	2024-07-01 06:18:36.969959
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	230	0	0	547891266000	24090634000	2382135000	110105000000	2629	11	19714	86	0	0	185	0	2629	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 06:16:01.279687	2024-07-01 06:21:28.282682
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	897	0	0	527680937000	2564103000	588273000	201412000000	7422	8	50446	56	0	0	2019	0	13500	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 06:16:02.976948	2024-07-01 06:21:29.732238
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL		302	0	0	448833408000	5116276000	1486203000	177056000000	5212	17	27460	91	0	0	302	0	5212	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 06:16:03.288570	2024-07-01 06:20:52.746354
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		538	0	0	377201037000	2595695000	701117000	199845000000	1433	3	8420	16	0	0	538	0	1433	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 06:16:01.050727	2024-07-01 06:21:33.868962
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		994	0	0	367232931000	2231159000	369449000	204649000000	0	0	2982	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-01 06:16:01.042541	2024-07-01 06:21:33.932649
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	578	0	2	302683829000	3181160000	523674000	113098000000	5088	9	32811	57	0	0	1222	0	9000	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 06:16:01.470252	2024-07-01 06:21:33.519661
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		100	0	0	285802805000	105356277000	2858028000	34048000000	208	2	5904	59	0	0	100	0	208	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 06:16:01.415563	2024-07-01 06:21:33.403680
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	651	0	0	283003961000	2216826000	434721000	113556000000	3945	6	25264	39	0	0	902	0	6720	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 06:16:01.351085	2024-07-01 06:21:28.387516
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	533	0	0	281559035000	1790571000	528253000	101332000000	533	1	2132	4	0	0	3731	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-01 06:16:01.323951	2024-07-01 06:21:33.936116
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		409	0	0	272720569000	2872075000	666798000	136704000000	5822	14	27505	67	0	0	201	0	4351	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 06:16:01.277398	2024-07-01 06:21:28.340086
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	NULL	*	155	0	0	256870463000	7494697000	1657228000	31911000000	42160	272	48515	313	0	0	155	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-01 06:16:03.313997	2024-07-01 06:20:52.762084
SHOW TABLES FROM `phpmyadmin`	NULL		1084	1084	0	239554976000	710676000	220991000	98009000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-01 06:16:01.012649	2024-07-01 06:21:34.192616
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		402	0	0	233196271000	1645627000	580090000	137259000000	0	0	1206	3	0	0	402	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 06:16:01.278318	2024-07-01 06:21:28.340945
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		204	0	0	194589921000	2458808000	953872000	72061000000	8870	43	45294	222	0	0	188	0	8792	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 06:16:01.309917	2024-07-01 06:21:33.415804
SHOW SESSION VARIABLES LIKE ?	information_schema	*	224	0	0	194181718000	2405785000	866882000	19683000000	224	1	128576	574	0	0	224	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-01 06:16:01.269276	2024-07-01 06:21:28.376012
SELECT `concat` ( `c` . `city` , (_charset) ? , `c...	sakila	*	2	0	4	191712026000	147308683000	95856013000	730000000	2	1	3	2	0	0	2	0	4	0	e93a551af16493cd58cb06c9b4b21c3e15c6db7cb66f6c868e...	2024-07-01 06:20:12.622715	2024-07-01 06:20:12.691752
SHOW SESSION VARIABLES LIKE ?	mysql	*	203	0	0	178289980000	2605459000	878275000	18242000000	203	1	116522	574	0	0	203	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-01 06:16:03.319137	2024-07-01 06:21:33.484389
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	pw		20	0	0	173748146000	50319519000	8687407000	7447000000	40	2	412	21	0	0	20	0	40	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 06:20:13.715701	2024-07-01 06:20:17.978129

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!