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.1540 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
ALTER TABLE `RentalPoints` MODIFY `RentalPointID` ...	klo		1	0	1	536045462000	536045462000	536045462000	0	0	0	0	2024-06-25 09:05:16.180546	2024-06-25 09:05:16.180546	39b56f03fe5456be5d530a386cd95bcd1a0115907225290ef3...
ALTER TABLE `Rentals` ADD PRIMARY KEY ( `RentalID`...	klo		1	0	0	528514119000	528514119000	528514119000	0	0	0	0	2024-06-25 09:05:14.822385	2024-06-25 09:05:14.822385	eb90c809beeecea410ca28869043ac88ca45bd81f8ee1fb7c8...
ALTER TABLE `Vehicles` MODIFY `VehicleID` INTEGER ...	klo		1	0	1	490363120000	490363120000	490363120000	0	0	0	0	2024-06-25 09:05:17.121759	2024-06-25 09:05:17.121759	2c7f8dd40d320b27fd03e5feefdb4d311a88ed00523aa06d46...
ALTER TABLE `tasks` ADD PRIMARY KEY ( `id` )	todo_db		1	0	0	448631297000	448631297000	448631297000	0	0	0	0	2024-06-25 09:07:57.567361	2024-06-25 09:07:57.567361	9f06ddb73da38715ea5ec8f0979f0ed2677f3d9c75002737ac...
ALTER TABLE `RentalPoints` ADD PRIMARY KEY ( `Rent...	klo		1	0	0	447487374000	447487374000	447487374000	0	0	0	0	2024-06-25 09:05:14.276380	2024-06-25 09:05:14.276380	3f8bab3b8c2f960fe706493993d86593ca6c7a5bb9c43a4cd8...
ALTER TABLE `Parks` ADD PRIMARY KEY ( `ParkID` )	klo		1	0	0	434037416000	434037416000	434037416000	0	0	0	0	2024-06-25 09:05:13.820528	2024-06-25 09:05:13.820528	cdad32ee652719aa0fd50385be95a40a96d5299a582570d440...
ALTER TABLE `Rentals` MODIFY `RentalID` INTEGER (?...	klo		1	0	1	426245236000	426245236000	426245236000	0	0	0	0	2024-06-25 09:05:16.612718	2024-06-25 09:05:16.612718	fa096e2d18c8dd33ed4b7bff3d9230124832394ef452267df3...
ALTER TABLE `Vehicles` ADD PRIMARY KEY ( `VehicleI...	klo		1	0	0	422931498000	422931498000	422931498000	0	0	0	0	2024-06-25 09:05:15.250079	2024-06-25 09:05:15.250079	e03a550556b34857110ec0c7d50cce33c342f62eae71c0ee12...
CREATE TABLE `Vehicles` ( `VehicleID` INTEGER (?) ...	klo		1	0	2	410014977000	410014977000	410014977000	0	0	0	0	2024-06-25 09:05:13.319475	2024-06-25 09:05:13.319475	d075b5aa9b485838fcee49f048d3cfa5ed2c45d15500b91379...
ALTER TABLE `Parks` MODIFY `ParkID` INTEGER (?) NO...	klo		1	0	1	344521680000	344521680000	344521680000	0	0	0	0	2024-06-25 09:05:15.613272	2024-06-25 09:05:15.613272	2366b7d21cf14746c5a2678003488c0ac58664b84fcb6653e8...
ALTER TABLE `tasks` MODIFY `id` INTEGER (?) NOT NU...	todo_db		2	1	1	445452056000	442717131000	222726028000	0	0	0	0	2024-06-25 09:03:33.827000	2024-06-25 09:08:58.923578	ccde6ad77e6effb18b13cab5700133e31015767d395631cf94...
CREATE TABLE `register` . `index.php` ( `id` INTEG...	register		1	0	0	220016483000	220016483000	220016483000	0	0	0	0	2024-06-25 09:10:27.148485	2024-06-25 09:10:27.148485	8212f0f9e1fe869c27dc9dc85d0d5112ed3ada016ec9750f50...
CREATE TABLE `Rentals` ( `RentalID` INTEGER (?) NO...	klo		1	0	2	201288194000	201288194000	201288194000	0	0	0	0	2024-06-25 09:05:12.824449	2024-06-25 09:05:12.824449	09dde2e2bac977811c7baa85b7c77a0a105482a2c7af30fd3a...
CREATE TABLE `Parks` ( `ParkID` INTEGER (?) NOT NU...	klo		1	0	1	189136753000	189136753000	189136753000	0	0	0	0	2024-06-25 09:05:12.321071	2024-06-25 09:05:12.321071	fa15a9c152915960f42dafad1a47089839046dd39fb84d3252...
CREATE TABLE `RentalPoints` ( `RentalPointID` INTE...	klo		1	0	2	170704095000	170704095000	170704095000	0	0	0	0	2024-06-25 09:05:12.545823	2024-06-25 09:05:12.545823	a546dab08310aece5d2b8febe9e97613454827306873c0faad...
CREATE TABLE `tasks` ( `id` INTEGER (?) NOT NULL ,...	todo_db		2	1	1	228034209000	227885370000	114017104000	0	0	0	0	2024-06-25 09:02:44.439127	2024-06-25 09:07:25.394345	35c21bd38478cb296b5b53ebfe5c0fc345a550c99d7c6a70be...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	sys		2	0	0	176023885000	172984697000	88011942000	2	1	1726	863	2024-06-25 09:03:00.450947	2024-06-25 09:03:00.552413	ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan...	sys	*	9	0	0	580483341000	150954771000	64498149000	78	9	26410	2934	2024-06-25 09:03:06.782843	2024-06-25 09:13:21.141851	92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc...
CREATE PROCEDURE `ShowCurrentUserPrivileges` ( ) B...	klo		1	0	0	62343429000	62343429000	62343429000	0	0	0	0	2024-06-25 09:11:39.459696	2024-06-25 09:11:39.459696	b606db8b6b0c9c76d3fa7f72d6186ea1c66baea22e7b132150...
INSERT INTO `Rentals` ( `RentalID` , `VehicleID` ,...	klo		1	0	0	59364366000	59364366000	59364366000	0	0	0	0	2024-06-25 09:05:12.889153	2024-06-25 09:05:12.889153	476d1647829842363863bb4b3649a5ef6c17c37100267b6659...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` ....	information_schema	*	23	0	0	1352112976000	296367688000	58787520000	184	8	7238	315	2024-06-25 09:01:27.704427	2024-06-25 09:09:54.592176	251552b68e8f44795ca803316d221e604ec58591e3d9d3654e...
CREATE SCHEMA `bomb` DEFAULT CHARSET = `utf8mb4` C...	NULL		1	0	0	58106977000	58106977000	58106977000	0	0	0	0	2024-06-25 09:04:06.966012	2024-06-25 09:04:06.966012	7c5cf9e5f12596ddafd68f4343b35a6fb6d928d6fb03b6a040...
CREATE SCHEMA `todo_db` DEFAULT CHARSET = `utf8mb4...	NULL		1	0	0	54055940000	54055940000	54055940000	0	0	0	0	2024-06-25 09:01:56.675579	2024-06-25 09:01:56.675579	b6fb2f38c2cde96bc3796e9cb4c2e367080a2ce810e7f928a1...
SELECT COUNT ( * ) FROM ( SELECT ? FROM `actor` , ...	sakila	*	1	0	0	53281451000	53281451000	53281451000	1	1	803	803	2024-06-25 09:13:54.763943	2024-06-25 09:13:54.763943	e0fcd6a389b32c353f82a09dea0a4818fff884421ed63f2a7f...
ALTER TABLE `RentalPoints` ADD CONSTRAINT `RentalP...	klo		1	0	0	52975395000	52975395000	52975395000	0	0	0	0	2024-06-25 09:05:17.192871	2024-06-25 09:05:17.192871	ccc21d989b22158cef20f36061052b4ad0a1479b18507ca5d0...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!