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 - 22 (23 total, Query took 0.0436 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 `estudiante` ADD FOREIGN KEY ( `idApod...	bd_colegio		1	0	0	525793862000	525793862000	525793862000	0	0	0	0	2024-06-27 16:34:35.433723	2024-06-27 16:34:35.433723	ae141296ce9df8330d1def5b49c43ac99f1e6f1dcb0a14bb81...
ALTER TABLE `registrotalleres` ADD FOREIGN KEY ( `...	bd_colegio		1	0	0	518049002000	518049002000	518049002000	0	0	0	0	2024-06-27 16:34:34.420702	2024-06-27 16:34:34.420702	5422fa062496a78a6d1602943fcc5a3afefcc0938d1f558de0...
CREATE TABLE `servicio` ( `idServicio` INTEGER NOT...	bd_colegio		1	0	0	480689055000	480689055000	480689055000	0	0	0	0	2024-06-27 16:34:32.074937	2024-06-27 16:34:32.074937	7863369727897a658af62bc5abf748374046a9165c76789dfa...
ALTER TABLE `tutoria` ADD FOREIGN KEY ( `codEstudi...	bd_colegio		1	0	0	467428534000	467428534000	467428534000	0	0	0	0	2024-06-27 16:34:34.902646	2024-06-27 16:34:34.902646	3c8ca0298006bcd4550affbfb6963ddc79a92c9de016a47b27...
ALTER TABLE `horario` ADD FOREIGN KEY ( `idServici...	bd_colegio		1	0	0	464214377000	464214377000	464214377000	0	0	0	0	2024-06-27 16:34:35.902679	2024-06-27 16:34:35.902679	8a89322bae98dfebf7f3c9521a40786aec2379b3b10092bed0...
ALTER TABLE `tutoria` ADD FOREIGN KEY ( `idDocente...	bd_colegio		1	0	0	398480183000	398480183000	398480183000	0	0	0	0	2024-06-27 16:34:33.496852	2024-06-27 16:34:33.496852	fd2355a8bdb8efce759ad41bcc2b0fd7daa32b1851f6e18d40...
ALTER TABLE `registrotalleres` ADD FOREIGN KEY ( `...	bd_colegio		1	0	0	395761130000	395761130000	395761130000	0	0	0	0	2024-06-27 16:34:33.897414	2024-06-27 16:34:33.897414	45fdeee483118faa1061e59b2dc63a3ffb33224144710b585a...
ALTER TABLE `maestros` ADD UNIQUE KEY `Correo_Maes...	bd_colegio		1	0	0	343441188000	343441188000	343441188000	0	0	0	0	2024-06-27 16:37:29.453390	2024-06-27 16:37:29.453390	e386750493700b7df6ce547773a4f1becfd80f4f4a90b7f6ca...
CREATE TABLE `apoderado` ( `idApoderado` CHARACTER...	bd_colegio		1	0	0	277208695000	277208695000	277208695000	0	0	0	0	2024-06-27 16:34:32.784847	2024-06-27 16:34:32.784847	242b7bed964cd00db90bdf3a79de1cf326ecdffdda9fcb12da...
CREATE TABLE `horario` ( `idHorario` INTEGER NOT N...	bd_colegio		1	0	0	233209375000	233209375000	233209375000	0	0	0	0	2024-06-27 16:34:33.036127	2024-06-27 16:34:33.036127	0d25da5088af64920ad99d5f19ce62a661a92f9b49c946cc67...
CREATE TABLE `docente` ( `idDocente` CHARACTER (?)...	bd_colegio		1	0	0	232394010000	232394010000	232394010000	0	0	0	0	2024-06-27 16:34:31.404024	2024-06-27 16:34:31.404024	5843f1404b67f7a6d7d03457f2f3a468a345a5b61fdc3e0de8...
CREATE TABLE `estudiante` ( `codEstudiante` CHARAC...	bd_colegio		1	0	0	197958811000	197958811000	197958811000	0	0	0	0	2024-06-27 16:34:32.490922	2024-06-27 16:34:32.490922	b38cf82c1de18adfffce84e5a342ea2a5f088133abe94dc414...
CREATE TABLE `registrotalleres` ( `idServicio` INT...	bd_colegio		1	0	0	197885928000	197885928000	197885928000	0	0	0	0	2024-06-27 16:34:32.288191	2024-06-27 16:34:32.288191	5a52e2d9a9bbc3aa0cada3ec9998e792cc82f98c7c07a2aa51...
CREATE TABLE `maestros` ( `Nombre_Maestro` VARCHAR...	bd_colegio		1	0	0	174698253000	174698253000	174698253000	0	0	0	0	2024-06-27 16:37:29.107066	2024-06-27 16:37:29.107066	d23182e9d5be30123c8844ea750b4915041f22d6c2dc5c0a1b...
CREATE TABLE `tutoria` ( `codEstudiante` CHARACTER...	bd_colegio		1	0	0	168020961000	168020961000	168020961000	0	0	0	0	2024-06-27 16:34:31.578743	2024-06-27 16:34:31.578743	4c3392d4ee3b626da84adae36bcbadc254a6216c5424653d0c...
CREATE TABLE `Test` . `ID` ( `USERNAME` VARCHARACT...	Test		1	0	0	150360145000	150360145000	150360145000	0	0	0	0	2024-06-27 16:39:47.249387	2024-06-27 16:39:47.249387	391915eb399addcd7960395d17e23f5b93a8d6bedcf2fa9e79...
CREATE TABLE `alumnos` ( `nombre` VARCHARACTER (?)...	bd_colegio		2	1	0	287975190000	287395480000	143987595000	0	0	0	0	2024-06-27 16:37:28.919881	2024-06-27 16:37:53.911222	e5230ec4a7ee7e60095be41d3dff788122a15fdd5bb64666c4...
CREATE SCHEMA `bd_colegio`	NULL		1	0	0	75445307000	75445307000	75445307000	0	0	0	0	2024-06-27 16:34:31.162042	2024-06-27 16:34:31.162042	349a837691015907460b8fce2bb4308d28432f413a8554fe2c...
CREATE SCHEMA `naomi` DEFAULT CHARSET = `utf8mb4` ...	NULL		1	0	0	61352146000	61352146000	61352146000	0	0	0	0	2024-06-27 16:31:37.423954	2024-06-27 16:31:37.423954	189f97ca67b8de93416474c37e92541907f59be42fe8d4ac4b...
CREATE SCHEMA `wordpress` DEFAULT CHARSET = `utf8m...	NULL		1	0	0	52391677000	52391677000	52391677000	0	0	0	0	2024-06-27 16:37:02.206031	2024-06-27 16:37:02.206031	23138f75a8bca99631c288b5562d71c54a4348897f1b71aead...
CREATE SCHEMA `Test` DEFAULT CHARSET = `utf8mb4` C...	NULL		1	0	0	51767156000	51767156000	51767156000	0	0	0	0	2024-06-27 16:37:26.449029	2024-06-27 16:37:26.449029	b243a1c8014b64a45034a32c19b40faf9e0e98b5a93ff0588f...
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan...	sys	*	3	0	0	147093182000	112059095000	49031060000	22	7	5355	1785	2024-06-27 16:39:02.045172	2024-06-27 16:39:02.176511	92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc...
CREATE SCHEMA `wscube` DEFAULT CHARSET = `utf8mb4`...	NULL		1	0	0	45261462000	45261462000	45261462000	0	0	0	0	2024-06-27 16:38:21.816481	2024-06-27 16:38:21.816481	a8b21b82d88e94e4f7b35f3f5c2fd5ea05a766db4ff1e26494...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!