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.0063 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		16887	0	0	4304927450000	2720957000	254925000	2323496000000	16879	1	101298	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 16:46:05.185280	2024-08-09 16:50:58.227168
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	1823	0	0	1289446322000	5258301000	707321000	476251000000	16389	9	107882	59	0	0	4120	0	30003	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 16:45:56.458190	2024-08-09 16:51:33.825656
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	12	0	0	838086757000	632069443000	69840563000	3784000000	104	9	104	9	0	0	32	0	741	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-08-09 16:46:05.182428	2024-08-09 16:50:57.236189
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		542	0	0	599567884000	5150839000	1106213000	202969000000	33536	62	169306	312	0	0	542	0	33536	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 16:46:01.693950	2024-08-09 16:51:33.795572
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	1084	0	0	578283618000	2552401000	533471000	212886000000	9245	9	62307	57	0	0	2439	0	16864	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 16:46:01.831673	2024-08-09 16:51:33.921768
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	542	0	0	472591900000	5921485000	871940000	49952000000	542	1	311108	574	0	0	542	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 16:46:01.654350	2024-08-09 16:51:33.911083
SELECT @@`have_profiling`	performance_schema		161	0	161	413908166000	404847150000	2570858000	0	161	1	161	1	0	0	0	0	0	0	1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923...	2024-08-09 16:46:02.543999	2024-08-09 16:51:24.245327
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	603	0	7	349288132000	3375258000	579250000	127004000000	5861	10	36874	61	0	0	1320	0	10166	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 16:46:01.695376	2024-08-09 16:51:34.234018
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	271	0	0	329449036000	9012697000	1215679000	120194000000	271	1	111323	411	0	0	271	0	271	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 16:46:01.690986	2024-08-09 16:51:33.784773
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	579	0	0	319929831000	2781494000	552555000	104199000000	579	1	2316	4	0	0	4053	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 16:45:56.489614	2024-08-09 16:51:33.838667
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	284	0	0	296428268000	2089587000	1043761000	35791000000	514	2	11748	41	0	0	274	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-08-09 16:46:02.061890	2024-08-09 16:51:23.714586
SHOW TABLES FROM `phpmyadmin`	NULL		1282	1282	0	285628352000	987092000	222799000	115013000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 16:45:56.448358	2024-08-09 16:51:34.732709
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		7	0	0	227124983000	55614710000	32446426000	3171000000	19	3	197	28	0	0	7	0	19	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 16:46:02.677553	2024-08-09 16:48:58.519241
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		557	0	0	215801780000	2551957000	387435000	121375000000	0	0	1671	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 16:46:01.681617	2024-08-09 16:51:33.786255
CREATE TABLE `nibm` . `student` ( `student id` INT...	nibm		1	0	0	215142769000	215142769000	215142769000	2655000000	0	0	0	0	0	0	0	0	0	0	7c0d9b8d1d7dd7795ce5e560819c2cbf7d7e50f11e6b5cf773...	2024-08-09 16:48:12.810051	2024-08-09 16:48:12.810051
SHOW SESSION VARIABLES LIKE ?	mysql	*	234	0	0	208306134000	3138362000	890197000	21075000000	234	1	134316	574	0	0	234	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 16:46:01.668962	2024-08-09 16:51:34.202960
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		194	0	0	195487127000	2263782000	1007665000	69910000000	9377	48	47834	247	0	0	191	0	9359	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 16:46:02.815548	2024-08-09 16:51:31.391298
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		271	0	0	181486884000	3876034000	669693000	95684000000	808	3	4587	17	0	0	271	0	808	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 16:46:01.696406	2024-08-09 16:51:33.788062
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ...	NULL	*	828	0	0	163452280000	723662000	197406000	38731000000	828	1	143244	173	0	0	828	0	0	0	cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...	2024-08-09 16:45:56.490062	2024-08-09 16:51:33.839488
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		225	0	0	158575207000	1881110000	704778000	84479000000	3097	14	14600	65	0	0	113	0	2317	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 16:46:02.035788	2024-08-09 16:51:26.053608
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		93	0	0	156775777000	72585355000	1685761000	33233000000	192	2	6085	65	0	0	93	0	192	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 16:46:03.429980	2024-08-09 16:51:31.378822
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		455	0	0	154504033000	2276373000	339569000	86332000000	0	0	1363	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 16:46:03.516864	2024-08-09 16:51:31.388755
CREATE TABLE `MEMBROS` ( `NOME` VARCHARACTER (?) ,...	CPJ		1	0	0	147570230000	147570230000	147570230000	176000000	0	0	0	0	0	0	0	0	0	0	71ddabe1a557d56fe6b23940916675470454894d9e5f279cb3...	2024-08-09 16:50:03.831122	2024-08-09 16:50:03.831122
SELECT @@`version` , @@`version_comment`	NULL		1218	0	0	143177428000	418078000	117551000	0	1218	1	1218	1	0	0	0	0	0	0	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	2024-08-09 16:45:56.446960	2024-08-09 16:51:34.729537
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	267	0	0	142954170000	1274929000	535408000	52439000000	267	1	1068	4	0	0	1869	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 16:46:01.856938	2024-08-09 16:51:33.933906

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4870-g04ce8db2b0 from the master branch.