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.1177 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
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir...	NULL	*	1	0	0	278181396000	278181396000	278181396000	1	1	322799	322799	2024-06-16 00:17:57.119309	2024-06-16 00:17:57.119309	91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6...
CREATE TABLE `Gehege` ( `GehegeID` INTEGER AUTO_IN...	zoo		1	0	0	276242070000	276242070000	276242070000	0	0	0	0	2024-06-16 00:18:17.169803	2024-06-16 00:18:17.169803	f1271279fe6990296d7ce9402a7616555870fbc31a63d5ba2f...
CREATE TABLE `Tier` ( `TierID` INTEGER AUTO_INCREM...	zoo		1	0	0	211008415000	211008415000	211008415000	0	0	0	0	2024-06-16 00:18:16.888778	2024-06-16 00:18:16.888778	a5ccffe4646c6f5eb00ac0529c5e587e81e5e9c9b7495a3760...
CREATE TABLE `trabajofinal` . `Starbucks` ( `ID` I...	trabajofinal		1	0	0	203759258000	203759258000	203759258000	0	0	0	0	2024-06-16 00:26:56.419761	2024-06-16 00:26:56.419761	3e9f2621e5be587214c42ab2c0ed16c08c9fa6c5e74e604461...
CREATE TABLE `Art` ( `ArtID` INTEGER AUTO_INCREMEN...	zoo		1	0	0	191522792000	191522792000	191522792000	0	0	0	0	2024-06-16 00:18:16.663009	2024-06-16 00:18:16.663009	05deed0956214879889173e1882faa68b747b71d5d88991d40...
SELECT ? FROM `information_schema` . `INNODB_COLUM...	information_schema	*	2	0	0	295719429000	154250803000	147859714000	2	1	2	1	2024-06-16 00:19:06.706193	2024-06-16 00:19:06.933592	548c02dda47c1454923b30fc7f703a1ebf478276c85df39cd2...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	2	0	1	282214468000	242381054000	141107234000	2	1	2	1	2024-06-16 00:16:50.368819	2024-06-16 00:16:50.516912	ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	38	0	6	3961134182000	1210451135000	104240373000	54	1	250669	6597	2024-06-16 00:15:56.601341	2024-06-16 00:25:53.115150	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...
CREATE SCHEMA `zoo` CHARACTER SET `utf8` COLLATE `...	NULL		1	0	2	70874069000	70874069000	70874069000	0	0	0	0	2024-06-16 00:17:55.572382	2024-06-16 00:17:55.572382	f2978dae182d11065c3c50e115a9c4c17dddfd65c7b6616c71...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	2	0	1	132773635000	110477176000	66386817000	2	1	2	1	2024-06-16 00:16:50.630966	2024-06-16 00:16:50.758687	aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1...
CREATE SCHEMA `trabajofinal` DEFAULT CHARSET = `ut...	NULL		1	0	0	57744037000	57744037000	57744037000	0	0	0	0	2024-06-16 00:20:31.541244	2024-06-16 00:20:31.541244	605ce0c4c35164d8147d5bc41a6e7cade79a6a52c48f2f1055...
INSERT INTO `Art` ( `Bezeichnung` ) VALUES (?) /* ...	zoo		1	0	0	57618171000	57618171000	57618171000	0	0	0	0	2024-06-16 00:18:36.006054	2024-06-16 00:18:36.006054	0fd0fe2c4d1808afa03fed841ba6d3af35b758c3a6e4334588...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	Table_insertion		1	0	0	52484187000	52484187000	52484187000	3	3	22	22	2024-06-16 00:19:18.150591	2024-06-16 00:19:18.150591	e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan...	sys	*	49	0	0	2509503852000	143125677000	51214364000	230	5	110984	2265	2024-06-16 00:21:45.759124	2024-06-16 00:24:13.633829	92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc...
INSERT INTO `Tier` ( NAME , `Geburtsdatum` , `ArtI...	zoo		2	0	0	99342484000	54442570000	49671242000	0	0	0	0	2024-06-16 00:18:36.100943	2024-06-16 00:21:33.725471	5c4443b3e4b3f4c1ae0ac3afebc95969a34c0da49bf14e672b...
SELECT ? FROM `information_schema` . `INNODB_BUFFE...	information_schema	*	14	0	0	604233141000	179134043000	43159510000	14	1	14	1	2024-06-16 00:16:00.615097	2024-06-16 00:26:41.149422	5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76...
SELECT `c` . `name` AS `category` , SUM ( `p` . `a...	sakila	*	5	0	0	214439453000	76954652000	42887890000	4	1	4	1	2024-06-16 00:17:51.821081	2024-06-16 00:17:52.955303	a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4...
SELECT `concat` ( `c` . `city` , (_charset) ? , `c...	NULL	*	1	0	2	36626265000	36626265000	36626265000	1	1	1	1	2024-06-16 00:26:01.096635	2024-06-16 00:26:01.096635	e93a551af16493cd58cb06c9b4b21c3e15c6db7cb66f6c868e...
SELECT `performance_schema` . `table_io_waits_summ...	sys	*	15	0	0	533774788000	519378402000	35584985000	6	0	2710	181	2024-06-16 00:15:57.878486	2024-06-16 00:25:41.978935	85e73222c5b6ead740322aee783a03906c3cd237187f3b6f6b...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	7	0	0	244310568000	86742674000	34901509000	6	1	6	1	2024-06-16 00:17:15.682381	2024-06-16 00:25:55.882371	c552f840b97cf2c164de85ef343eae0b410364ed59846f9192...
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `...	NULL	*	1	0	0	29133980000	29133980000	29133980000	1	1	1	1	2024-06-16 00:18:09.425443	2024-06-16 00:18:09.425443	2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...
INSERT INTO `Gehege` ( `Bezeichnung` , `TierID` ) ...	zoo		1	0	0	28728831000	28728831000	28728831000	0	0	0	0	2024-06-16 00:18:36.147947	2024-06-16 00:18:36.147947	7e13e90470d69ce285239bdd1cd48ced59bfc6c23085ab7242...
SELECT * FROM `INNODB_TABLES` LIMIT ?, ... (unknow...	information_schema	*	1	0	0	28674176000	28674176000	28674176000	25	25	25	25	2024-06-16 00:16:49.711953	2024-06-16 00:16:49.711953	930d4e73ee6a8d446ee882bf4faa2cae7171cc914aacebd0d6...
SELECT `extract_schema_from_file_name` ( `performa...	NULL	*	1	0	1	27188854000	27188854000	27188854000	1	1	1	1	2024-06-16 00:17:08.879632	2024-06-16 00:17:08.879632	bd914fd84f93d2b27f3871dfcd403dfa26335a4f26eda232ed...
SELECT `mt` . `THREAD_ID` AS `thread_id` , IF ( ( ...	sys	*	15	0	6	404515367000	44908851000	26967691000	12	1	12	1	2024-06-16 00:15:56.240876	2024-06-16 00:25:38.880132	842d82531694141e52c01891300ae7148cdbee8aa87a39eb0b...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!