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.

Your SQL query has been executed successfully.

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	*	209	0	3	138962095000	5033861000	664890000	48586000000	2121	10	13199	63	0	0	462	0	3690	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-03 07:01:01.345622	2025-07-03 07:01:20.868822
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		18	0	0	120129853000	59392045000	6673880000	9843000000	38	2	1169	65	0	0	18	0	38	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-03 07:01:01.281228	2025-07-03 07:01:20.812868
SHOW SESSION VARIABLES LIKE ?	mysql	*	75	0	0	94842617000	8279099000	1264568000	8696000000	75	1	43050	574	0	0	75	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-03 07:01:01.226440	2025-07-03 07:01:20.862791
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		2	0	0	71582010000	71059595000	35791005000	668000000	2	1	28	14	0	0	2	0	2	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-03 07:01:01.533048	2025-07-03 07:01:03.330557
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	62	0	0	67662281000	3340418000	1091327000	23489000000	584	9	3801	61	0	0	142	0	1080	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-03 07:01:01.631862	2025-07-03 07:01:18.353147
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	mysql	*	41	0	0	64544665000	3946595000	1574260000	8115000000	11152	272	12833	313	0	0	41	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2025-07-03 07:01:01.373117	2025-07-03 07:01:17.349836
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		90	0	0	56525080000	6805355000	628056000	28720000000	0	0	270	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-03 07:01:01.234899	2025-07-03 07:01:20.830190
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		37	0	0	55993271000	3117411000	1513331000	21122000000	1784	48	9091	246	0	0	36	0	1778	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-03 07:01:01.237515	2025-07-03 07:01:20.833109
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	18	0	0	55249890000	19209529000	3069438000	10408000000	18	1	1818	101	0	0	18	0	18	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-03 07:01:01.310189	2025-07-03 07:01:20.831389
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	world		1	0	0	44023727000	44023727000	44023727000	1324000000	2	2	15	15	0	0	1	0	2	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-03 07:01:13.101149	2025-07-03 07:01:13.101149
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		22	0	0	40416874000	3646323000	1837130000	14416000000	1084	49	5486	249	0	0	22	0	1084	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-03 07:01:03.048003	2025-07-03 07:01:19.499842
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	60	0	0	32627830000	1190413000	543797000	10733000000	60	1	240	4	0	0	420	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2025-07-03 07:01:01.354671	2025-07-03 07:01:20.870746
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	33	0	0	30959536000	2157868000	938167000	9359000000	33	1	132	4	0	0	231	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2025-07-03 07:01:01.395794	2025-07-03 07:01:18.381156
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	22	0	0	30819819000	4436071000	1400900000	2629000000	22	1	12628	574	0	0	22	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-03 07:01:03.033654	2025-07-03 07:01:19.560687
SHOW TABLES FROM `phpmyadmin`	NULL		122	122	0	30256003000	924345000	248000000	12267000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2025-07-03 07:01:01.210827	2025-07-03 07:01:21.042403
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL		1	0	0	28509639000	28509639000	28509639000	600000000	2	2	22	22	0	0	1	0	2	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-03 07:01:01.620206	2025-07-03 07:01:01.620206
SET `lc_messages` = ?	NULL		122	0	0	24524606000	7060493000	201021000	0	0	0	0	0	0	0	0	0	0	0	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	2025-07-03 07:01:01.208354	2025-07-03 07:01:21.041798
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	4	0	0	23517472000	20242721000	5879368000	2588000000	2	1	195	49	0	0	4	0	2	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-03 07:01:01.564974	2025-07-03 07:01:03.372794
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	world	*	1	0	0	22266333000	22266333000	22266333000	339000000	1	1	38	38	0	0	1	0	1	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-03 07:01:13.049536	2025-07-03 07:01:13.049536
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	11	0	0	20864476000	3601326000	1896770000	9225000000	11	1	1507	137	0	0	11	0	11	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-03 07:01:03.045405	2025-07-03 07:01:19.468361
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	44	0	0	20430828000	1161010000	464337000	7291000000	363	8	2431	55	0	0	99	0	660	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-03 07:01:03.177625	2025-07-03 07:01:19.567030
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		25	0	0	19098704000	1452731000	763948000	10759000000	0	0	75	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-03 07:01:03.042430	2025-07-03 07:01:19.473129
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	5	0	0	18757727000	15121278000	3751545000	3843000000	47	9	265	53	0	0	1	0	47	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-03 07:01:01.394336	2025-07-03 07:01:21.015403
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		107	0	0	18203967000	862539000	170130000	8431000000	107	1	107	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2025-07-03 07:01:01.216331	2025-07-03 07:01:21.048433
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co...	mysql	*	41	0	0	16490917000	1405845000	402217000	8154000000	1681	41	3362	82	0	0	0	0	0	0	878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...	2025-07-03 07:01:01.371477	2025-07-03 07:01:17.345066

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-5377-g8e721911f0 from the master branch.