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.0236 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		4389	0	0	1730634700000	611935713000	394311000	608679000000	4377	1	26298	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 15:32:01.256855	2024-08-09 15:32:57.753069
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	NULL	*	885	0	0	613568862000	11120558000	693298000	221197000000	7994	9	52969	60	0	0	2010	0	14698	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 15:30:57.205063	2024-08-09 15:33:20.207509
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	3	0	0	376277584000	373430898000	125425861000	922000000	26	9	128	43	0	0	0	0	0	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 15:30:58.462738	2024-08-09 15:30:58.684750
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	12	0	3	338509751000	77061860000	28209145000	7922000000	42	4	204	17	0	0	32	0	720	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-08-09 15:32:01.255544	2024-08-09 15:32:57.797451
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		222	0	0	266462249000	3990020000	1200280000	87039000000	14084	63	71086	320	0	0	222	0	14084	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 15:30:58.717100	2024-08-09 15:33:18.824314
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	444	0	0	245972429000	1917348000	553991000	90455000000	3721	8	24937	56	0	0	999	0	6776	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 15:30:58.838146	2024-08-09 15:33:18.947680
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila	*	25	0	0	232129715000	194050238000	9285188000	14002000000	267	11	1853	74	0	0	17	0	267	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 15:31:05.050949	2024-08-09 15:32:49.318792
CREATE TABLE `student` . `studentinfo` ( `studentn...	student		1	0	0	225571661000	225571661000	225571661000	6352000000	0	0	0	0	0	0	0	0	0	0	65bb9fa40d02010e78f0b9331c23bbea7ef1e4c161a31ae850...	2024-08-09 15:31:36.516197	2024-08-09 15:31:36.516197
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	222	0	0	205380301000	4404646000	925136000	19753000000	222	1	127428	574	0	0	222	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 15:30:58.709038	2024-08-09 15:33:18.936377
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	298	0	3	171527116000	2255931000	575594000	62228000000	2838	10	18016	60	0	0	660	0	4986	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-08-09 15:30:57.356925	2024-08-09 15:33:18.582326
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sakila		11	0	0	165624914000	80033922000	15056810000	6005000000	24	2	261	24	0	0	11	0	24	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 15:31:05.034344	2024-08-09 15:32:49.328022
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	NULL	*	285	0	0	158065364000	3166420000	554615000	51086000000	285	1	1140	4	0	0	1995	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-08-09 15:30:57.173902	2024-08-09 15:33:20.225460
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		47	0	0	149232583000	71239102000	3175161000	15993000000	95	2	3029	64	0	0	47	0	95	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 15:30:57.773540	2024-08-09 15:33:07.870636
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	111	0	0	121859449000	2897575000	1097832000	54882000000	111	1	15265	138	0	0	111	0	111	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-08-09 15:30:58.714582	2024-08-09 15:33:18.813104
SHOW SESSION VARIABLES LIKE ?	mysql	*	121	0	0	113621594000	2603542000	939021000	10936000000	121	1	69454	574	0	0	121	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-08-09 15:30:57.729339	2024-08-09 15:33:18.556389
SHOW TABLES FROM `phpmyadmin`	NULL		556	556	0	111613536000	773972000	200743000	44944000000	0	0	0	0	0	0	0	0	0	0	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...	2024-08-09 15:30:57.168386	2024-08-09 15:33:20.341870
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		95	0	0	105134037000	2709630000	1106674000	36472000000	4644	49	23681	249	0	0	94	0	4638	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 15:30:57.736433	2024-08-09 15:33:07.883430
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		225	0	0	90306571000	1981528000	401362000	51786000000	0	0	675	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 15:30:58.713041	2024-08-09 15:33:18.814394
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		232	0	0	88306489000	2997024000	380631000	48381000000	0	0	696	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-08-09 15:30:57.733582	2024-08-09 15:33:07.881128
SET `lc_messages` = ?	NULL		425	0	0	86899135000	7192504000	204468000	0	0	0	0	0	0	0	0	0	0	0	67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec...	2024-08-09 15:30:57.167464	2024-08-09 15:33:20.341560
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ...	NULL	*	407	0	0	86755892000	1747844000	213159000	19950000000	407	1	70411	173	0	0	407	0	0	0	cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc...	2024-08-09 15:30:57.238665	2024-08-09 15:33:20.226091
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		111	0	0	79043268000	2702799000	712101000	41538000000	332	3	1883	17	0	0	111	0	332	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-08-09 15:30:58.717979	2024-08-09 15:33:18.816310
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		94	0	0	72143298000	2287001000	767481000	36255000000	1554	17	7286	78	0	0	39	0	1171	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-08-09 15:30:57.944564	2024-08-09 15:33:07.530061
CREATE SCHEMA `student` DEFAULT CHARSET = `utf8mb4...	NULL		1	0	0	66536791000	66536791000	66536791000	3345000000	0	0	0	0	1	1	0	0	0	0	9f45599c070e7d828a32d9f4d2ee0f89e24f6285b78ebe65f6...	2024-08-09 15:31:24.448985	2024-08-09 15:31:24.448985
SELECT ? FROM `mysql` . `user` LIMIT ?	NULL		511	0	0	64928457000	1095943000	127061000	31238000000	511	1	511	1	0	0	0	0	0	0	caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049...	2024-08-09 15:30:57.171456	2024-08-09 15:33:20.325410

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.