demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sys / x$statement_analysis

New
Banco
cbtis190
haker
information
- information
- information_schema
login_register_db
mysite1
mysql
performance_schema
Portfolio_Marcus
PRUEBA
pw
sakila
serveruwebcoBressolia
shoe_db
Sistema_Matricula
sklepSerohenko
sku
StdMdDB
Stefano
students
students 2020
superpos
sys
table
Table_insertion
tb
test19
teste_teste
TlapaleriaMalfoy
Trickysolo
vedettfak
victory 2020
wisedb
world
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ
аа

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		7220	0	0	2226482505000	6638448000	308377000	1200543000000	7208	1	43287	6	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-09-24 20:58:39.813130	2024-09-24 20:58:46.976048
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	6	0	1	295731243000	85523613000	49288540000	3002000000	36	6	89	15	0	0	16	0	404	0	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...	2024-09-24 20:58:39.811846	2024-09-24 20:58:47.050026
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	6	0	0	297717665000	150054997000	49619610000	1433000000	52	9	36496	6083	0	0	34	4	1798	4	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2024-09-24 20:58:41.721344	2024-09-24 20:58:47.077452
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` ....	information_schema	*	106	0	0	160621094000	5477819000	1515293000	18745000000	274	3	4497	42	0	0	103	0	0	0	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...	2024-09-24 20:58:41.090564	2024-09-24 20:58:47.116392
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	3	0	1	145422987000	121013993000	48474329000	4267000000	26	9	26	9	0	0	9	2	749	2	aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1...	2024-09-24 20:58:43.925027	2024-09-24 20:58:44.261933
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	information_schema	*	190	0	0	95400306000	4824804000	502106000	41158000000	1149	6	7069	37	0	0	192	0	1789	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-09-24 20:58:40.164681	2024-09-24 20:58:47.113277
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	performance_schema	*	104	0	0	88274799000	14857950000	848796000	25111000000	1040	10	7098	68	0	0	234	0	1898	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-09-24 20:58:39.949812	2024-09-24 20:58:46.909379
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	89	0	0	78479648000	17676841000	881793000	40820000000	26	0	1199	13	0	0	86	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-09-24 20:58:40.083189	2024-09-24 20:58:47.078148
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		52	0	0	72802066000	5306072000	1400039000	25789000000	3004	58	15176	292	0	0	52	0	3004	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-09-24 20:58:39.776591	2024-09-24 20:58:46.726271
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	mysql	*	94	0	0	68139200000	3154507000	724885000	21263000000	1174	12	6998	74	0	0	194	0	1754	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-09-24 20:58:39.804682	2024-09-24 20:58:47.042169
SHOW SESSION VARIABLES LIKE ?	sys	*	15	0	0	66419920000	46361495000	4427994000	1462000000	15	1	8610	574	0	0	15	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-09-24 20:58:39.740634	2024-09-24 20:58:47.066065
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema		85	0	0	65892227000	2496369000	775202000	33008000000	1205	14	5680	67	0	0	41	0	905	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-09-24 20:58:40.082543	2024-09-24 20:58:47.077244
SHOW SESSION VARIABLES LIKE ?	performance_schema	*	52	0	0	57835036000	3961851000	1112212000	5495000000	52	1	29848	574	0	0	52	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-09-24 20:58:39.759081	2024-09-24 20:58:46.887101
SHOW SESSION VARIABLES LIKE ?	information_schema	*	45	0	0	53971001000	5497822000	1199355000	5011000000	45	1	25830	574	0	0	45	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2024-09-24 20:58:40.076742	2024-09-24 20:58:47.023863
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		48	0	0	52394093000	3753462000	1091543000	21280000000	1280	27	6552	137	0	0	40	0	1240	0	52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...	2024-09-24 20:58:39.760122	2024-09-24 20:58:46.881116
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema	*	26	0	0	46573325000	10158243000	1791281000	13744000000	26	1	10790	415	0	0	26	0	26	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-09-24 20:58:39.774082	2024-09-24 20:58:46.714887
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co...	information_schema		145	0	0	34331863000	4775706000	236771000	20532000000	145	1	145	1	0	0	0	0	0	0	878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78...	2024-09-24 20:58:41.086069	2024-09-24 20:58:47.117271
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql	*	20	0	0	30094083000	3149232000	1504704000	10587000000	20	1	8351	418	0	0	20	0	20	0	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...	2024-09-24 20:58:39.871621	2024-09-24 20:58:46.879800
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` ....	information_schema	*	5	0	0	27743090000	20542399000	5548618000	1509000000	51	10	399	80	0	0	0	0	0	0	7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...	2024-09-24 20:58:41.948992	2024-09-24 20:58:47.051493
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ...	sys	*	32	0	0	25821000000	2486831000	806906000	9007000000	320	10	2264	71	0	0	72	0	584	0	db22765f86fdb091d2faced7479895f8497b40140b15fad577...	2024-09-24 20:58:39.913218	2024-09-24 20:58:46.944776
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	performance_schema		55	0	0	25709924000	1610265000	467453000	14953000000	0	0	165	3	0	0	0	0	0	0	4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650...	2024-09-24 20:58:39.763636	2024-09-24 20:58:46.715807
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		32	0	0	25689895000	5197125000	802809000	17825000000	0	0	96	3	0	0	32	0	0	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-09-24 20:58:39.815353	2024-09-24 20:58:46.353065
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	mysql		32	0	0	25025034000	2088290000	782032000	12417000000	53	2	1067	33	0	0	32	0	53	0	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...	2024-09-24 20:58:39.762440	2024-09-24 20:58:46.850413
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ...	performance_schema	*	26	0	0	24636918000	5595953000	947573000	5928000000	26	1	104	4	0	0	182	0	0	0	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...	2024-09-24 20:58:40.002875	2024-09-24 20:58:46.931970
SELECT `internal_tablespace_id` ( `ts` . `name` , ...	information_schema	*	21	0	0	21882768000	6151741000	1042036000	4997000000	182	9	364	17	0	0	0	0	0	0	56ebc6e21608c16d20579b17eca3668ef7bae51b1c1cdd8a06...	2024-09-24 20:58:40.080690	2024-09-24 20:58:44.964421

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4907-g5b04607256 from the master branch.