demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sys / 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 `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 `opportunities` MO ... ` INT8 NOT NULL...	crm_data		1	0	0	1.09 s	1.09 s	1.09 s	0	0	0	0	2026-03-31 04:49:12.442797	2026-03-31 04:49:12.442797	a3a91cf7bd81193b8a6660f28e289272cdcf6db086e033dc63...
ALTER TABLE `contacts` ADD PRI ... _contacts_activ...	crm_data		1	0	0	1.05 s	1.05 s	1.05 s	0	0	0	0	2026-03-31 04:49:01.158129	2026-03-31 04:49:01.158129	4d3228cbf5647cecfba38c6ddf5fd8d6c995169ff0d237f7d5...
ALTER TABLE `opportunities` AD ... dx_opp_is_activ...	crm_data		1	0	0	903.42 ms	903.42 ms	903.42 ms	0	0	0	0	2026-03-31 04:49:04.490758	2026-03-31 04:49:04.490758	f0950c22bf9ebfb3036a3548d50b569c53c6bdc846412ba632...
ALTER TABLE `opportunities` AD ... CES `pipeline_s...	crm_data		1	0	0	801.90 ms	801.90 ms	801.90 ms	0	0	0	0	2026-03-31 04:49:19.433127	2026-03-31 04:49:19.433127	08745e15d821c1931c7a16da49cddae417ee750f14f5cf06d0...
ALTER TABLE `leads` ADD PRIMAR ... x_leads_team_id...	crm_data		1	0	0	757.11 ms	757.11 ms	757.11 ms	0	0	0	0	2026-03-31 04:49:02.817088	2026-03-31 04:49:02.817088	9d5d125432f24ea58dae98a1fa9b1e640169143596f8b01cbf...
ALTER TABLE `contacts` ADD CON ... s` ( `id` ) ON ...	crm_data		1	0	0	751.36 ms	751.36 ms	751.36 ms	0	0	0	0	2026-03-31 04:49:16.826898	2026-03-31 04:49:16.826898	1fc738ca47616c4622d9b2b3b119c7c98b5237d7493dd9bda6...
ALTER TABLE `contacts` MODIFY ... INCREMENT , AUT...	crm_data		1	0	0	746.49 ms	746.49 ms	746.49 ms	0	0	0	0	2026-03-31 04:49:09.792089	2026-03-31 04:49:09.792089	70064176e683c3772d409a657c4daa5fe69ba7df670caed42c...
ALTER TABLE `leads` ADD CONSTR ... ) REFERENCES `...	crm_data		1	0	0	738.86 ms	738.86 ms	738.86 ms	0	0	0	0	2026-03-31 04:49:18.167230	2026-03-31 04:49:18.167230	75b0d05918d857e7befa94fff007a6b76d1cb7384bf5c991d7...
ALTER TABLE `activities` ADD C ... ENCES `opportun...	crm_data		1	0	0	675.71 ms	675.71 ms	675.71 ms	0	0	0	0	2026-03-31 04:49:16.074268	2026-03-31 04:49:16.074268	78a26299ab07060f522a4caeeb1532a460330e4008d9dcba25...
ALTER TABLE `activities` MODIF ... ` INT8 NOT NULL...	crm_data		1	0	0	663.16 ms	663.16 ms	663.16 ms	0	0	0	0	2026-03-31 04:49:09.045308	2026-03-31 04:49:09.045308	8082edeaa1ac7e1054c861a82aa530951b86b75dbf948117af...
ALTER TABLE `users` ADD CONSTR ... ERENCES `sales_...	crm_data		1	0	0	659.84 ms	659.84 ms	659.84 ms	0	0	0	0	2026-03-31 04:49:22.108107	2026-03-31 04:49:22.108107	795afdd7b38625e72d8a2b3186f89aed42ec4780fb7fe50309...
ALTER TABLE `leads` MODIFY `id ... INCREMENT , AUT...	crm_data		1	0	0	656.23 ms	656.23 ms	656.23 ms	0	0	0	0	2026-03-31 04:49:11.003316	2026-03-31 04:49:11.003316	485842c7f4da8be82f9ab8c3934fcd2045be757d2616e1e403...
ALTER TABLE `refresh_tokens` A ... kens_expiry` ( ...	crm_data		1	0	0	637.88 ms	637.88 ms	637.88 ms	0	0	0	0	2026-03-31 04:49:06.349206	2026-03-31 04:49:06.349206	833f476220e7d8794b46c2ba7974723e35332e2eb32153e314...
ALTER TABLE `refresh_tokens` M ... INCREMENT , AUT...	crm_data		1	0	0	615.09 ms	615.09 ms	615.09 ms	0	0	0	0	2026-03-31 04:49:13.508664	2026-03-31 04:49:13.508664	ddea39f2d820f7fa1a96a70509e1fe7fa339fbb2b54b0e334e...
ALTER TABLE `email_logs` ADD C ... ) REFERENCES `...	crm_data		1	0	0	600.10 ms	600.10 ms	600.10 ms	0	0	0	0	2026-03-31 04:49:17.427421	2026-03-31 04:49:17.427421	145c528e99d345706c332423dcb5bc9ddd31b3dd5f588c525c...
ALTER TABLE `users` ADD PRIMAR ... `idx_users_team...	crm_data		1	0	0	582.32 ms	582.32 ms	582.32 ms	0	0	0	0	2026-03-31 04:49:08.381258	2026-03-31 04:49:08.381258	a3724bd7e0e9a6e63deb1033c4061f97830ceaa0d844e543c7...
ALTER TABLE `refresh_tokens` A ... rs` ( `id` ) ON...	crm_data		1	0	0	570.36 ms	570.36 ms	570.36 ms	0	0	0	0	2026-03-31 04:49:20.942764	2026-03-31 04:49:20.942764	43b0f82d21bb6bf2d3acc76bb98dabbe07d2d39283c247b53a...
ALTER TABLE `roles` ADD PRIMAR ... D UNIQUE KEY `n...	crm_data		1	0	0	567.49 ms	567.49 ms	567.49 ms	0	0	0	0	2026-03-31 04:49:07.268083	2026-03-31 04:49:07.268083	468d7de79edbc959711e8ee2833bd41ca5b76c26484e7bd3b7...
ALTER TABLE `email_logs` MODIF ... ` INT8 NOT NULL...	crm_data		1	0	0	552.54 ms	552.54 ms	552.54 ms	0	0	0	0	2026-03-31 04:49:10.345694	2026-03-31 04:49:10.345694	113b87c1b686d34f1c5566b13e7b7f8a01d003f0e5d8fcfee7...
ALTER TABLE `activities` ADD P ... ivities_is_done...	crm_data		1	0	0	549.18 ms	549.18 ms	549.18 ms	0	0	0	0	2026-03-31 04:49:00.103076	2026-03-31 04:49:00.103076	0501e3ecdf09f63d687d4856e4eaf3b550b6c8cae4bb862503...
ALTER TABLE `users` MODIFY `id ... INCREMENT , AUT...	crm_data		1	0	0	542.73 ms	542.73 ms	542.73 ms	0	0	0	0	2026-03-31 04:49:15.396004	2026-03-31 04:49:15.396004	a02550c59aed5da3ccf5deeb3e91ff7fb026ccef1af0d934f4...
ALTER TABLE `sales_teams` ADD ... _teams_leader` ...	crm_data		1	0	0	529.96 ms	529.96 ms	529.96 ms	0	0	0	0	2026-03-31 04:49:07.798348	2026-03-31 04:49:07.798348	8bf2e155bf67db842932306e10f7e4e1dee4ecbc220d216584...
ALTER TABLE `sales_teams` ADD ... ) REFERENCES `...	crm_data		1	0	0	504.59 ms	504.59 ms	504.59 ms	0	0	0	0	2026-03-31 04:49:21.447679	2026-03-31 04:49:21.447679	204bfd8d19d0047810afb94cdba91e5e840e014203393e8b07...
ALTER TABLE `opportunities_aud ... REFERENCES `rev...	crm_data		1	0	0	500.28 ms	500.28 ms	500.28 ms	0	0	0	0	2026-03-31 04:49:19.935059	2026-03-31 04:49:19.935059	90ce6abf19f03d289e4b99adfe263e2b10ae52de6cd858eb42...
CREATE TABLE `flyway_schema_hi ... COLLATE = `utf8...	crm_data		1	0	1	498.99 ms	498.99 ms	498.99 ms	0	0	0	0	2026-03-31 04:48:56.935611	2026-03-31 04:48:56.935611	d7dadd5ff408b2b63f4c1c176d609bfce7e936f671d8d45216...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-5377-g8e721911f0 from the master branch.