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.0101 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 `CATALOG_NAME` , `sch` . ...	performance_schema	*	1871	0	0	1259467621000	4113549000	673152000	472342000000	16112	9	108768	58	0	0	4210	0	29418	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 07:16:01.425507	2024-08-09 07:25:59.152625
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		938	0	0	1217808989000	7008353000	1298303000	417337000000	57700	62	291314	311	0	0	938	0	57700	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 07:16:01.253849	2024-08-09 07:25:59.097438
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	1327	0	0	947784004000	5095450000	714230000	351064000000	12576	9	81735	62	0	0	3026	0	23242	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 07:16:01.043433	2024-08-09 07:25:57.789219
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	937	0	0	876477726000	6438007000	935408000	90786000000	937	1	537838	574	0	0	937	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 07:16:01.172468	2024-08-09 07:25:59.136026
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	DASD	*	1209	0	0	777657116000	2724212000	643223000	300517000000	10546	9	66706	55	0	0	2616	0	18524	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 07:16:29.164707	2024-08-09 07:24:10.036944
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1163	0	10	767762720000	3494883000	660157000	288210000000	11245	10	71675	62	0	0	2556	0	19622	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 07:16:01.340629	2024-08-09 07:26:00.847437
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	215	0	0	764885905000	435063187000	3557608000	100200000000	631	3	87000	405	0	0	204	0	598	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 07:16:01.250722	2024-08-09 07:26:00.763552
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	469	0	0	649062337000	8980853000	1383928000	243920000000	469	1	192887	411	0	0	469	0	469	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 07:16:01.250690	2024-08-09 07:25:59.086279
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		27	0	0	534896017000	96289911000	19810963000	9906000000	75	3	796	29	0	0	27	0	75	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 07:16:02.288320	2024-08-09 07:25:56.648920
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	DASD	*	464	0	0	474787512000	50912432000	1023248000	231796000000	373	1	73342	158	0	0	176	0	361	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 07:16:27.378343	2024-08-09 07:24:10.052708
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	15	0	4	458011263000	73620436000	30534084000	8168000000	29	2	299	20	0	0	40	0	917	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-08-09 07:16:09.606458	2024-08-09 07:25:51.184753
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		196	0	0	452146347000	82051515000	2306869000	75467000000	396	2	12139	62	0	0	196	0	396	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 07:16:01.191912	2024-08-09 07:26:00.749799
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		387	0	0	441100312000	5015690000	1139794000	157339000000	18248	47	92952	240	0	0	375	0	18121	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 07:16:01.139169	2024-08-09 07:26:00.765484
SHOW SESSION VARIABLES LIKE ?	mysql	*	457	0	0	428105093000	5480888000	936772000	42495000000	457	1	262318	574	0	0	457	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 07:16:01.134609	2024-08-09 07:26:00.830632
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		968	0	0	414488613000	2355222000	428190000	233781000000	0	0	2904	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 07:16:01.241335	2024-08-09 07:25:59.090755
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		469	0	0	352904998000	1803978000	752462000	186860000000	1393	3	7919	17	0	0	469	0	1393	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 07:16:01.255567	2024-08-09 07:25:59.092227
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		901	0	0	348105082000	1140029000	386354000	195657000000	0	0	2703	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 07:16:01.137252	2024-08-09 07:26:00.761851
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	285	0	0	343342231000	3120328000	1204709000	40927000000	561	2	11754	41	0	0	273	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-08-09 07:16:23.508523	2024-08-09 07:25:20.797114
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	466	0	0	303180131000	1786516000	650601000	112753000000	466	1	1864	4	0	0	3262	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 07:16:01.464435	2024-08-09 07:25:59.167042
SHOW TABLES FROM `phpmyadmin`	NULL		1892	1892	0	284168025000	883838000	150194000	117138000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 07:16:01.033520	2024-08-09 07:26:01.022921
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	34	0	0	274325027000	54502688000	8068383000	17949000000	34	1	14022	412	0	0	34	0	34	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 07:16:02.310100	2024-08-09 07:26:00.757514
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	464	0	0	265912544000	1038004000	573087000	86051000000	464	1	1856	4	0	0	3248	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 07:16:01.082227	2024-08-09 07:25:57.756670
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		329	0	0	261081281000	2913105000	793560000	134596000000	5100	16	24151	73	0	0	162	0	3932	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 07:16:01.631713	2024-08-09 07:25:31.793797
CREATE TABLE `Musaid` . `Soniya` ( `Ugarname` VARC...	Musaid		1	0	0	228718262000	228718262000	228718262000	147000000	0	0	0	0	0	0	0	0	0	0	8284c4da162e286fbe14a4694600925fcf42ec78da97b9c14f...	2024-08-09 07:20:55.808742	2024-08-09 07:20:55.808742
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	352	0	0	222153966000	2976351000	631119000	85798000000	3056	9	20217	57	0	0	736	0	5538	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 07:16:01.801784	2024-08-09 07:25:31.825665

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.