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.1491 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$schema_flattened_keys` LIMIT ?, ....	sys	17	95.63 ms	17	0	100	146	146	9	9	2025-11-21 16:47:11.195567	2026-01-27 23:18:38.439042	648c2791b04ca7c99f6c3a69212a4c97951539de5e80b2c270...
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 `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 `CHARACTER_SET_NAME` , ... HARACTER_SETS` ...	information_schema	131	94.31 ms	131	0	100	5371	16113	41	123	2025-11-21 16:46:18.893145	2026-01-27 23:18:59.563752	02be14b541233f2ca8a9be642d4ab41cb9e37dfa26cab84f0e...
SELECT * FROM `x$statements_with_sorting` LIMIT ?,...	sys	16	933.77 ms	16	0	100	400	70319	25	4395	2025-11-21 16:47:20.156038	2026-01-27 23:17:33.861313	d13f132224840bccb88912780775a1279899667eed755845a9...
SELECT * FROM `statements_with_sorting` LIMIT ?, ....	sys	17	932.77 ms	17	0	100	425	74737	25	4396	2025-11-21 16:47:05.923019	2026-01-27 23:17:03.985275	ea0edc73409fc1378a645c30846bf542d918b25383d652be59...
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 `statements_with_errors_or_warnings`...	sys	16	904.97 ms	16	0	100	400	70166	25	4385	2025-11-21 16:47:04.402605	2026-01-27 23:16:40.883163	164a52c287461c32ec3434319103f821bbcc1e5501a760857e...
SELECT * FROM `x$ps_digest_avg ... ncy_distributio...	sys	16	904.69 ms	16	0	100	400	400	25	25	2025-11-21 16:47:09.825316	2026-01-27 23:18:31.860551	0c94e84dddc0059f18a4f9ddebc647f8766800b7b471a58b9a...
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...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view