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.0078 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		190	0	0	241981875000	5188261000	1273588000	80966000000	12268	65	61910	326	0	0	190	0	12268	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-30 10:15:55.398550	2024-06-30 10:16:55.725651
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	380	0	0	223430776000	2244252000	587975000	81755000000	3135	8	20995	55	0	0	855	0	5700	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 10:15:55.522977	2024-06-30 10:16:55.844029
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	333	0	0	208411680000	2312066000	625860000	77497000000	2943	9	19029	57	0	0	756	0	5400	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 10:15:55.589343	2024-06-30 10:16:59.909491
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	190	0	0	186908038000	7610719000	983726000	17894000000	190	1	109060	574	0	0	190	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-30 10:15:55.376683	2024-06-30 10:16:55.833079
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		10	0	0	148136515000	71032579000	14813651000	3976000000	22	2	257	26	0	0	10	0	22	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-30 10:15:57.230818	2024-06-30 10:16:37.697157
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	95	0	0	131594206000	10276960000	1385202000	45072000000	95	1	38950	410	0	0	95	0	95	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 10:15:55.394688	2024-06-30 10:16:55.713525
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	3	0	0	120290688000	61051660000	40096896000	1171000000	11	4	65	22	0	0	8	0	197	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-06-30 10:16:06.372345	2024-06-30 10:16:06.570975
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	91	0	0	97491624000	3108012000	1071336000	41553000000	586	6	32885	361	0	0	77	0	586	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 10:15:55.615415	2024-06-30 10:16:59.923637
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	191	0	0	93464629000	2401522000	489343000	41308000000	910	5	5672	30	0	0	200	0	1440	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 10:15:55.705785	2024-06-30 10:16:51.265841
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		193	0	0	82707957000	2979276000	428538000	44975000000	0	0	579	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-30 10:15:55.383732	2024-06-30 10:16:55.714969
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		12	0	0	81402939000	48390790000	6783578000	3930000000	26	2	773	64	0	0	12	0	26	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-30 10:15:59.525707	2024-06-30 10:16:55.610202
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		95	0	0	71965261000	3701917000	757529000	36426000000	284	3	1611	17	0	0	95	0	284	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-30 10:15:55.399794	2024-06-30 10:16:55.716860
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		95	0	0	68799024000	1504420000	724200000	34609000000	1458	15	6857	72	0	0	43	0	1099	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-06-30 10:15:55.628663	2024-06-30 10:16:51.189705
SET `lc_messages` = ?	NULL		248	0	0	59002323000	36021674000	237912000	0	0	0	0	0	0	0	0	0	0	0	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	2024-06-30 10:15:55.348522	2024-06-30 10:17:00.666061
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	95	0	0	58356835000	2094559000	614282000	21528000000	95	1	380	4	0	0	665	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-06-30 10:15:55.546872	2024-06-30 10:16:55.855965
SELECT ? FROM `sakila` . `city` LIMIT ?	sakila		5	0	0	57663055000	57119327000	11532611000	662000000	5	1	5	1	0	0	0	0	0	0	09bdb47922bd9488efa9aece2088049088adeb5017089a26f7...	2024-06-30 10:15:57.157274	2024-06-30 10:16:05.652444
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	9	0	0	56931582000	50024481000	6325731000	3220000000	78	9	294	33	0	0	0	0	0	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 10:15:57.990802	2024-06-30 10:16:30.929675
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	40	0	0	55277361000	9259933000	1381934000	6044000000	109	3	1626	41	0	0	37	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-06-30 10:15:58.034189	2024-06-30 10:16:30.845989
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	97	0	0	55074453000	2339001000	567777000	16972000000	97	1	388	4	0	0	679	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-06-30 10:15:55.619589	2024-06-30 10:16:59.925334
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	93	0	2	54224256000	2010616000	583056000	19430000000	903	10	5428	58	0	0	196	0	1500	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-06-30 10:15:59.601046	2024-06-30 10:16:56.750145
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		86	0	0	54136585000	1757676000	629495000	30988000000	0	0	258	3	0	0	86	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-06-30 10:15:55.629474	2024-06-30 10:16:51.190356
SHOW TABLES FROM `phpmyadmin`	NULL		261	261	0	50787121000	2001935000	194586000	21202000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-06-30 10:15:55.350778	2024-06-30 10:17:00.666579
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL		132	0	0	47995812000	1320508000	363604000	27533000000	0	0	132	1	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-06-30 10:15:55.613355	2024-06-30 10:16:59.924466
SHOW SESSION VARIABLES LIKE ?	information_schema	*	48	0	0	47175587000	1952849000	982824000	4275000000	48	1	27552	574	0	0	48	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-06-30 10:15:55.620377	2024-06-30 10:16:51.254768
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	12	0	0	35528388000	12070524000	2960699000	4899000000	12	1	4955	413	0	0	12	0	12	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-06-30 10:15:59.548269	2024-06-30 10:16:55.621821

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!