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.0029 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` ....	performance_schema		6815	0	0	7725170721000	10851943000	1133554000	2518618000000	452081	66	2280850	335	0	0	6815	0	452081	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 02:15:56.695294	2024-08-09 02:25:42.879265
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	13619	0	0	7556510130000	5943057000	554850000	2745347000000	119612	9	808254	59	0	0	30641	0	218796	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:15:56.817878	2024-08-09 02:25:43.005808
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		23710	0	0	6253418141000	3271199000	263746000	3380447000000	23694	1	142212	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 02:16:05.966336	2024-08-09 02:25:43.391514
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	6812	0	0	5594942291000	18440928000	821336000	607350000000	6812	1	3910088	574	0	0	6812	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 02:15:56.624510	2024-08-09 02:25:42.995075
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	3411	0	0	4125970358000	62400399000	1209607000	1556347000000	3717	1	1401237	411	0	0	3409	0	3717	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 02:15:56.690452	2024-08-09 02:25:42.867659
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		6839	0	0	2581640643000	4286917000	377488000	1451009000000	0	0	20517	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 02:15:56.684650	2024-08-09 02:25:42.869296
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		3408	0	0	2226790647000	9792330000	653401000	1174034000000	10214	3	57896	17	0	0	3408	0	10214	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 02:15:56.696647	2024-08-09 02:25:42.871226
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	3215	0	0	1834544448000	3951942000	570620000	664368000000	3215	1	12860	4	0	0	22505	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 02:15:56.839667	2024-08-09 02:25:43.017858
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	3219	0	0	1464882329000	2318042000	455073000	118786000000	3219	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-08-09 02:15:56.690906	2024-08-09 02:25:42.868406
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	6	0	0	1311434632000	794858674000	218572438000	3234000000	52	9	38670	6445	0	0	34	4	2866	4	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-08-09 02:20:32.081015	2024-08-09 02:23:17.999628
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1571	0	9	957688986000	4873421000	609604000	352564000000	14929	10	96620	62	0	0	3475	0	26428	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:15:57.494275	2024-08-09 02:25:43.372269
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	3219	0	0	902018472000	3716401000	280216000	219060000000	80475	25	80475	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-08-09 02:15:56.631531	2024-08-09 02:25:42.865180
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	1238	0	0	802254648000	5079557000	648024000	293360000000	11609	9	76281	62	0	0	2822	0	21434	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:15:56.679499	2024-08-09 02:25:38.621774
SHOW TABLES FROM `phpmyadmin`	NULL		5014	5014	0	733135429000	1073047000	146217000	303038000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 02:15:56.599814	2024-08-09 02:25:43.406662
SELECT * FROM `inventory` LIMIT ?, ...	sakila	*	1	0	0	722436341000	722436341000	722436341000	1167000000	25	25	25	25	0	0	0	0	0	0	cb93a3d375817190da4e0687e11321d7a3afd75f9377d69d26...	2024-08-09 02:16:24.033101	2024-08-09 02:16:24.033101
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		3219	0	0	693166365000	1815560000	215335000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-08-09 02:15:56.698324	2024-08-09 02:25:42.872912
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		590	0	0	666299767000	4144858000	1129321000	233620000000	29339	50	149718	254	0	0	582	0	29303	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 02:15:57.343866	2024-08-09 02:25:43.275599
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		4417	0	0	616966873000	1274595000	139680000	307930000000	4417	1	4417	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-08-09 02:15:56.617563	2024-08-09 02:25:43.422436
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir...	sakila	*	3	0	0	600456532000	320275506000	200152177000	355000000	26	9	645622	215207	0	0	6	0	400	0	91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6...	2024-08-09 02:24:49.385868	2024-08-09 02:24:49.885529
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	487	0	0	550791083000	4971390000	1130987000	65609000000	901	2	20130	41	0	0	469	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-08-09 02:16:18.303041	2024-08-09 02:25:32.013125
SHOW SESSION VARIABLES LIKE ?	mysql	*	587	0	0	510421974000	3924879000	869543000	49405000000	587	1	336938	574	0	0	587	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 02:15:57.335793	2024-08-09 02:25:43.352671
SELECT ? FROM `performance_schema` . `table_lock_w...	performance_schema	*	3215	0	0	500678009000	1308805000	155731000	234743000000	3215	1	3215	1	0	0	0	0	0	0	0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...	2024-08-09 02:15:56.857138	2024-08-09 02:25:43.034917
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1250	0	0	477958765000	2929579000	382367000	269235000000	0	0	3750	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 02:15:57.342226	2024-08-09 02:25:43.273328
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	cinema	*	807	0	0	451930668000	2819708000	560013000	167937000000	6842	8	45469	56	0	0	1753	0	12460	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:17:26.996537	2024-08-09 02:24:52.037989
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	hola	*	762	0	0	442867404000	2170268000	581190000	160132000000	6793	9	45453	60	0	0	1692	0	12438	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:19:20.672676	2024-08-09 02:25:42.898985

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.