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.

Your SQL query has been executed successfully.

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		4263	0	0	1130394974000	1724458000	265164000	615466000000	4254	1	25551	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:47:29.761638	2025-07-01 00:54:08.667796
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		449	0	0	616599377000	8297050000	1373272000	220618000000	22142	49	112893	251	0	0	442	0	22112	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-01 00:45:47.682880	2025-07-01 00:54:40.581324
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1030	0	0	541602233000	3705761000	525827000	191793000000	8800	9	58551	57	0	0	2318	0	16080	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:45:47.832165	2025-07-01 00:54:40.615763
SHOW SESSION VARIABLES LIKE ?	mysql	*	471	0	0	515167963000	10150449000	1093774000	50645000000	471	1	270354	574	0	0	471	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-01 00:45:47.669080	2025-07-01 00:54:40.609636
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		227	0	0	495491472000	84168641000	2182781000	125729000000	456	2	14521	64	0	0	227	0	456	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:45:47.714645	2025-07-01 00:54:40.570219
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		1069	0	0	494025210000	4161822000	462137000	272130000000	0	0	3207	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:45:47.677415	2025-07-01 00:54:40.579061
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	221	0	0	396392935000	53097457000	1793633000	105508000000	221	1	91268	413	0	0	221	0	221	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:45:47.777021	2025-07-01 00:54:40.580183
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		208	0	0	295455187000	4781171000	1420457000	102034000000	12154	58	61394	295	0	0	208	0	12154	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2025-07-01 00:45:49.802722	2025-07-01 00:54:37.787408
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	219	0	0	218622365000	3752931000	998275000	79174000000	1930	9	12752	58	0	0	497	0	3540	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:45:49.010220	2025-07-01 00:54:36.008518
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	208	0	0	205242830000	3941999000	986744000	21907000000	208	1	119392	574	0	0	208	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2025-07-01 00:45:49.794892	2025-07-01 00:54:37.897754
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sku		35	0	0	200397530000	66996172000	5725643000	16966000000	59	2	690	20	0	0	35	0	59	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:46:06.633160	2025-07-01 00:51:41.141458
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	416	0	0	194467304000	1986222000	467469000	69920000000	3432	8	22984	55	0	0	936	0	6240	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2025-07-01 00:45:49.902871	2025-07-01 00:54:37.904309
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		10	0	0	194250139000	64043443000	19425013000	9699000000	18	2	222	22	0	0	10	0	18	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:49:39.094148	2025-07-01 00:52:46.553804
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	104	0	0	179487154000	4594880000	1725838000	68244000000	104	1	42640	410	0	0	104	0	104	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:45:49.800486	2025-07-01 00:54:37.773441
SHOW TABLES FROM `phpmyadmin`	NULL		563	563	0	146180782000	1355970000	259646000	59317000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2025-07-01 00:45:47.640258	2025-07-01 00:54:41.780442
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sku	*	26	0	0	142002947000	26655649000	5461651000	17099000000	46	2	9150	352	0	0	22	0	46	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:46:06.701065	2025-07-01 00:52:07.395205
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	StdMdDB	*	44	0	0	134561216000	69610904000	3058209000	30112000000	104	2	12279	279	0	0	30	0	104	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:47:06.855216	2025-07-01 00:54:10.473034
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	mysql	*	268	0	0	131228009000	1948021000	489656000	43061000000	268	1	1072	4	0	0	1876	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2025-07-01 00:45:47.839267	2025-07-01 00:54:40.617789
SELECT `performance_schema` . `events_statements_s...	sys	*	66	0	0	122851811000	8778116000	1861391000	10508000000	572	9	9949	151	0	0	0	0	572	0	8b22b06fe671437418edb1a3633c0f481cc712f261f1eb7654...	2025-07-01 00:47:29.760714	2025-07-01 00:54:08.674619
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	6	0	0	112479320000	33483833000	18746553000	6144000000	6	1	2466	411	0	0	6	0	6	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2025-07-01 00:49:39.241178	2025-07-01 00:52:46.596150
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		211	0	0	111351980000	1740540000	527734000	62128000000	0	0	633	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2025-07-01 00:45:49.798373	2025-07-01 00:54:37.774965
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	StdMdDB		32	0	0	103609676000	26836234000	3237802000	19757000000	18	1	450	14	0	0	32	0	18	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:47:42.854116	2025-07-01 00:53:44.440921
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	mysql	*	47	0	0	100710624000	4811115000	2142779000	12616000000	12784	272	14711	313	0	0	47	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2025-07-01 00:45:49.495251	2025-07-01 00:54:18.353353
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		104	0	0	92696750000	2479413000	891314000	49034000000	308	3	1752	17	0	0	104	0	308	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2025-07-01 00:45:49.803548	2025-07-01 00:54:37.776846
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		488	0	0	88854799000	2735366000	182079000	39808000000	488	1	488	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2025-07-01 00:45:47.656005	2025-07-01 00:54:41.786190

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-5377-g8e721911f0 from the master branch.