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.

Your SQL query has been executed successfully.

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	949045589000	949045589000	949045589000	0	0	0	0	2024-09-26 19:39:31.599007	2024-09-26 19:39:31.599007	a2587d785e1d8a8fd35a0bd14178b03ec5347fc6801413c03b...
DROP SCHEMA `shopping`	NULL		1	0	0	602590070000	602590070000	602590070000	0	0	0	0	2024-09-26 19:39:32.344719	2024-09-26 19:39:32.344719	fd2474d53e96494dbe4a210283269005d87e973492b5ef0134...
ALTER TABLE `permiso` ADD PRIMARY KEY ( `IDPermiso...	base_de_datos		1	0	0	580765964000	580765964000	580765964000	0	0	0	0	2024-09-26 19:31:59.784877	2024-09-26 19:31:59.784877	04a20d90fea0ae942adee233ae8e00f8fb87ee7491c09aaecb...
ALTER TABLE `products` ADD PRIMARY KEY ( `id` )	shopping		1	0	0	505261456000	505261456000	505261456000	0	0	0	0	2024-09-26 19:33:03.800686	2024-09-26 19:33:03.800686	f34a30dade67310a35e49d96ca34c70b039c9cf57a087eb827...
ALTER TABLE `users` ADD PRIMARY KEY ( `id` )	shopping		1	0	0	501169977000	501169977000	501169977000	0	0	0	0	2024-09-26 19:33:05.274307	2024-09-26 19:33:05.274307	f21a5e78bb24e63c5ddb054f3202faf41a286581d246c29d11...
ALTER TABLE `orders` ADD PRIMARY KEY ( `id` )	shopping		1	0	0	500381699000	500381699000	500381699000	0	0	0	0	2024-09-26 19:33:02.473097	2024-09-26 19:33:02.473097	6c13866f167d79d3b2e738fd95f33a68233f7e9dd1564de242...
ALTER TABLE `category` MODIFY `id` INTEGER (?) NOT...	shopping		1	0	1	495172325000	495172325000	495172325000	0	0	0	0	2024-09-26 19:33:06.584236	2024-09-26 19:33:06.584236	3727344d3b3e0edc523f045bb62a5f53bbbf3209f3cd67b26e...
ALTER TABLE `userlog` ADD PRIMARY KEY ( `id` )	shopping		1	0	0	478277934000	478277934000	478277934000	0	0	0	0	2024-09-26 19:33:04.758588	2024-09-26 19:33:04.758588	0a52618f70cc4cdecae460278aadd7a925374289d50e30621d...
ALTER TABLE `admin` ADD PRIMARY KEY ( `id` )	shopping		1	0	0	475592984000	475592984000	475592984000	0	0	0	0	2024-09-26 19:33:01.538289	2024-09-26 19:33:01.538289	cdbc34d7b2b0f018a54ba5ef49478729272bcac56c75bbff5f...
ALTER TABLE `users` MODIFY `id` INTEGER (?) NOT NU...	shopping		1	0	1	469721800000	469721800000	469721800000	0	0	0	0	2024-09-26 19:33:09.482198	2024-09-26 19:33:09.482198	bebc84a47c9fa15632e20c3c7e606ec7bc8e36181573541fbb...
DROP SCHEMA `test19`	NULL		1	0	0	466531140000	466531140000	466531140000	0	0	0	0	2024-09-26 19:39:34.672250	2024-09-26 19:39:34.672250	a01611328ecd424f215963da50458d4f805c4ad20d0a8bc374...
DROP SCHEMA `Table_insertion`	NULL		1	0	0	456218314000	456218314000	456218314000	0	0	0	0	2024-09-26 19:39:34.137710	2024-09-26 19:39:34.137710	85135b6db3b621c398bf6ff3731e8cfd947c2260e5fd26d0e2...
ALTER TABLE `subcategory` ADD PRIMARY KEY ( `id` )	shopping		1	0	0	451159587000	451159587000	451159587000	0	0	0	0	2024-09-26 19:33:04.267132	2024-09-26 19:33:04.267132	021bbb695e5aff2c9cb580e1b69611c3e77fe243fbee99ea27...
ALTER TABLE `ordertrackhistory` ADD PRIMARY KEY ( ...	shopping		1	0	0	449877805000	449877805000	449877805000	0	0	0	0	2024-09-26 19:33:02.936987	2024-09-26 19:33:02.936987	570d4c2d2a6ad4f12a8304da37ac75c57a241f53a308cfdf8d...
ALTER TABLE `admin` MODIFY `id` INTEGER (?) NOT NU...	shopping		1	0	1	429799495000	429799495000	429799495000	0	0	0	0	2024-09-26 19:33:06.084632	2024-09-26 19:33:06.084632	b8bde182da1cdd2cd2de4a09762055f8d32915cc8031f31cdc...
ALTER TABLE `category` ADD PRIMARY KEY ( `id` )	shopping		1	0	0	426016844000	426016844000	426016844000	0	0	0	0	2024-09-26 19:33:01.968401	2024-09-26 19:33:01.968401	49aa669fc92bc4a28064e6558ab2e771ebfe6bb4673ecee19d...
DROP SCHEMA `sku`	NULL		1	0	0	417673741000	417673741000	417673741000	0	0	0	0	2024-09-26 19:39:32.921978	2024-09-26 19:39:32.921978	9a11e4318a635fccf67ffd5a2fdc2bc803e13c738cc05bade3...
ALTER TABLE `subcategory` MODIFY `id` INTEGER (?) ...	shopping		1	0	1	413576331000	413576331000	413576331000	0	0	0	0	2024-09-26 19:33:08.601474	2024-09-26 19:33:08.601474	e263e8d724a74653abeb913753b317308f18a907e95fb28aa2...
ALTER TABLE `ordertrackhistory` MODIFY `id` INTEGE...	shopping		1	0	1	410407420000	410407420000	410407420000	0	0	0	0	2024-09-26 19:33:07.402651	2024-09-26 19:33:07.402651	92e0a63ae80a8053497bf3c2f7818bf021c06da2baad7d0037...
ALTER TABLE `products` MODIFY `id` INTEGER (?) NOT...	shopping		1	0	1	402904572000	402904572000	402904572000	0	0	0	0	2024-09-26 19:33:08.183659	2024-09-26 19:33:08.183659	a29318c5804aee225969d560bfc67ddf600e93530d9c9dac8d...
ALTER TABLE `wishlist` MODIFY `id` INTEGER (?) NOT...	shopping		1	0	1	401975815000	401975815000	401975815000	0	0	0	0	2024-09-26 19:33:09.889798	2024-09-26 19:33:09.889798	b73d31d12d5897a35401bbdfa154f287ba40b78d00cb170b3d...
ALTER TABLE `userlog` MODIFY `id` INTEGER (?) NOT ...	shopping		1	0	1	392102362000	392102362000	392102362000	0	0	0	0	2024-09-26 19:33:09.008187	2024-09-26 19:33:09.008187	19fa894e947f68e600fc7bae66788148c8dcd50cd175d5f248...
ALTER TABLE `orders` MODIFY `id` INTEGER (?) NOT N...	shopping		1	0	1	388814178000	388814178000	388814178000	0	0	0	0	2024-09-26 19:33:06.987161	2024-09-26 19:33:06.987161	b52f1f146622ea5148c3d21fd7dc2052c61dbabfd716151408...
CREATE TABLE `permiso` ( `id` INTEGER (?) DEFAULT ...	trucson		1	0	1	367683092000	367683092000	367683092000	0	0	0	0	2024-09-26 19:40:04.752449	2024-09-26 19:40:04.752449	ae9aeab9a79f101b69a512dc15e02a843c2ac6dc5172d72862...
ALTER TABLE `productreviews` MODIFY `id` INTEGER (...	shopping		1	0	1	358567233000	358567233000	358567233000	0	0	0	0	2024-09-26 19:33:07.776286	2024-09-26 19:33:07.776286	c84495df8086703a15b5cdd71d39aaa7e0c5d1b2257f871276...

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.