54.92.119.206 / 127.0.0.1 / sys / statements_with_full_table_scans

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

SELECT * FROM `statements_with_full_table_scans`

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

Filter rows:

query	db	exec_count	total_latency	no_index_used_count	no_good_index_used_count	no_index_used_pct	rows_sent	rows_examined	rows_sent_avg	rows_examined_avg	first_seen	last_seen	digest
SELECT COUNT ( * ) AS `row_cou ... M `sys` . `stat...	sys	10	989.57 ms	10	0	100	10	0	1	0	2025-11-21 16:47:07.765968	2026-01-12 15:31:33.824430	063868a50e565e3ed6d4d8bb03ca9a92bed7a16ceca28352da...
SELECT * FROM `mysql` . `time_zone_name` LIMIT ?	NULL	4	976.96 us	4	0	100	0	0	0	0	2025-12-13 15:33:40.416728	2026-01-14 02:12:15.665557	f3f88dd4a15ef7e56ac06f94037bc0f0175f94ec006404d44f...
SELECT COUNT ( * ) AS `row_cou ... ments_with_erro...	sys	10	969.86 ms	10	0	100	10	40542	1	4054	2025-11-21 16:47:04.789742	2026-01-12 15:31:30.762547	91d77b4b845899c15251c21cb2a2e5c450f1ca256850efae6a...
SELECT COUNT ( * ) AS `row_cou ... ser_summary_by_...	sys	10	96.46 ms	10	0	100	10	9614	1	961	2025-11-21 16:47:11.636898	2026-01-12 23:54:12.398184	2359eeb983d7bb2a7c03c360b45cfa9fb8256e73e82696dd8c...
SELECT COUNT ( * ) AS `row_cou ... tements_with_fu...	sys	10	955.39 ms	10	0	100	10	40566	1	4057	2025-11-21 16:47:05.304174	2026-01-12 21:52:12.416025	2c60237dcc27d3a7a9d90b747203f3cf741adae756de5dd95c...
SELECT COUNT ( * ) AS `row_cou ... schema` . `INNO...	information_schema	10	953.23 ms	10	0	100	10	81910	1	8191	2025-11-21 16:46:22.587809	2026-01-12 11:17:56.427897	59529c9627017aeb3e584af967588f55291cd8b7d9fed0fce5...
SELECT * FROM `mysql` . `proxies_priv` LIMIT ?	mysql	8	950.46 us	8	0	100	8	8	1	1	2025-11-21 16:46:50.604483	2026-01-27 22:07:29.856270	259bcc09616d15725f15215f53515acf369d5f4103129487ba...
SELECT * FROM `x$user_summary_by_stages` LIMIT ?, ...	sys	15	95.33 ms	15	0	100	67	10363	4	691	2025-11-21 16:47:24.077905	2026-01-17 20:54:38.286187	21986a0304fb35a303597bcc5aa1ce540f32b65e1e1990414c...
SELECT `p` . * FROM `2025Benvia` . `prompts` AS `p...	NULL	3	946.79 us	3	0	100	12	12	4	4	2026-01-10 11:34:43.160868	2026-01-13 02:42:22.357454	e9e5ab5eb32d4660602bdbd59d376e897623b5a55d19307849...
SELECT COUNT ( * ) AS `row_cou ... `statements_wi...	sys	10	946.22 ms	10	0	100	10	40626	1	4063	2025-11-21 16:47:07.152139	2026-01-12 15:31:33.804660	efe9b607c82b62b4dee08bb78262aba24e7dc7308e8ac1f6c9...
SELECT * FROM `mysql` . `repli ... tion_failover_m...	mysql	8	943.01 us	8	0	100	0	0	0	0	2025-11-21 16:46:50.890731	2026-01-27 22:06:51.560110	4e3d72e1c3e3df662006a4f9ca04a38b02b6ccd04396ba7423...
SELECT * FROM `x$user_summary` LIMIT ?, ...	sys	15	940.64 ms	15	0	100	78	78	5	5	2025-11-21 16:47:22.313685	2026-01-14 17:35:31.754320	8fcae86d393bdbf8750659300af9ce27c730a6f0b0519f798f...
SELECT * FROM `TRIGGERS` LIMIT ?, ...	information_schema	65	94.49 ms	65	0	100	130	975	2	15	2025-11-21 16:46:21.252519	2026-01-15 21:13:12.438672	51850b08244e88cf1d2363713180fec3d3c9df7da56f462f64...
SELECT * FROM `information_schema` . `CHARACTER_SE...	information_schema	121	94.09 ms	121	0	100	4961	9922	41	82	2025-11-21 16:46:18.892906	2026-01-14 00:49:16.006998	d8b8badde55f6ff1a2b9f7d29509438c7422676de1220dfdee...
SELECT * FROM `mysql` . `slave_master_info` LIMIT ...	mysql	8	931.61 us	8	0	100	0	0	0	0	2025-11-21 16:46:52.146535	2026-01-27 22:08:29.059152	fefe2a6fdb266bfd6938d60cfa6370fce4affaba89d3ed5b43...
SELECT * FROM `mysql` . `slave_worker_info` LIMIT ...	mysql	7	925.80 us	7	0	100	0	0	0	0	2025-11-21 16:46:52.609733	2026-01-27 22:08:29.565275	4a2b120875a29d8432fb0d56c34cab899b10a51db7bf79b261...
SELECT * FROM `mysql` . `slave_relay_log_info` LIM...	mysql	8	917.58 us	8	0	100	0	0	0	0	2025-11-21 16:46:52.473498	2026-01-27 22:07:31.587711	af65a3539e0691d6d91319e6e12b806abca475e7bad3bbd255...
SELECT * FROM `events_statemen ... nt_by_event_nam...	performance_schema	3505	914.00 ms	3505	0	100	87625	87625	25	25	2025-11-21 16:46:37.466120	2026-01-27 23:05:31.433951	607f8c31c0bf8fefa8a941bcac8b6f0c6f211cf2c47e3e993b...
SELECT * FROM `x$statements_with_sorting` LIMIT ?,...	sys	15	912.78 ms	15	0	100	375	65670	25	4378	2025-11-21 16:47:20.156038	2026-01-27 23:15:26.324364	d13f132224840bccb88912780775a1279899667eed755845a9...
SELECT * FROM `statements_with_sorting` LIMIT ?, ....	sys	16	910.01 ms	16	0	100	400	70087	25	4380	2025-11-21 16:47:05.923019	2026-01-27 23:15:39.460893	ea0edc73409fc1378a645c30846bf542d918b25383d652be59...
SELECT * FROM `mysql` . `time_zone_leap_second` LI...	NULL	4	902.85 us	4	0	100	0	0	0	0	2025-12-13 12:31:04.454819	2026-01-14 02:20:11.636454	58124f7f5e464c401e48972e9ebdeee897300f0720463267a4...
SELECT COUNT ( * ) AS `row_cou ... ` . `x$user_sum...	sys	10	90.30 ms	10	0	100	10	6072	1	607	2025-11-21 16:47:24.338233	2026-01-12 15:31:57.430743	4802f09b9a1fbfe48349cb27a1b7032782947caa9f68b98d74...
SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `...	2025_Anti_Fraud	14	9.99 ms	14	0	100	136	422	10	30	2025-11-21 16:48:02.991846	2026-01-14 17:34:48.148210	a542eb4d4e8e1ce60fb822fa955e14dfa2bef76ec06dbabd6a...
SELECT * FROM `events_stages_s ... al_by_event_nam...	performance_schema	15	9.85 ms	15	0	100	375	375	25	25	2025-11-21 16:46:36.534859	2026-01-15 15:20:07.536577	b5a4bd42085eb02899cd63bae893e8a60ea19e3d516bc704bd...
SELECT * FROM `INNODB_CACHED_INDEXES` LIMIT ?, ...	information_schema	15	9.85 ms	15	0	100	375	375	25	25	2025-11-21 16:46:25.665258	2026-01-15 19:00:32.539286	b1bf541c93050c1ae5fcfe14fb80dc4b0336817a7ee365a475...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view