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.0982 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 `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	819	0	0	829082261000	4620901000	1012310000	91886000000	1164	1	34128	42	0	0	804	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-01 21:16:03.458864	2024-07-01 21:20:55.583831
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1150	0	0	598338215000	2839105000	520294000	221965000000	9857	9	64601	56	0	0	2495	0	17418	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 21:15:56.695009	2024-07-01 21:21:08.798725
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	864	0	0	552032234000	3877088000	638926000	205609000000	7351	9	49124	57	0	0	1948	0	13414	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 21:15:56.996273	2024-07-01 21:20:56.607863
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		508	0	0	519673779000	4616066000	1022979000	182099000000	24427	48	124501	245	0	0	493	0	24302	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 21:15:56.649716	2024-07-01 21:21:08.739933
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		438	0	0	455623135000	3965968000	1040235000	151798000000	26186	60	132244	302	0	0	438	0	26186	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 21:15:56.813199	2024-07-01 21:21:08.707815
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	878	0	0	453727234000	2661440000	516773000	165778000000	7373	8	49519	56	0	0	1976	0	13430	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 21:15:56.944389	2024-07-01 21:21:08.777927
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	439	0	0	362215820000	4393236000	825092000	39417000000	439	1	251986	574	0	0	439	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-01 21:15:56.805348	2024-07-01 21:21:08.766436
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		260	0	0	342794503000	78221206000	1318440000	89233000000	513	2	16161	62	0	0	260	0	513	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 21:15:56.669023	2024-07-01 21:21:08.727677
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1006	0	0	338401602000	2074971000	336383000	188774000000	0	0	3018	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-01 21:15:56.712984	2024-07-01 21:21:08.737437
SHOW SESSION VARIABLES LIKE ?	mysql	*	402	0	0	337298882000	5706907000	839051000	35414000000	402	1	230748	574	0	0	402	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-01 21:15:57.326181	2024-07-01 21:21:08.786966
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	259	0	0	296005795000	20779564000	1142879000	104298000000	323	1	26496	102	0	0	257	0	323	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 21:15:56.728097	2024-07-01 21:21:08.738464
CREATE TABLE `eng` . `bme` ( `age` INTEGER NOT NUL...	eng		1	0	0	280005266000	280005266000	280005266000	4129000000	0	0	0	0	0	0	0	0	0	0	2f038edb4b15906fbd03a432c330e250c68f6939cf27efe19a...	2024-07-01 21:19:02.664013	2024-07-01 21:19:02.664013
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	201	0	0	252764984000	3359620000	1257537000	134542000000	6194	31	25353	126	0	0	29	0	6194	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 21:15:57.308542	2024-07-01 21:21:06.995295
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	eng	*	438	0	0	238742092000	2150607000	545073000	90332000000	3708	8	24386	56	0	0	955	0	6634	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 21:18:12.474476	2024-07-01 21:21:09.987087
SHOW TABLES FROM `phpmyadmin`	NULL		1040	1040	0	221892589000	1009649000	213358000	90434000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-01 21:15:56.641729	2024-07-01 21:21:09.942437
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	221	0	0	218873936000	2152009000	990379000	98029000000	221	1	30392	138	0	0	221	0	221	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 21:15:56.810891	2024-07-01 21:21:08.698755
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		5	0	0	191499855000	76543000000	38299971000	2236000000	13	3	147	29	0	0	5	0	13	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 21:16:19.697682	2024-07-01 21:19:02.355118
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	435	0	0	175184270000	1696714000	402722000	71093000000	2662	6	16945	39	0	0	593	0	4462	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 21:16:03.552633	2024-07-01 21:21:07.103325
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		486	0	0	175005336000	1144093000	360093000	98212000000	0	0	1458	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-01 21:15:56.809416	2024-07-01 21:21:08.700230
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		262	0	0	166169473000	2816414000	634234000	84897000000	3594	14	17008	65	0	0	136	0	2720	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 21:16:03.446888	2024-07-01 21:21:07.026399
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	eng	*	165	0	0	155151835000	20884784000	940314000	86798000000	121	1	2605	16	0	0	64	0	119	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 21:17:41.422156	2024-07-01 21:21:10.009519
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		272	0	0	150574178000	2599442000	553581000	88166000000	0	0	816	3	0	0	272	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 21:16:03.447797	2024-07-01 21:21:07.027631
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	283	0	0	145741586000	1862605000	514987000	52212000000	283	1	1132	4	0	0	1981	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-01 21:15:56.731960	2024-07-01 21:21:08.812295
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		221	0	0	137511198000	1574943000	622222000	71544000000	645	3	3685	17	0	0	221	0	645	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 21:15:56.814043	2024-07-01 21:21:08.701870
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	226	0	0	127555791000	2873737000	564406000	43428000000	226	1	904	4	0	0	1582	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-01 21:15:57.026129	2024-07-01 21:21:00.357098

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!