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.0207 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		2072	0	0	3099724222000	8645093000	1496005000	1009400000000	137676	66	694596	335	0	0	2072	0	137676	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 06:45:56.847689	2024-08-09 06:48:34.515245
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	4138	0	0	3083728650000	5406183000	745222000	1169337000000	34880	8	234509	57	0	0	9311	0	63554	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 06:45:57.006602	2024-08-09 06:48:34.514208
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	2071	0	0	2100979690000	8529963000	1014475000	210971000000	2071	1	1188754	574	0	0	2071	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 06:45:56.776813	2024-08-09 06:48:34.498934
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		150	0	0	1381966837000	170487170000	9213112000	72212000000	317	2	8236	55	0	0	150	0	317	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 06:45:57.497594	2024-08-09 06:48:33.977839
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	1036	0	0	1277666629000	6403877000	1233268000	574889000000	1036	1	142658	138	0	0	1036	0	1036	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 06:45:56.841858	2024-08-09 06:48:34.502347
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		2081	0	0	986985464000	4830049000	474284000	554479000000	0	0	6243	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 06:45:56.838143	2024-08-09 06:48:34.503899
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1036	0	0	871968644000	6592840000	841668000	463318000000	3103	3	17592	17	0	0	1036	0	3103	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 06:45:56.849318	2024-08-09 06:48:34.506132
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	922	0	0	674223362000	4707736000	731261000	240812000000	922	1	3688	4	0	0	6454	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 06:45:57.035713	2024-08-09 06:48:34.289523
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	6	0	0	555741589000	278196761000	92623598000	2581000000	52	9	1746	291	0	0	0	0	0	0	251552b68e8f44795ca803316d221e604ec58591e3d9d3654e...	2024-08-09 06:45:58.251066	2024-08-09 06:47:15.580627
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	637	0	0	521543945000	24195090000	818750000	188478000000	5691	9	37091	58	0	0	1445	0	10450	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 06:45:57.158016	2024-08-09 06:48:34.285965
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	638	0	2	494293519000	7721669000	774754000	182216000000	5559	9	36512	57	0	0	1392	0	10007	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 06:45:57.598889	2024-08-09 06:48:34.118902
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	983	0	0	398522042000	2954529000	405414000	49985000000	983	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-08-09 06:45:56.845111	2024-08-09 06:48:34.318076
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	983	0	0	381969005000	3775986000	388574000	85545000000	24575	25	24575	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-08-09 06:45:56.780972	2024-08-09 06:48:34.081088
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		304	0	0	376997033000	4357132000	1240121000	141623000000	11942	39	60729	200	0	0	265	0	11647	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 06:45:57.410592	2024-08-09 06:48:33.992255
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	3	0	0	323752292000	322325466000	107917430000	1331000000	26	9	128	43	0	0	0	0	0	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 06:46:04.247161	2024-08-09 06:46:04.649750
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	136	0	0	297820040000	112233878000	2189853000	76728000000	648	5	15481	114	0	0	122	0	648	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 06:45:57.530208	2024-08-09 06:48:33.990196
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		983	0	0	283861377000	2143086000	288770000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-08-09 06:45:56.851369	2024-08-09 06:48:34.323923
SHOW SESSION VARIABLES LIKE ?	mysql	*	231	0	0	274342170000	33059242000	1187628000	23666000000	231	1	132594	574	0	0	231	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 06:45:57.407498	2024-08-09 06:48:34.087013
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	6	0	0	264284980000	231610632000	44047496000	3515000000	72	12	469	78	0	0	4	0	72	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 06:46:28.514981	2024-08-09 06:48:23.907252
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	171	0	0	261335577000	3105477000	1528278000	31253000000	332	2	7056	41	0	0	164	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-08-09 06:46:04.352139	2024-08-09 06:48:23.127711
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		516	0	0	246454753000	5528106000	477625000	135007000000	0	0	1548	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 06:45:57.409650	2024-08-09 06:48:33.989313
SHOW TABLES FROM `phpmyadmin`	NULL		1537	1537	0	232411026000	878635000	151210000	95949000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 06:45:56.752717	2024-08-09 06:48:34.428301
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		1425	0	0	231390029000	1298265000	162378000	113496000000	1425	1	1425	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-08-09 06:45:56.769789	2024-08-09 06:48:34.496954
CREATE TABLE `login_sample_db` . `user` ( `id` INT...	login_sample_db		1	0	0	208935523000	208935523000	208935523000	4072000000	0	0	0	0	0	0	0	0	0	0	2a0b04e64f41479feba552e3386aeac4218c658323ccdec082...	2024-08-09 06:48:34.019898	2024-08-09 06:48:34.019898
SELECT ? FROM `performance_schema` . `table_lock_w...	performance_schema	*	982	0	0	177850027000	1253484000	181110000	84674000000	982	1	982	1	0	0	0	0	0	0	0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...	2024-08-09 06:45:57.068597	2024-08-09 06:48:34.313450

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.