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.0051 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` ....	sys		23721	0	0	7518777004000	3086288000	316967000	4076053000000	23698	1	142257	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 06:30:48.507609	2024-08-09 06:35:25.288016
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	5976	0	0	4189380366000	8040988000	701034000	1536364000000	53532	9	363463	61	0	0	13446	0	98100	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 06:30:51.333690	2024-08-09 06:36:18.197117
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		2990	0	0	4107422576000	6642695000	1373719000	1371551000000	198628	66	1002110	335	0	0	2990	0	198628	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 06:30:51.261336	2024-08-09 06:36:18.341631
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	2989	0	0	2818846925000	4034184000	943073000	289561000000	2989	1	1715686	574	0	0	2989	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 06:30:51.253449	2024-08-09 06:36:18.182019
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	1495	0	0	2086873600000	7109446000	1395902000	793781000000	1495	1	620281	415	0	0	1495	0	1495	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 06:30:51.259391	2024-08-09 06:36:18.326173
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	27	0	3	1464173020000	368533705000	54228630000	11780000000	168	6	383	14	0	0	72	0	1747	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-08-09 06:31:28.137419	2024-08-09 06:34:58.118912
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		3008	0	0	1345538882000	1852384000	447320000	761503000000	0	0	9024	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 06:30:51.257612	2024-08-09 06:36:18.328554
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1495	0	0	1161568247000	4117318000	776968000	607324000000	4479	3	25391	17	0	0	1495	0	4479	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 06:30:51.262562	2024-08-09 06:36:18.332074
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	1308	0	0	907443127000	5248333000	693763000	328489000000	1308	1	5232	4	0	0	9156	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 06:30:51.362593	2024-08-09 06:36:18.242346
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	828	0	9	635553542000	6707362000	767576000	225029000000	8257	10	52754	64	0	0	1835	0	14469	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 06:30:48.527438	2024-08-09 06:36:18.390438
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	697	0	0	542186890000	7681973000	777886000	197831000000	6932	10	45141	65	0	0	1594	0	12870	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 06:30:47.650291	2024-08-09 06:36:18.002654
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	6	0	0	521146991000	331230849000	86857831000	2236000000	52	9	36410	6068	0	0	34	4	1706	4	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-08-09 06:33:53.752251	2024-08-09 06:33:55.248833
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	1416	0	0	487349189000	2192153000	344173000	63005000000	1416	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-08-09 06:30:51.551483	2024-08-09 06:36:18.327401
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	1416	0	0	484161815000	2764332000	341922000	114663000000	35400	25	35400	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-08-09 06:30:51.548541	2024-08-09 06:36:18.011237
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		304	0	0	411643738000	6234936000	1354091000	147773000000	15200	50	77582	255	0	0	300	0	15184	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 06:30:50.468606	2024-08-09 06:36:18.200259
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		1416	0	0	388445414000	1179979000	274325000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-08-09 06:30:51.557995	2024-08-09 06:36:18.334379
SHOW TABLES FROM `phpmyadmin`	NULL		2385	2385	0	360295340000	2875375000	151067000	147412000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 06:30:47.635662	2024-08-09 06:36:18.397834
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		2086	0	0	332030703000	790790000	159170000	165823000000	2086	1	2086	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-08-09 06:30:47.690123	2024-08-09 06:36:18.440884
SHOW SESSION VARIABLES LIKE ?	mysql	*	314	0	0	319325302000	8005445000	1016959000	31074000000	314	1	180236	574	0	0	314	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 06:30:48.497053	2024-08-09 06:36:18.354846
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		361	0	0	307076355000	2990422000	850627000	158156000000	5663	16	26670	74	0	0	166	0	4299	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 06:30:49.473017	2024-08-09 06:36:18.445130
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	392	0	0	295832000000	5582132000	754673000	112740000000	3400	9	22520	57	0	0	779	0	6206	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 06:30:49.508743	2024-08-09 06:36:18.350252
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		661	0	0	285878936000	2190091000	432494000	161365000000	0	0	1983	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 06:30:50.467740	2024-08-09 06:36:18.196226
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	179	0	0	260348639000	3095353000	1454461000	31490000000	386	2	7356	41	0	0	170	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-08-09 06:31:22.358034	2024-08-09 06:36:01.966744
CREATE TABLE `users` ( `id` INTEGER AUTO_INCREMENT...	myapp		3	2	0	256104953000	255741520000	85368317000	2249000000	0	0	0	0	0	0	0	0	0	0	9e0f10c8873d4bc7759fe543035cc707be3669d061942412f4...	2024-08-09 06:33:46.949761	2024-08-09 06:35:26.109558
SELECT ? FROM `performance_schema` . `table_lock_w...	performance_schema	*	1415	0	0	253241427000	1363666000	178969000	120115000000	1415	1	1415	1	0	0	0	0	0	0	0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...	2024-08-09 06:30:51.755919	2024-08-09 06:36:18.307404

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.