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.3975 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		7475	0	0	9837750529000	9390035000	1316087000	3170011000000	501937	67	2532110	339	0	0	7475	0	501937	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 19:46:03.003606	2024-08-09 19:52:56.786457
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	14943	0	0	9729693625000	9239580000	651120000	3570981000000	130683	9	884812	59	0	0	33622	0	238952	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 19:46:03.154749	2024-08-09 19:52:56.793817
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		25424	0	0	7262261140000	4600984000	285645000	3924456000000	25406	1	152490	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 19:46:22.742669	2024-08-09 19:52:48.085981
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	7474	0	0	6700157372000	8788590000	896462000	675396000000	7474	1	4290076	574	0	0	7474	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 19:46:02.980171	2024-08-09 19:52:56.770181
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	3738	0	0	4195359958000	9193117000	1122354000	1921360000000	3738	1	519503	139	0	0	3738	0	3738	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 19:46:02.996520	2024-08-09 19:52:56.772922
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		7514	0	0	3194614621000	2964544000	425154000	1816941000000	0	0	22542	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 19:46:02.994382	2024-08-09 19:52:56.775927
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		3738	0	0	2769158655000	6249916000	740812000	1455886000000	11210	3	63535	17	0	0	3738	0	11210	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 19:46:03.004915	2024-08-09 19:52:56.777820
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	3235	0	0	2084849819000	5792188000	644466000	742633000000	3235	1	12940	4	0	0	22645	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 19:46:03.178204	2024-08-09 19:52:56.831001
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	3631	0	0	1460860906000	4735109000	402330000	150916000000	3631	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-08-09 19:46:03.001455	2024-08-09 19:52:56.774899
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	3631	0	0	1276113456000	11841490000	351449000	289008000000	90775	25	90775	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-08-09 19:46:02.992823	2024-08-09 19:52:56.770711
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	1805	0	0	1226222037000	8963859000	679347000	448336000000	16731	9	110770	61	0	0	4097	0	30826	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 19:46:02.993771	2024-08-09 19:52:56.526387
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		3631	0	0	893167711000	3943448000	245983000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-08-09 19:46:03.006680	2024-08-09 19:52:56.779504
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	215	0	0	707346772000	460187803000	3289984000	106657000000	1015	5	24804	115	0	0	195	0	1015	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 19:46:04.375511	2024-08-09 19:52:54.305757
SHOW TABLES FROM `phpmyadmin`	NULL		4882	4882	0	693671002000	1658157000	142087000	283397000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 19:46:02.952789	2024-08-09 19:52:56.908902
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	981	0	9	645277457000	5216018000	657775000	240599000000	9275	9	59524	61	0	0	2155	0	16280	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 19:46:04.161205	2024-08-09 19:52:54.461918
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		4652	0	0	636276879000	1409044000	136774000	312911000000	4652	1	4652	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-08-09 19:46:02.971872	2024-08-09 19:52:56.906342
SELECT ? FROM `performance_schema` . `table_lock_w...	performance_schema	*	3629	0	0	580975084000	1931581000	160092000	268378000000	3629	1	3629	1	0	0	0	0	0	0	0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...	2024-08-09 19:46:03.196613	2024-08-09 19:52:56.880507
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	18	0	0	508246841000	64543999000	28235935000	5772000000	156	9	156	9	0	0	48	0	1240	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-08-09 19:46:22.741614	2024-08-09 19:52:48.152309
SELECT `c` . `name` AS `category` , SUM ( `p` . `a...	sakila	*	10	0	0	507069109000	161921224000	50706910000	2345000000	37	4	37	4	0	0	14	0	112	0	a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4...	2024-08-09 19:46:05.401988	2024-08-09 19:52:36.977545
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		45	0	0	463342637000	89723262000	10296503000	18639000000	73	2	899	20	0	0	45	0	73	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 19:46:05.406515	2024-08-09 19:52:36.789468
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		389	0	0	456001091000	6941384000	1172239000	160502000000	19100	49	97440	250	0	0	384	0	19076	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 19:46:04.315533	2024-08-09 19:52:54.306885
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	test19		2	0	0	388590184000	315814311000	194295092000	750000000	5	3	37	19	0	0	2	0	5	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 19:46:03.146364	2024-08-09 19:49:53.479281
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	3	0	1	384335746000	362440876000	128111915000	653000000	12	4	12	4	0	0	9	2	1068	2	ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77...	2024-08-09 19:49:53.535140	2024-08-09 19:49:53.792649
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		190	0	0	362488387000	76438337000	1907833000	73880000000	385	2	12342	65	0	0	190	0	385	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 19:46:04.342025	2024-08-09 19:52:54.282969
SHOW SESSION VARIABLES LIKE ?	mysql	*	373	0	0	346734928000	4886848000	929584000	32616000000	373	1	214102	574	0	0	373	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 19:46:04.149238	2024-08-09 19:52:54.433973

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4871-gddd3d98559 from the master branch.