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.0092 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		22329	0	0	6178456268000	611935713000	276700000	3015430000000	22288	1	133851	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 15:32:01.256855	2024-08-09 15:44:51.137614
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	2939	0	0	2051414470000	11120558000	697997000	734595000000	30103	10	199318	68	0	0	6714	0	56000	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 15:30:57.205063	2024-08-09 15:44:55.021465
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1080	0	0	1180753939000	5157648000	1093290000	400766000000	65282	60	329598	305	0	0	1079	0	65256	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 15:30:58.717100	2024-08-09 15:44:55.604882
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	2155	0	0	1123524852000	2325552000	521357000	407720000000	19754	9	134365	62	0	0	4849	0	36276	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 15:30:58.838146	2024-08-09 15:44:50.684437
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	1073	0	0	896081276000	4404646000	835117000	97793000000	1073	1	615902	574	0	0	1073	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 15:30:58.709038	2024-08-09 15:44:55.590301
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	1410	0	14	777448265000	2430223000	551381000	279589000000	15004	11	96274	68	0	0	3149	0	26507	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 15:30:57.356925	2024-08-09 15:44:47.649572
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	33	0	5	775963707000	77061860000	23514051000	15879000000	156	5	450	14	0	0	88	0	1965	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-08-09 15:32:01.255544	2024-08-09 15:44:51.181939
SHOW TABLES FROM `phpmyadmin`	NULL		2728	2728	0	625018370000	1524787000	229112000	251876000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 15:30:57.168386	2024-08-09 15:44:55.622887
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	1036	0	0	567817512000	3175366000	548086000	185697000000	1036	1	4144	4	0	0	7252	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 15:30:57.173902	2024-08-09 15:44:55.034659
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	67	*	164	0	0	558498764000	388240579000	3405480000	78796000000	325	2	4147	25	0	0	75	0	325	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 15:35:03.157801	2024-08-09 15:43:40.251016
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	541	0	0	549494550000	2980336000	1015701000	251704000000	541	1	76667	142	0	0	541	0	541	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 15:30:58.714582	2024-08-09 15:44:55.593609
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		45	0	0	544609375000	82625100000	12102430000	19512000000	112	2	1213	27	0	0	45	0	112	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 15:31:05.034344	2024-08-09 15:44:14.935354
ALTER TABLE `admin_acc` ADD PRIMARY KEY ( `admin_i...	cee_db		1	0	0	499379199000	499379199000	499379199000	36678000000	0	0	0	0	0	0	0	0	0	0	62a6bf1739d7357ca53ea1029d08b2064483db09e8b620e605...	2024-08-09 15:39:31.604078	2024-08-09 15:39:31.604078
ALTER TABLE `exam_question_tbl` ADD PRIMARY KEY ( ...	cee_db		1	0	0	494293599000	494293599000	494293599000	281000000	0	0	0	0	0	0	0	0	0	0	6959be637d57934c5a0e65b87771e95f60c2e0ebe91d9cf797...	2024-08-09 15:39:33.854452	2024-08-09 15:39:33.854452
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	468	0	0	488387303000	5642775000	1043562000	57665000000	1061	2	19675	42	0	0	454	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-08-09 15:30:58.549665	2024-08-09 15:44:43.054938
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		465	0	0	488324981000	4396358000	1050161000	182290000000	21358	46	109226	235	0	0	454	0	21291	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 15:30:57.736433	2024-08-09 15:44:33.452964
ALTER TABLE `course_tbl` ADD PRIMARY KEY ( `cou_id...	cee_db		1	0	0	485787848000	485787848000	485787848000	133000000	0	0	0	0	0	0	0	0	0	0	b1ac0fa5db1b909d32a7c7667ce540d20a5bf4bffeb162b314...	2024-08-09 15:39:32.094177	2024-08-09 15:39:32.094177
ALTER TABLE `feedbacks_tbl` ADD PRIMARY KEY ( `fb_...	cee_db		1	0	0	484098273000	484098273000	484098273000	247000000	0	0	0	0	0	0	0	0	0	0	10d19d92286681b35eee88ce92d0d69212ffdfd0b3e2a37c70...	2024-08-09 15:39:34.797923	2024-08-09 15:39:34.797923
SHOW SESSION VARIABLES LIKE ?	mysql	*	532	0	0	465217194000	2982111000	874468000	46874000000	532	1	305368	574	0	0	532	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 15:30:57.729339	2024-08-09 15:44:55.360504
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		214	0	0	457355407000	75210817000	2137174000	73848000000	432	2	13601	64	0	0	214	0	432	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 15:30:57.773540	2024-08-09 15:44:33.439953
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	21	0	0	444591208000	373430898000	21171009000	7264000000	357	17	1560	74	0	0	1	0	201	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 15:30:58.462738	2024-08-09 15:40:21.456539
ALTER TABLE `exam_attempt` ADD PRIMARY KEY ( `exam...	cee_db		1	0	0	443249484000	443249484000	443249484000	95000000	0	0	0	0	0	0	0	0	0	0	fb34d5055416606b0c002a7104006d369d285980ca0df56be6...	2024-08-09 15:39:33.345549	2024-08-09 15:39:33.345549
ALTER TABLE `exam_tbl` ADD PRIMARY KEY ( `ex_id` )	cee_db		1	0	0	439304200000	439304200000	439304200000	143000000	0	0	0	0	0	0	0	0	0	0	da5ef8c19801eb1a947062bb6cffc81809178c8f386aaca73d...	2024-08-09 15:39:34.299744	2024-08-09 15:39:34.299744
ALTER TABLE `exam_answers` MODIFY `exans_id` INTEG...	cee_db		1	0	1	418782101000	418782101000	418782101000	397000000	0	0	0	0	26	26	0	0	0	0	d84bd25a230dbb7f0bcd95ad4a98abadd189dd138adc31e44a...	2024-08-09 15:39:36.327912	2024-08-09 15:39:36.327912
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		1101	0	0	418353386000	1981528000	379975000	234164000000	0	0	3303	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 15:30:58.713041	2024-08-09 15:44:55.595186

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.