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.0074 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		7522	0	0	8352282716000	9893180000	1110380000	2736513000000	500336	67	2524246	336	0	0	7522	0	500336	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 02:00:55.594020	2024-08-09 02:12:22.053419
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	15052	0	0	8184934121000	6810284000	543777000	2993184000000	126427	8	849413	56	0	0	33863	0	230276	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:00:55.661037	2024-08-09 02:12:22.175103
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		25189	0	0	6829638316000	4397462000	271135000	3695447000000	25153	1	151026	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 02:01:40.899886	2024-08-09 02:11:47.070722
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	7518	0	0	6096697398000	5127313000	810946000	671200000000	7518	1	4315332	574	0	0	7518	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 02:00:55.573427	2024-08-09 02:12:22.163976
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	3768	0	0	4572526908000	69579700000	1213515000	1703560000000	4380	1	1545300	410	0	0	3764	0	4380	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 02:00:55.590947	2024-08-09 02:12:22.042443
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		7547	0	0	2842690591000	4897782000	376664000	1605355000000	0	0	22641	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 02:00:55.577216	2024-08-09 02:12:22.043840
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		3764	0	0	2372493288000	6609624000	630311000	1261747000000	11269	3	63892	17	0	0	3764	0	11269	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 02:00:55.595327	2024-08-09 02:12:22.045499
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	18	0	0	2282068552000	1049425144000	126781586000	5520000000	156	9	112776	6265	0	0	102	12	6976	12	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-08-09 02:01:40.898989	2024-08-09 02:11:31.135840
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	3582	0	0	2047636753000	4108933000	571646000	738537000000	3582	1	14328	4	0	0	25074	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 02:00:55.683303	2024-08-09 02:12:22.187255
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	2654	0	0	1638087615000	7102656000	617214000	601674000000	23996	9	157892	59	0	0	6028	0	44124	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:00:55.384850	2024-08-09 02:12:22.916447
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	3578	0	0	1520785110000	2146134000	425037000	130129000000	3578	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-08-09 02:00:56.143394	2024-08-09 02:12:22.043100
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1742	0	11	1056725522000	4573569000	606616000	390162000000	16226	9	104666	60	0	0	3886	0	28832	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:00:55.452758	2024-08-09 02:12:23.459416
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	3578	0	0	967983720000	4396237000	270537000	234815000000	89450	25	89450	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-08-09 02:00:56.140063	2024-08-09 02:12:22.040324
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir...	sakila	*	4	0	0	917946878000	322881008000	229486719000	616000000	3	1	968397	242099	0	0	9	0	600	0	91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6...	2024-08-09 02:07:24.321512	2024-08-09 02:07:27.204829
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	344	0	0	844785310000	414996773000	2455771000	164951000000	1816	5	133749	389	0	0	302	0	1816	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 02:01:03.617580	2024-08-09 02:12:22.863329
SHOW TABLES FROM `phpmyadmin`	NULL		5508	5508	0	819599207000	1511115000	148801000	341092000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 02:00:55.372490	2024-08-09 02:12:23.654344
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	27	0	2	759181416000	76131321000	28117830000	9626000000	148	5	415	15	0	0	72	0	1702	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-08-09 02:03:30.270224	2024-08-09 02:11:42.978356
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		3578	0	0	757785701000	2823552000	211790000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-08-09 02:00:56.148870	2024-08-09 02:12:22.047224
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		672	0	0	724473230000	4250811000	1078085000	266106000000	31205	46	160554	239	0	0	636	0	31117	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 02:01:03.523259	2024-08-09 02:12:22.865396
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		5246	0	0	716118647000	1691737000	136507000	357691000000	5246	1	5246	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-08-09 02:00:55.419227	2024-08-09 02:12:23.692931
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		11	0	0	668263726000	606487248000	60751247000	6286000000	11	1	39	4	0	0	6	0	0	0	251552b68e8f44795ca803316d221e604ec58591e3d9d3654e...	2024-08-09 02:06:37.886953	2024-08-09 02:12:13.516297
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		852	0	0	654696545000	5376162000	768423000	341826000000	13148	15	62232	73	0	0	417	0	10116	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 02:01:02.833243	2024-08-09 02:12:23.466288
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	607	0	0	629109251000	4873944000	1036423000	76940000000	2535	4	26315	43	0	0	580	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-08-09 02:01:48.815449	2024-08-09 02:12:00.082464
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	1059	0	0	615237605000	3190955000	580960000	236258000000	8628	8	56346	53	0	0	2049	0	15410	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 02:01:02.873102	2024-08-09 02:12:23.495002
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir...	NULL	*	2	0	0	582748919000	297025883000	291374459000	797000000	2	1	645598	322799	0	0	6	0	400	0	91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6...	2024-08-09 02:07:28.215964	2024-08-09 02:07:28.925819

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.