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.0039 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 `CATALOG_NAME` , `sch` . ...	performance_schema	*	2560	0	0	1559362887000	5856122000	609126000	577300000000	21554	8	144892	57	0	0	5760	0	39268	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 08:30:54.978393	2024-07-11 08:33:35.057187
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1282	0	0	1534904726000	6148349000	1197273000	500833000000	84120	66	424446	331	0	0	1282	0	84120	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-11 08:30:54.855286	2024-07-11 08:33:35.112705
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1281	0	0	1124929003000	5503990000	878164000	114777000000	1281	1	735294	574	0	0	1281	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-11 08:30:54.832869	2024-07-11 08:33:35.095587
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1576	0	3	983794633000	3435552000	624235000	357935000000	13934	9	91917	58	0	0	3547	0	25093	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 08:30:55.374267	2024-07-11 08:33:35.047277
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	641	0	0	804688514000	9866518000	1255364000	301846000000	641	1	263095	410	0	0	641	0	641	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 08:30:54.850287	2024-07-11 08:33:35.099577
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		683	0	0	765760314000	5916440000	1121171000	265445000000	34539	51	176380	258	0	0	677	0	34527	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-11 08:30:55.199882	2024-07-11 08:33:34.981209
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	839	0	0	545780995000	3016751000	650513000	200864000000	7427	9	48860	58	0	0	1902	0	13624	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 08:30:55.444532	2024-07-11 08:33:34.337391
ALTER TABLE `send_mail` MODIFY `mail_id` INT8 (?) ...	1111111		1	0	1	520387711000	520387711000	520387711000	100000000	0	0	0	0	0	0	0	0	0	0	a412ebd973191c7335be4f5d45bdd4f2046525916937578f73...	2024-07-11 08:32:28.085537	2024-07-11 08:32:28.085537
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1322	0	0	511368433000	2145986000	386814000	285105000000	0	0	3966	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-11 08:30:54.839704	2024-07-11 08:33:35.101821
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1373	0	0	506098014000	3101957000	368607000	282800000000	0	0	4099	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-11 08:30:55.198839	2024-07-11 08:33:34.977788
SHOW SESSION VARIABLES LIKE ?	mysql	*	561	0	0	494046769000	3595060000	880653000	49148000000	561	1	322014	574	0	0	561	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-11 08:30:55.197166	2024-07-11 08:33:35.029023
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		641	0	0	426016124000	3103430000	664611000	226925000000	1912	3	10853	17	0	0	641	0	1912	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-11 08:30:54.856940	2024-07-11 08:33:35.104393
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	360	0	0	423867673000	15276650000	1177410000	157851000000	436	1	144679	402	0	0	357	0	436	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 08:30:55.290768	2024-07-11 08:33:34.979656
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	638	0	0	388170944000	2861421000	608418000	140257000000	638	1	2552	4	0	0	4466	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-11 08:30:55.002537	2024-07-11 08:33:35.070006
ALTER TABLE `send_mail` ADD PRIMARY KEY ( `mail_id...	1111111		1	0	0	328943991000	328943991000	328943991000	395000000	0	0	0	0	0	0	0	0	0	0	d91c8d9d760f28592e3a525a5c6ca143a501b8f1ab482baebd...	2024-07-11 08:32:27.560404	2024-07-11 08:32:27.560404
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	273	0	0	314501140000	9321920000	1152018000	35631000000	365	1	11394	42	0	0	269	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-11 08:31:15.313591	2024-07-11 08:33:21.398492
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		337	0	0	283738788000	55563309000	841954000	125387000000	674	2	22240	66	0	0	337	0	674	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-11 08:30:55.255645	2024-07-11 08:33:34.965358
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	237	0	0	261997736000	5577750000	1105475000	129116000000	6820	29	51173	216	0	0	43	0	6820	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 08:30:55.029498	2024-07-11 08:33:34.195370
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	434	0	0	252040062000	2145118000	580737000	87670000000	434	1	1736	4	0	0	3038	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-11 08:30:55.396890	2024-07-11 08:33:35.064035
SHOW TABLES FROM `phpmyadmin`	NULL		1478	1478	0	248672395000	651917000	168249000	101051000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-11 08:30:54.808837	2024-07-11 08:33:35.097984
SHOW CREATE TABLE `mysql` . `user`	mysql		337	0	0	243588970000	100925453000	722815000	0	0	0	0	0	0	0	0	0	0	0	9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2...	2024-07-11 08:30:55.258540	2024-07-11 08:33:34.966437
CREATE TABLE `send_mail` ( `mail_id` INT8 (?) NOT ...	1111111		1	0	8	223472567000	223472567000	223472567000	2463000000	0	0	0	0	0	0	0	0	0	0	383af35877c7b171584a665b0a5c3535ce0f42cd960badc059...	2024-07-11 08:32:27.210862	2024-07-11 08:32:27.210862
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	589	0	0	199038758000	11188533000	337926000	23635000000	589	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-07-11 08:30:54.851387	2024-07-11 08:33:35.100695
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		1307	0	0	178540758000	1244039000	136603000	87347000000	1307	1	1307	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-11 08:30:54.825739	2024-07-11 08:33:35.117848
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	589	0	0	174521717000	3626528000	296301000	40426000000	14725	25	14725	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-07-11 08:30:54.836938	2024-07-11 08:33:35.096370

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!