www.bloggerafif.com / localhost / sys / x$statements_with_runtimes_in_95th_percentile

There are no favorite tables.

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 4.3643 seconds.)

SELECT * FROM `x$statements_with_runtimes_in_95th_percentile`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

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 COUNT ( * ) FROM `mysql` . `engine_cost`	mysql		2	0	0	1392670842450	1383668864055	696335421225	2	1	0	0	2025-09-16 18:18:27.164335	2025-09-16 20:32:14.038899	7a65e4d4ea77b0c21fa7de43864951bc5230965d5733328b70...
SELECT * , `TABLE_SCHEMA` AS `Db` , `TABLE_NAME` A...	performance_schema		13	0	0	6564189957395	1309781291395	504937431155	1443	111	4355	335	2025-09-15 17:17:45.439949	2025-09-17 00:38:16.323887	fbf41b48714dc04fe6f03efe44b1836b440bfba861352cde8b...
SELECT COUNT ( * ) FROM `sys` . `sys_config`	sys		3	0	0	493494640755	482096828120	164498213585	3	1	0	0	2025-09-16 18:10:12.952360	2025-09-17 02:12:36.008622	ff6f66e89d6c70d6141178085f7ce0f5663b68cc3b859676b6...
SELECT * FROM `schema_table_statistics_with_buffer...	sys	*	2	0	0	321628454660	170573284875	160814227330	50	25	50	25	2025-09-15 21:55:15.376521	2025-09-17 02:14:15.087468	fdee27173c4a77d557522e56c6b31ca442ad7793a4ac7466dc...
SELECT COUNT ( * ) FROM `mysql` . `global_grants`	mysql		2	0	0	300304244845	293032653260	150151982740	2	1	0	0	2025-09-16 18:18:27.177871	2025-09-16 20:32:14.333159	3b46b7f2310ec0d7c027fe43be5fbe71e12c199b519a5a7d07...
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ...	information_schema	*	2	0	0	293777719715	153436756410	146888720175	50	25	50	25	2025-09-16 23:56:36.319533	2025-09-17 00:22:23.909900	9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c...
SELECT * FROM `innodb_buffer_stats_by_schema` LIMI...	sys	*	2	0	0	276021280315	138033129040	138010500475	4	2	4	2	2025-09-15 20:45:26.482337	2025-09-16 04:57:38.105203	c89cd2c6d966ac6303f6122f50ef0d29cce0a77c60f1a8f8c5...
SELECT * FROM `statements_with_full_table_scans` L...	sys	*	1	0	0	108503131080	108503131080	108503131080	25	25	262	262	2025-09-15 18:24:47.425648	2025-09-15 18:24:47.425648	61a168ff9a9c1dace4fb2296c826ed450dd4cfce11a946897c...
SELECT * FROM `statements_with_temp_tables` LIMIT ...	sys	*	1	0	0	75027381860	75027381860	75027381860	25	25	2429	2429	2025-09-17 02:14:12.836879	2025-09-17 02:14:12.836879	d4bc080849247e165e4ac7bf3fdda8fd9aacc608175079fe10...
SELECT * FROM `x$schema_table_statistics` LIMIT ?,...	sys	*	1	0	0	63785454895	63785454895	63785454895	25	25	25	25	2025-09-15 12:44:22.921718	2025-09-15 12:44:22.921718	6cca2b0b65a8a0b66462bf5ee97d7a050c957fba6ab0f203f5...
SELECT * FROM `schema_object_overview` LIMIT ?, .....	sys	*	2	0	0	126053957840	70109440400	63026978920	22	11	22	11	2025-09-16 11:42:52.549679	2025-09-16 16:56:06.533501	86bc06b9dfe86ce14b35eac34549b5e30623a3fe73f956a8e8...
SELECT * FROM `io_global_by_file_by_latency` LIMIT...	sys	*	1	0	0	61439068260	61439068260	61439068260	25	25	114	114	2025-09-17 02:14:04.572436	2025-09-17 02:14:04.572436	6e134426c6bb20e162d80ad1f9e4b6697ebdb4042c1ee6c059...
SELECT * FROM `statements_with_sorting` LIMIT ?, ....	sys	*	1	0	0	52883794500	52883794500	52883794500	25	25	565	565	2025-09-16 16:58:17.174392	2025-09-16 16:58:17.174392	ea0edc73409fc1378a645c30846bf542d918b25383d652be59...
SELECT COUNT ( * ) FROM `mysql` . `innodb_index_st...	mysql		2	0	0	104661862330	97099451780	52330931165	2	1	0	0	2025-09-16 18:18:27.219192	2025-09-16 20:32:14.439826	9b0102f1f58cf56d14116126b780ce72cbe444a6d1f6adc2ed...
SELECT * FROM `x$memory_by_thread_by_current_bytes...	sys	*	1	0	0	48378754510	48378754510	48378754510	25	25	25	25	2025-09-17 02:16:04.697023	2025-09-17 02:16:04.697023	3cb2a3d0f530ea3f1be700ed148ece6cc8101ecf3a66198772...
SELECT * FROM `schema_table_statistics` LIMIT ?, ....	sys	*	1	0	0	48206386305	48206386305	48206386305	25	25	25	25	2025-09-15 21:01:49.560878	2025-09-15 21:01:49.560878	fe6079bb205e521367eb3af8c8a22364318ff920473fa89768...
SELECT * FROM `x$ps_digest_avg_latency_distributio...	sys	*	1	0	0	47355440515	47355440515	47355440515	25	25	25	25	2025-09-17 02:16:00.881764	2025-09-17 02:16:00.881764	0c94e84dddc0059f18a4f9ddebc647f8766800b7b471a58b9a...
SHOW FULL FIELDS FROM `information_schema` . `INNO...	NULL		3	1	0	132253625920	123416752240	44084355730	2	1	14	5	2025-09-16 20:49:49.085537	2025-09-16 23:56:41.234063	f050033f20f88ff60d363333ed47f72067c5c0419012a266eb...
SHOW INDEXES FROM `mysql` . `db`	NULL		3	0	0	128024598550	122141451015	42674679940	12	4	135	45	2025-09-16 20:32:12.476886	2025-09-16 22:37:51.515289	24ea75fc4ebd013239cdff8067e4db3e1f4e6168318628432e...
SELECT * FROM `innodb_lock_waits` LIMIT ?, ...	sys	*	1	0	0	41333448575	41333448575	41333448575	0	0	0	0	2025-09-16 04:24:18.312118	2025-09-16 04:24:18.312118	88d7d8295ead3ca7f64feb84e901c0320b61a2ccb569b8efbf...
SHOW FIELDS FROM `mysql` . `role_edges`	NULL		3	0	0	123595545840	113966672385	41198515280	15	5	75	25	2025-09-16 20:32:13.031804	2025-09-16 22:37:51.723099	b8f73087127eadcb01b6b5591c27ed75a595a2370fc50155c0...
SELECT * FROM `x$waits_global_by_latency` LIMIT ?,...	sys	*	1	0	0	40288902840	40288902840	40288902840	14	14	413	413	2025-09-15 20:54:54.670908	2025-09-15 20:54:54.670908	d62daab5a9d158afe92c2b5669cca5483ee8a98d3dbd334f4d...
SHOW CREATE TABLE `sys` . `statements_with_temp_ta...	NULL		3	0	0	110132946490	105208300270	36710795920	0	0	0	0	2025-09-15 09:45:36.556654	2025-09-17 02:16:07.544205	93421c02015dc55898f5c1de188d5d84335234ce4c94411602...
SHOW INDEXES FROM `mysql` . `help_keyword`	NULL		3	0	0	99802308155	92357789635	33267342930	6	2	54	18	2025-09-16 20:32:12.657270	2025-09-16 22:37:51.567349	715063bcc23ffad37dd24efe8591a6a680d743adc38e6e61bf...
FLUSH PRIVILEGES	mysql		2	0	0	64981695825	36390922995	32490708230	0	0	0	0	2025-09-16 20:49:13.786509	2025-09-16 23:50:54.797681	3dec92a8960f55aabfff800ff5fa49e3037436f7723260ae52...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view