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.0027 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` . ...	NULL	*	1519	0	0	947294252000	7592199000	623630000	353002000000	13134	9	88883	59	0	0	3424	0	24002	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 07:31:02.708748	2024-06-30 07:37:00.652774
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		744	0	0	807553556000	3482511000	1085421000	266043000000	47288	64	238672	321	0	0	744	0	47288	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-30 07:31:03.119848	2024-06-30 07:37:00.663261
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	1488	0	0	764767525000	2137082000	513956000	277786000000	12714	9	85565	58	0	0	3348	0	23196	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 07:31:03.249112	2024-06-30 07:37:00.788690
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	609	0	0	659488974000	4690204000	1082904000	75664000000	839	1	25398	42	0	0	599	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-06-30 07:31:03.037466	2024-06-30 07:37:01.084859
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	744	0	0	623125120000	5732922000	837533000	66889000000	744	1	427056	574	0	0	744	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-30 07:31:03.107321	2024-06-30 07:37:00.777385
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	372	0	0	449195521000	4068266000	1207514000	170295000000	372	1	152623	410	0	0	372	0	372	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 07:31:03.116801	2024-06-30 07:37:00.650933
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	933	0	0	297221466000	2025101000	318565000	133298000000	3684	4	22539	24	0	0	730	0	5494	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 07:31:03.033239	2024-06-30 07:37:01.053552
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		786	0	0	294876134000	2365995000	375160000	164008000000	0	0	2358	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-30 07:31:03.114692	2024-06-30 07:37:00.652429
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	327	0	0	278160997000	88370267000	850645000	110043000000	78	0	4236	13	0	0	318	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-30 07:31:03.012507	2024-06-30 07:37:01.009011
SHOW TABLES FROM `phpmyadmin`	NULL		1210	1210	0	264568955000	603921000	218652000	107976000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-06-30 07:31:02.696440	2024-06-30 07:37:01.621952
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		372	0	0	247493442000	2405351000	665304000	128996000000	1098	3	6252	17	0	0	372	0	1098	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-30 07:31:03.120927	2024-06-30 07:37:00.654449
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	445	0	5	234380725000	2365085000	526698000	87103000000	4503	10	26973	61	0	0	897	0	7201	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 07:31:02.953593	2024-06-30 07:36:59.953302
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		87	0	0	223031185000	69429137000	2563576000	30605000000	162	2	3954	45	0	0	87	0	162	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-30 07:31:02.846983	2024-06-30 07:36:58.171498
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	408	0	0	214538595000	1999392000	525829000	69438000000	408	1	1632	4	0	0	2856	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-06-30 07:31:02.746020	2024-06-30 07:37:00.667007
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	315	0	0	203004517000	3839477000	644458000	102599000000	4153	13	22890	73	0	0	160	0	3090	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-30 07:31:03.011331	2024-06-30 07:37:01.008269
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	372	0	0	198191000000	1026472000	532771000	71668000000	372	1	1488	4	0	0	2604	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-06-30 07:31:03.272964	2024-06-30 07:37:00.800768
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	30	0	0	188607361000	167998298000	6286912000	8738000000	260	9	980	33	0	0	0	0	0	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 07:31:03.418789	2024-06-30 07:34:55.569509
CREATE TABLE `testdb` . `emp_details` ( `id` INTEG...	testdb		1	0	0	188227417000	188227417000	188227417000	4285000000	0	0	0	0	0	0	0	0	0	0	b84354cb8111ab4a174b0b02c286a985e2b01187e1d962803a...	2024-06-30 07:35:14.258772	2024-06-30 07:35:14.258772
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	10	0	0	160021070000	100940819000	16002107000	8400000000	10	1	4111	411	0	0	10	0	10	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 07:31:06.350024	2024-06-30 07:36:58.728981
SHOW SESSION VARIABLES LIKE ?	information_schema	*	172	0	0	151026434000	2723809000	878060000	14978000000	172	1	98728	574	0	0	172	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-30 07:31:02.994646	2024-06-30 07:37:01.042685
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	63	0	0	141640970000	25535743000	2248269000	23464000000	63	1	26027	413	0	0	63	0	63	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 07:31:02.887297	2024-06-30 07:36:58.183951
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		150	0	0	139786387000	2664795000	931909000	55745000000	5426	36	27604	184	0	0	126	0	5302	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-30 07:31:02.810101	2024-06-30 07:36:58.185249
SELECT @@`version` , @@`version_comment`	NULL		1210	0	0	139700902000	682531000	115455000	0	1210	1	1210	1	0	0	0	0	0	0	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	2024-06-30 07:31:02.694183	2024-06-30 07:37:01.620556
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	110	0	0	139474771000	7115405000	1267952000	65285000000	2031	18	30450	277	0	0	62	0	2031	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 07:31:03.227883	2024-06-30 07:36:54.747974
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ...	NULL	*	688	0	0	134040841000	1352247000	194826000	32758000000	688	1	119024	173	0	0	688	0	0	0	cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...	2024-06-30 07:31:02.746540	2024-06-30 07:37:00.667919

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!