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

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.0853 seconds.)

SELECT * FROM `x$statements_with_runtimes_in_95th_percentile`

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	rows_sent	rows_sent_avg	rows_examined	rows_examined_avg	first_seen	last_seen	digest
DROP SCHEMA `sakila`	NULL		1	0	0	1351044723000	1351044723000	1351044723000	0	0	0	0	2024-06-26 03:01:31.279308	2024-06-26 03:01:31.279308	a2587d785e1d8a8fd35a0bd14178b03ec5347fc6801413c03b...
SELECT COUNT ( * ) FROM `sakila` . `staff`	NULL		1	0	0	604136019000	604136019000	604136019000	1	1	0	0	2024-06-26 03:01:09.924410	2024-06-26 03:01:09.924410	039c3c9b7bc9053dd54f81507e8548926594435de82b98e8ff...
DROP SCHEMA `pw`	NULL		1	0	0	338712030000	338712030000	338712030000	0	0	0	0	2024-06-26 03:01:29.927459	2024-06-26 03:01:29.927459	62c6819ee406df918818d4fc3bd15e771f545e0e04e73eb406...
CREATE TABLE `DB Transfortasi` . `pengguna` ( `ID ...	DB Transfortasi		1	0	0	233981373000	233981373000	233981373000	0	0	0	0	2024-06-26 03:11:03.529162	2024-06-26 03:11:03.529162	b02a6949ee300cdc018e9ecf8459f4be4e1705380a84bc8039...
CREATE TABLE `REFACCIONARIA` . `CLIENTES` ( `NOMBR...	REFACCIONARIA		1	0	1	189136955000	189136955000	189136955000	0	0	0	0	2024-06-26 03:08:09.652706	2024-06-26 03:08:09.652706	1bd5aa90652b004bcb35db7edf2d5cd3f27292708702b49374...
CREATE TABLE `REFACCIONARIA` . `EMPLEADO` ( `MATRI...	REFACCIONARIA		1	0	1	185519803000	185519803000	185519803000	0	0	0	0	2024-06-26 03:09:31.992734	2024-06-26 03:09:31.992734	24ae0b8722ac3edc7e4dbe25a0fd169cd2be24f68cab264379...
CREATE TABLE `REFACCIONARIA` . `DISTRIBUIDOR` ( `N...	REFACCIONARIA		1	0	1	176815927000	176815927000	176815927000	0	0	0	0	2024-06-26 03:10:24.733915	2024-06-26 03:10:24.733915	27e653be2466521bde1a5bc4f2d0f08bffc56a5c7cce288c7b...
DROP SCHEMA `hola`	NULL		1	0	0	173801139000	173801139000	173801139000	0	0	0	0	2024-06-26 03:09:53.513001	2024-06-26 03:09:53.513001	bb1106f11c798a13b68b6321bf747ba9cac16eb12764b718ec...
CREATE TABLE `hola` . `Estudiantes` ( `Nombre` VAR...	hola		1	0	0	173372708000	173372708000	173372708000	0	0	0	0	2024-06-26 03:02:13.959867	2024-06-26 03:02:13.959867	8f594f18848dfebd1bc99337fb996df6375c59f322864e75a0...
CREATE TABLE `REFACCIONARIA` . `PRODUCTO` ( `ID_PR...	REFACCIONARIA		1	0	2	171789002000	171789002000	171789002000	0	0	0	0	2024-06-26 03:10:47.756665	2024-06-26 03:10:47.756665	c97e831a5e25da871a0009ec5288b782ca50208f79b8a55328...
CREATE TABLE `holaprueba` . `estudiantes` ( `nombr...	holaprueba		1	0	0	170043870000	170043870000	170043870000	0	0	0	0	2024-06-26 03:10:33.006194	2024-06-26 03:10:33.006194	4c13cd4ad20f74761b90bbe991403474508d8bee4d7d39b6e5...
DROP SCHEMA `PRUEBA`	NULL		1	0	0	145248071000	145248071000	145248071000	0	0	0	0	2024-06-26 03:01:29.588445	2024-06-26 03:01:29.588445	1c20b69cfc367eb3d403d4196e1bd3ecb85468f1901cb54b9c...
SELECT `sys` . `format_statement` ( `performance_s...	sys	*	6	0	0	621256065000	612102067000	103542677000	52	9	1834	306	2024-06-26 03:02:15.248138	2024-06-26 03:06:32.506542	5dedbc181166dbc1f2ceb4aab65601b32e171682a23591851c...
INSERT INTO `Estudiantes` ( `Nombre` , `Apellido` ...	hola		1	0	0	103390802000	103390802000	103390802000	0	0	0	0	2024-06-26 03:02:30.397931	2024-06-26 03:02:30.397931	cfc86855983a50e322a029d827269eb3ec35a0f8ee3f5cdb8c...
DROP SCHEMA `Portfolio_Marcus`	NULL		1	0	0	60477653000	60477653000	60477653000	0	0	0	0	2024-06-26 03:01:29.442303	2024-06-26 03:01:29.442303	1190805206328a8f160690b8063b933080bb0cce1bbaf86501...
CREATE SCHEMA `holaprueba`	NULL		1	0	0	57897254000	57897254000	57897254000	0	0	0	0	2024-06-26 03:10:05.008519	2024-06-26 03:10:05.008519	866d82b016995bb8c7d6c014158424eee15f23e1fc8cc87c3c...
CREATE SCHEMA `DB Transfortasi` DEFAULT CHARSET = ...	NULL		1	0	0	56841272000	56841272000	56841272000	0	0	0	0	2024-06-26 03:09:06.026655	2024-06-26 03:09:06.026655	31698de54e35724a9395a944d68a418630bef85aca8d46af83...
CREATE SCHEMA `hola`	NULL		1	0	0	44618650000	44618650000	44618650000	0	0	0	0	2024-06-26 03:01:41.235506	2024-06-26 03:01:41.235506	ed9e6fb8721a1607949da60ff63e1ea28d72edbb6b56a6de2d...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	vedettfak		3	0	0	75335913000	46443284000	25111971000	4	1	50	17	2024-06-26 03:01:07.090520	2024-06-26 03:01:07.159163	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
CREATE SCHEMA `REFACCIONARIA` DEFAULT CHARSET = `u...	NULL		2	1	0	50030306000	49910551000	25015153000	0	0	0	0	2024-06-26 03:07:39.833529	2024-06-26 03:09:02.402641	2df4b077032b2c58e63c30407d16e41c158a7855e307247f65...
INSERT INTO `estudiantes` ( `nombre` , `apellido` ...	holaprueba		1	0	0	22446136000	22446136000	22446136000	0	0	0	0	2024-06-26 03:10:49.122398	2024-06-26 03:10:49.122398	14368f6a327620c8d6cc109c00d0bb8c5d21c0f6026d3762f0...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sku		7	0	0	156674518000	80267360000	22382074000	15	2	151	22	2024-06-26 03:01:04.949493	2024-06-26 03:09:09.402731	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	test19		1	0	0	20634567000	20634567000	20634567000	1	1	14	14	2024-06-26 03:10:04.186352	2024-06-26 03:10:04.186352	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	sys	*	15	0	0	277554610000	39771040000	18503640000	130	9	130	9	2024-06-26 03:02:25.744264	2024-06-26 03:10:40.153884	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	DB Transfortasi		2	0	0	31498079000	30963153000	15749039000	2	1	7	4	2024-06-26 03:11:04.011208	2024-06-26 03:11:04.012037	251552b68e8f44795ca803316d221e604ec58591e3d9d3654e...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!