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.1988 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		25469	0	0	6983104363000	2532841000	274180000	3790593000000	25443	1	152736	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-01 07:01:28.097731	2024-07-01 07:04:42.730031
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	3248	0	0	1929319200000	7219335000	594002000	692564000000	29890	9	203875	63	0	0	7308	0	54908	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 07:00:56.876274	2024-07-01 07:04:46.194977
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1624	0	0	1876023479000	5687211000	1155186000	634558000000	99880	62	504272	311	0	0	1624	0	99880	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 07:00:56.807044	2024-07-01 07:04:46.069690
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	1569	0	0	1770248665000	5390502000	1128265000	200800000000	2282	1	65340	42	0	0	1538	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-01 07:01:23.729538	2024-07-01 07:04:45.710251
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1624	0	0	1385898594000	9848415000	853385000	145876000000	1624	1	932176	574	0	0	1624	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-01 07:00:56.798008	2024-07-01 07:04:46.181896
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	812	0	0	986091551000	2622005000	1214398000	375105000000	812	1	333483	411	0	0	812	0	812	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 07:00:56.804793	2024-07-01 07:04:46.056860
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ...	information_schema	*	2	0	0	924449688000	862237618000	462224844000	134000000	50	25	50	25	0	0	2	2	0	0	9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...	2024-07-01 07:01:27.345978	2024-07-01 07:01:51.001898
CREATE SCHEMA `nist2` DEFAULT CHARSET = `utf8mb4` ...	NULL		1	0	0	896015619000	896015619000	896015619000	2260000000	0	0	0	0	1	1	0	0	0	0	a47c0c67bcd2983536d11449726dc7eef6fd7c83f97de0f3f3...	2024-07-01 07:01:16.234039	2024-07-01 07:01:16.234039
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	33	0	6	868508190000	62004014000	26318430000	17060000000	184	6	456	14	0	0	88	0	2044	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-07-01 07:01:28.096824	2024-07-01 07:04:42.815183
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	1567	0	0	743804202000	2964467000	474667000	296851000000	10652	7	69527	44	0	0	2240	0	18580	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 07:01:01.341462	2024-07-01 07:04:45.675194
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	1000	0	0	686287635000	3099316000	686287000	349873000000	15340	15	74210	74	0	0	471	0	11645	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 07:01:01.279134	2024-07-01 07:04:45.628351
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1672	0	0	635443632000	2006367000	380050000	354481000000	0	0	5016	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-01 07:00:56.802190	2024-07-01 07:04:46.058330
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1017	0	8	616414382000	5169555000	606110000	229493000000	10085	10	63324	62	0	0	2068	0	17164	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 07:00:56.279411	2024-07-01 07:04:45.984417
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		942	0	0	562683839000	3104302000	597328000	330060000000	0	0	2826	3	0	0	942	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 07:01:01.280114	2024-07-01 07:04:45.628962
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		812	0	0	549219501000	3022515000	676378000	284108000000	2420	3	13740	17	0	0	812	0	2420	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 07:00:56.807872	2024-07-01 07:04:46.060970
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	812	0	0	481958529000	2959750000	593544000	174991000000	812	1	3248	4	0	0	5684	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-01 07:00:56.898793	2024-07-01 07:04:46.209969
SHOW SESSION VARIABLES LIKE ?	information_schema	*	548	0	0	469391315000	3570582000	856553000	47051000000	548	1	314552	574	0	0	548	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-01 07:01:01.269158	2024-07-01 07:04:45.663991
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	577	0	0	432264406000	3572158000	749158000	153012000000	6558	11	41572	72	0	0	1342	0	12338	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-01 07:00:56.425481	2024-07-01 07:04:42.941916
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		393	0	0	384493372000	4832597000	978354000	153746000000	13912	35	71553	182	0	0	338	0	13664	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-01 07:00:56.121701	2024-07-01 07:04:45.913620
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		178	0	0	348206207000	69218859000	1956214000	65506000000	366	2	9061	51	0	0	178	0	366	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-01 07:00:56.177265	2024-07-01 07:04:44.596954
SHOW GLOBAL VARIABLES LIKE ?	nist2	*	5	0	0	344051566000	341178144000	68810313000	405000000	5	1	2765	553	0	0	5	0	0	0	1fe7aba925a48c9ab55b7b197d166da67a92d13a24185cf5d8...	2024-07-01 07:01:27.121058	2024-07-01 07:02:34.936994
SHOW TABLES FROM `phpmyadmin`	NULL		1898	1898	0	332943518000	721436000	175418000	135384000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-01 07:00:56.093520	2024-07-01 07:04:46.167146
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	15	0	0	306689591000	212897102000	20445972000	6473000000	147	10	5040	336	0	0	11	0	147	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 07:01:02.414279	2024-07-01 07:04:32.336918
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	185	0	0	299780401000	35997574000	1620434000	84807000000	1333	7	66639	360	0	0	144	0	1333	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 07:00:56.224151	2024-07-01 07:04:45.959506
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	209	0	0	271787615000	19272002000	1300419000	131429000000	7176	34	29226	140	0	0	18	0	7176	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-01 07:01:01.251279	2024-07-01 07:04:45.595458

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!