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.3165 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		1215	0	0	1992405038000	6983166000	1639839000	656264000000	76926	63	388275	320	0	0	1215	0	76926	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-22 00:02:16.760751	2024-07-22 00:06:12.692217
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	2431	0	0	1967064197000	8011792000	809158000	733106000000	20063	8	134358	55	0	0	5470	0	36480	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-22 00:02:16.994482	2024-07-22 00:06:12.921686
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1850	0	0	1531008116000	11076432000	827571000	579315000000	15335	8	102210	55	0	0	4165	0	27900	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-22 00:02:17.228174	2024-07-22 00:06:12.466704
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		4	0	0	1377630867000	1236210271000	344407716000	45850000000	12	3	138	35	0	0	4	0	12	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-22 00:02:52.376063	2024-07-22 00:05:21.876328
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		914	0	0	1373077360000	25228173000	1502272000	489881000000	46516	51	237240	260	0	0	912	0	46512	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-22 00:02:17.106397	2024-07-22 00:06:12.360393
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1217	0	0	1343486644000	23921877000	1103933000	130048000000	1217	1	698558	574	0	0	1217	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-22 00:02:16.740802	2024-07-22 00:06:13.011163
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		2119	0	0	1020427270000	3743925000	481560000	576145000000	0	0	6357	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-22 00:02:17.105074	2024-07-22 00:06:12.355071
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	609	0	0	990206295000	9450705000	1625954000	372411000000	609	1	249690	410	0	0	609	0	609	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-22 00:02:16.757084	2024-07-22 00:06:13.014968
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	1150	0	0	928610891000	4676975000	807487000	347294000000	9647	8	63310	55	0	0	2593	0	17580	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-22 00:02:24.092472	2024-07-22 00:06:12.940048
SHOW SESSION VARIABLES LIKE ?	mysql	*	841	0	0	911995062000	4419852000	1084417000	88685000000	841	1	482734	574	0	0	841	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-22 00:02:17.103102	2024-07-22 00:06:12.449664
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	505	0	0	813922988000	22182273000	1611728000	91455000000	758	2	21012	42	0	0	494	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-22 00:02:36.601813	2024-07-22 00:06:08.476697
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	455	0	0	730454817000	8617842000	1605395000	276120000000	455	1	187915	413	0	0	455	0	455	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-22 00:02:17.157346	2024-07-22 00:06:12.356915
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1289	0	0	644550826000	2336143000	500039000	359950000000	0	0	3867	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-22 00:02:16.747208	2024-07-22 00:06:13.016804
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		608	0	0	573545927000	5755299000	943332000	306817000000	1798	3	10232	17	0	0	608	0	1798	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-22 00:02:16.762290	2024-07-22 00:06:12.680688
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	596	0	0	446979798000	3983748000	749966000	160467000000	596	1	2384	4	0	0	4172	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-22 00:02:17.031529	2024-07-22 00:06:12.940072
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		455	0	0	444476794000	29140029000	976872000	223597000000	910	2	30028	66	0	0	455	0	910	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-22 00:02:17.135762	2024-07-22 00:06:12.340328
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	466	0	0	356312416000	3691221000	764618000	127852000000	466	1	1864	4	0	0	3262	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-22 00:02:17.269241	2024-07-22 00:06:12.488543
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	248	0	0	321220595000	18820563000	1295244000	144688000000	7735	31	53289	215	0	0	34	0	7735	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-22 00:02:23.846318	2024-07-22 00:06:11.737337
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	11	0	0	275217914000	212489697000	25019810000	7241000000	165	15	3060	278	0	0	6	0	165	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-22 00:02:51.092728	2024-07-22 00:05:26.563315
SHOW TABLES FROM `phpmyadmin`	NULL		1445	1445	0	238429647000	6988046000	165003000	94809000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-22 00:02:16.709273	2024-07-22 00:06:13.000598
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		1390	0	0	233079283000	1746377000	167682000	114880000000	1390	1	1390	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-22 00:02:16.735245	2024-07-22 00:06:13.095354
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	511	0	0	222261834000	4335243000	434954000	49040000000	12775	25	12775	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-07-22 00:02:16.744579	2024-07-22 00:06:13.011848
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	300	0	0	197675905000	2258783000	658919000	61431000000	300	1	1200	4	0	0	2100	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-22 00:02:24.127728	2024-07-22 00:06:12.958629
SET `lc_messages` = ?	NULL		1364	0	0	194642436000	108517786000	142699000	0	0	0	0	0	0	0	0	0	0	0	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	2024-07-22 00:02:16.708536	2024-07-22 00:06:13.000236
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	511	0	0	192881513000	982927000	377458000	27607000000	511	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-07-22 00:02:16.757927	2024-07-22 00:06:13.015788

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!