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.0081 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` . ...	mysql	*	3056	0	22	1802448940000	5394525000	589806000	658667000000	28221	9	182480	60	0	0	6813	0	49895	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 19:00:56.492274	2024-07-30 19:14:33.528893
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	2929	0	0	1664512580000	5677239000	568286000	610575000000	25473	9	171664	59	0	0	6588	0	46552	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 19:01:02.619175	2024-07-30 19:14:33.636062
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1465	0	0	1649430976000	4719550000	1125891000	561032000000	92404	63	466415	318	0	0	1465	0	92404	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-30 19:01:02.400271	2024-07-30 19:14:33.668749
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1383	0	0	1471665840000	10539095000	1064111000	526233000000	68542	50	349920	253	0	0	1375	0	68514	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-30 19:00:56.370159	2024-07-30 19:14:31.675471
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1464	0	0	1244404259000	3454128000	850002000	133369000000	1464	1	840336	574	0	0	1464	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-30 19:01:02.387011	2024-07-30 19:14:33.647107
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	1555	0	0	1181173524000	5178705000	759597000	421146000000	15855	10	102688	66	0	0	3577	0	29534	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-30 19:00:56.886114	2024-07-30 19:14:33.293108
SHOW SESSION VARIABLES LIKE ?	mysql	*	1323	0	0	1156793395000	19605436000	874371000	119690000000	1323	1	759402	574	0	0	1323	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-30 19:00:56.366213	2024-07-30 19:14:33.502922
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		3209	0	0	1125336971000	1941831000	350681000	627709000000	0	0	9627	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-30 19:00:56.368649	2024-07-30 19:14:31.673132
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		4366	0	0	1121105956000	2004694000	256781000	598508000000	4354	1	26160	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-30 19:00:56.603360	2024-07-30 19:14:08.817588
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	736	0	0	838122480000	93964065000	1138753000	336190000000	1042	1	102805	140	0	0	734	0	1042	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 19:01:02.396597	2024-07-30 19:14:33.649648
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	693	0	0	708625364000	23846396000	1022547000	291758000000	1332	2	72993	105	0	0	672	0	1332	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 19:00:56.434993	2024-07-30 19:14:31.674132
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		672	0	0	658795548000	49942496000	980350000	246192000000	1350	2	44137	66	0	0	672	0	1350	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-30 19:00:56.406544	2024-07-30 19:14:31.663520
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	542	0	0	645363423000	15945376000	1190707000	329764000000	14475	27	73778	136	0	0	110	0	14475	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-30 19:00:56.345917	2024-07-30 19:14:32.646532
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1634	0	0	617929797000	1765341000	378170000	347275000000	0	0	4902	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-30 19:01:02.394520	2024-07-30 19:14:33.651470
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	489	0	0	558955941000	6269374000	1143059000	64877000000	967	2	20647	42	0	0	480	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-30 19:00:56.685809	2024-07-30 19:14:31.902999
SELECT `performance_schema` . `events_statements_s...	sys	*	3	0	0	551621530000	548128457000	183873843000	627000000	2	1	1259	420	0	0	0	0	2	0	2065af6324dac0ebf77ee48e1b4d06340dbf289baf2feb5f91...	2024-07-30 19:11:54.600219	2024-07-30 19:11:54.667918
ALTER TABLE `stud` DROP `password`	college		2	0	0	547517206000	305102195000	273758603000	222000000	0	0	0	0	0	0	0	0	0	0	2ecea1b33236d61d8bc6792040acbef33e2920ab869dc0383e...	2024-07-30 19:07:01.522202	2024-07-30 19:11:22.215503
SHOW TABLES FROM `phpmyadmin`	NULL		2390	2390	0	503021301000	855299000	210469000	204582000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-30 19:00:56.340826	2024-07-30 19:14:33.647281
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		733	0	0	487743846000	5443514000	665407000	261595000000	2146	3	12249	17	0	0	733	0	2146	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-30 19:01:02.402894	2024-07-30 19:14:33.660769
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	782	0	0	457824176000	2584566000	585452000	164971000000	782	1	3128	4	0	0	5474	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-30 19:00:56.514171	2024-07-30 19:14:33.542765
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	731	0	0	410982028000	2744642000	562218000	150489000000	731	1	2924	4	0	0	5117	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-30 19:01:02.670720	2024-07-30 19:14:33.659875
ALTER TABLE `stud` CHANGE `username` `username` VA...	college		1	0	0	357018211000	357018211000	357018211000	131000000	0	0	0	0	0	0	0	0	0	0	a004ced9b20d51c678d33b7d07f1bad7408c7454a40fd8d83b...	2024-07-30 19:13:15.793992	2024-07-30 19:13:15.793992
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	609	0	0	347227937000	2525245000	570160000	114418000000	609	1	2436	4	0	0	4263	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-30 19:00:56.872168	2024-07-30 19:14:33.307975
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	608	0	0	333006175000	2910294000	547707000	22437000000	608	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-07-30 19:01:02.397281	2024-07-30 19:14:33.650388
ALTER TABLE `stud` ADD `password` INTEGER NOT NULL...	college		2	0	0	326481960000	187687987000	163240980000	685000000	0	0	0	0	0	0	0	0	0	0	5a1ad952412f7930b18dc834b615783f8d71a58f3a333c3313...	2024-07-30 19:07:24.555445	2024-07-30 19:11:43.283962

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!