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.0064 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	*	2360	0	0	1368698067000	3445683000	579956000	497101000000	21287	9	144467	61	0	0	5310	0	39034	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 16:01:01.253383	2024-07-11 16:06:14.703621
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1180	0	0	1343033091000	6839102000	1138163000	447410000000	74822	63	377650	320	0	0	1180	0	74822	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-11 16:01:01.119536	2024-07-11 16:06:14.536889
INSERT INTO `regiones` VALUES (...)	bd_geografico		25	0	0	1040511255000	186935757000	41620450000	3602000000	0	0	0	0	25	1	0	0	0	0	7a3d654bac95577dba6ae2c41b18c5e32fc97c366e898bf889...	2024-07-11 16:02:24.480608	2024-07-11 16:02:25.631053
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1180	0	0	1030783612000	6684078000	873545000	107987000000	1180	1	677320	574	0	0	1180	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-11 16:01:01.090963	2024-07-11 16:06:14.682988
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1552	0	11	911984478000	5748047000	587618000	325756000000	15281	10	99500	64	0	0	3478	0	27256	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 16:01:01.829462	2024-07-11 16:06:14.661618
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		639	0	0	675357346000	3491778000	1056897000	237942000000	31849	50	163011	255	0	0	625	0	31817	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-07-11 16:01:01.652194	2024-07-11 16:06:14.588633
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	880	0	0	637330450000	3806764000	724239000	227470000000	9052	10	58887	67	0	0	2018	0	16860	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 16:01:01.351379	2024-07-11 16:06:14.614138
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	590	0	0	626249593000	6979440000	1061439000	285127000000	590	1	82646	140	0	0	590	0	590	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 16:01:01.115397	2024-07-11 16:06:14.526274
SHOW SESSION VARIABLES LIKE ?	mysql	*	592	0	0	525584756000	2707072000	887812000	54460000000	592	1	339808	574	0	0	592	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-07-11 16:01:01.648794	2024-07-11 16:06:14.644624
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1274	0	0	503619090000	6546636000	395305000	281347000000	0	0	3822	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-11 16:01:01.107946	2024-07-11 16:06:14.527672
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1335	0	0	477791584000	2046246000	357896000	269067000000	0	0	4005	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-07-11 16:01:01.650916	2024-07-11 16:06:14.586235
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		590	0	0	390954061000	2242952000	662634000	208345000000	1739	3	9906	17	0	0	590	0	1739	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-11 16:01:01.121346	2024-07-11 16:06:14.529452
SHOW TABLES FROM `phpmyadmin`	NULL		1760	1760	0	361567385000	775090000	205436000	148144000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-07-11 16:01:01.065129	2024-07-11 16:06:14.683034
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	590	0	0	342402970000	2867638000	580344000	124542000000	590	1	2360	4	0	0	4130	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-11 16:01:01.290986	2024-07-11 16:06:14.720113
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	307	0	0	337803754000	38775272000	1100337000	132581000000	307	1	31982	104	0	0	307	0	307	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 16:01:01.725044	2024-07-11 16:06:14.587356
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		306	0	0	313838964000	79575965000	1025617000	108401000000	614	2	20177	66	0	0	306	0	614	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-07-11 16:01:01.686464	2024-07-11 16:06:14.575433
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	NULL	*	239	0	0	281267196000	13943007000	1176850000	144704000000	4725	20	23868	100	0	0	35	0	4725	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-07-11 16:01:02.020818	2024-07-11 16:06:13.495337
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	408	0	0	228578621000	2866283000	560241000	82875000000	408	1	1632	4	0	0	2856	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-11 16:01:01.869769	2024-07-11 16:06:14.686513
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	perpustakaan_ruth	*	360	0	0	216244489000	3191487000	600679000	77561000000	3244	9	22100	61	0	0	799	0	5946	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 16:01:52.906917	2024-07-11 16:05:56.770452
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	198	0	0	214792495000	2324457000	1084810000	24278000000	290	1	8244	42	0	0	194	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-07-11 16:01:32.891591	2024-07-11 16:05:55.688938
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	CREATE DATABASE UNGGOY;	*	348	0	0	201553325000	1910406000	579176000	74994000000	3200	9	20761	60	0	0	765	0	5874	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-07-11 16:04:09.173912	2024-07-11 16:06:14.463670
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		1350	0	0	191234393000	932765000	141655000	93718000000	1350	1	1350	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-07-11 16:01:01.082984	2024-07-11 16:06:14.712571
SELECT @@`version` , @@`version_comment`	NULL		1754	0	0	189084637000	1118235000	107801000	0	1754	1	1754	1	0	0	0	0	0	0	a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff...	2024-07-11 16:01:01.063260	2024-07-11 16:06:14.682540
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	322	0	0	185511025000	2372961000	576121000	60750000000	322	1	1288	4	0	0	2254	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-07-11 16:01:01.330022	2024-07-11 16:06:14.662625
CREATE TABLE `regiones` ( `idDepa` INTEGER NOT NUL...	bd_geografico		1	0	1	183218821000	183218821000	183218821000	3689000000	0	0	0	0	0	0	0	0	0	0	a8e8df74d36dc1dcfa8bd6d8281bf30cc3f6bb6cf8a38ec927...	2024-07-11 16:02:24.345959	2024-07-11 16:02:24.345959

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!