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.0102 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		40153	0	0	10910963229000	4424691000	271734000	5891560000000	40099	1	240756	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-04 10:31:17.886019	2024-07-04 10:44:01.389978
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	15807	0	0	9300388674000	6263798000	588371000	3364474000000	139635	9	943717	60	0	0	35566	0	255560	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-04 10:31:01.491368	2024-07-04 10:44:02.158846
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		7900	0	0	9123708651000	21312870000	1154899000	2987783000000	523926	66	2643330	335	0	0	7900	0	523926	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-04 10:31:01.366563	2024-07-04 10:44:02.024059
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	7898	0	0	6626182985000	7853303000	838969000	712419000000	7898	1	4533452	574	0	0	7898	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-04 10:31:01.350436	2024-07-04 10:44:02.143728
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	3952	0	0	4773880605000	9367646000	1207965000	1806875000000	3952	1	1645917	416	0	0	3952	0	3952	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-04 10:31:01.363468	2024-07-04 10:44:02.010937
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		7939	0	0	3014669993000	4934306000	379729000	1680082000000	0	0	23817	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-04 10:31:01.356474	2024-07-04 10:44:02.012643
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		3952	0	0	2576796749000	5410414000	652023000	1377805000000	11847	3	67159	17	0	0	3952	0	11847	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-04 10:31:01.367872	2024-07-04 10:44:02.014892
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	3952	0	0	2343655548000	6475861000	593030000	841726000000	3952	1	15808	4	0	0	27664	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-04 10:31:01.513893	2024-07-04 10:44:02.172305
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	1547	0	0	1687581636000	6674046000	1090873000	200050000000	3410	2	63516	41	0	0	1466	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-04 10:31:01.915173	2024-07-04 10:44:01.510879
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	24	0	0	1654678990000	655181828000	68944957000	9698000000	208	9	154060	6419	0	0	136	16	12042	16	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-07-04 10:35:42.338520	2024-07-04 10:44:01.447343
SELECT COUNT ( * ) FROM `performance_schema` . `ta...	performance_schema	*	3738	0	0	1392191082000	5557705000	372442000	142023000000	3738	1	0	0	0	0	0	0	0	0	00e2f0d84fa651f12d7029618430a48906da993321f506b59a...	2024-07-04 10:31:01.364408	2024-07-04 10:44:02.011613
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	51	0	3	1189998972000	54333421000	23333313000	24379000000	232	5	765	15	0	0	136	0	3127	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-07-04 10:31:56.626536	2024-07-04 10:41:55.107542
SELECT * FROM `table_lock_waits_summary_by_table` ...	performance_schema	*	3738	0	0	1035926431000	3699768000	277133000	240221000000	93450	25	93450	25	0	0	0	0	0	0	7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764...	2024-07-04 10:31:01.354463	2024-07-04 10:44:02.008511
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	2411	0	0	1032661655000	3931848000	428312000	410497000000	14972	6	96581	40	0	0	3212	0	25734	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-04 10:31:01.995589	2024-07-04 10:44:02.221337
SHOW TABLES FROM `phpmyadmin`	NULL		5889	5889	0	1013518008000	1303672000	172103000	414307000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-04 10:31:01.288678	2024-07-04 10:44:02.390003
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		1376	0	0	951149693000	27236427000	691242000	503839000000	18976	14	89950	65	0	0	719	0	14447	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-04 10:31:01.917849	2024-07-04 10:44:02.184930
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ...	information_schema	*	2	0	0	930763147000	888294128000	465381573000	132000000	50	25	50	25	0	0	2	2	0	0	9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...	2024-07-04 10:36:10.928630	2024-07-04 10:38:53.650937
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		5104	0	0	908277390000	66929864000	177954000	528607000000	5104	1	5104	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-04 10:31:01.302173	2024-07-04 10:44:02.432948
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		1438	0	0	837633312000	3951342000	582498000	510170000000	0	0	4314	3	0	0	1438	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-04 10:31:01.918582	2024-07-04 10:44:02.185768
SHOW CREATE TABLE `performance_schema` . `table_lo...	performance_schema		3738	0	0	821055478000	2025800000	219651000	0	0	0	0	0	0	0	0	0	0	0	bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083...	2024-07-04 10:31:01.370268	2024-07-04 10:44:02.017148
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1101	0	9	722649498000	6028917000	656357000	263280000000	11533	10	74046	67	0	0	2487	0	20595	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-04 10:31:01.723931	2024-07-04 10:43:56.074036
SHOW SESSION VARIABLES LIKE ?	information_schema	*	794	0	0	680480549000	3811842000	857028000	71167000000	794	1	455756	574	0	0	794	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-04 10:31:01.912200	2024-07-04 10:44:02.209897
SELECT ? FROM `performance_schema` . `table_lock_w...	performance_schema	*	3738	0	0	607655591000	1741251000	162561000	282841000000	3738	1	3738	1	0	0	0	0	0	0	0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593...	2024-07-04 10:31:01.531542	2024-07-04 10:44:02.194832
SELECT @@`version` , @@`version_comment`	NULL		5889	0	0	521549848000	469133000	88563000	0	5889	1	5889	1	0	0	0	0	0	0	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	2024-07-04 10:31:01.287116	2024-07-04 10:44:02.386987
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	756	0	0	507713359000	5787725000	671578000	179420000000	8165	11	52408	69	0	0	1747	0	15288	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-04 10:31:02.072666	2024-07-04 10:44:01.521280

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!