Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: statements_with_full_table_scans
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0148 seconds.)
SELECT * FROM `statements_with_full_table_scans`
querydbexec_counttotal_latencyno_index_used_countno_good_index_used_countno_index_used_pctrows_sentrows_examinedrows_sent_avgrows_examined_avgfirst_seenlast_seendigest
SELECT * FROM `hsi_module_sublist_sublist` LIMIT ?... simpedak_db 6 999.90 us 6 0 100 60 60 10 10 2026-10-06 08:15:12.184655 2026-10-06 10:04:35.821112 0c8302d63be39506563e2a0054a7a205c9a25ee9967163bd6f...
SELECT * FROM `events_statemen ... al_by_event_nam... performance_schema 5 998.79 us 5 0 100 125 125 25 25 2026-10-06 08:26:32.472810 2026-10-06 09:36:35.996146 cf4ab885604d1f0df806f1d30c543dfe2d6e93f2b79556c7d1...
SELECT * FROM `replication_app ... s_by_coordinato... performance_schema 6 998.23 us 6 0 100 0 0 0 0 2026-10-06 08:35:03.189849 2026-10-06 10:19:13.863862 600d43302b542e5b61a0d2ee0acb7ddd44d6c010e24ebe6188...
SELECT * FROM `INNODB_CMPMEM_RESET` LIMIT ?, ... information_schema 9 997.68 us 9 0 100 225 225 25 25 2026-10-06 08:30:17.743287 2026-10-06 10:06:06.969173 670dfc95b7b4b0ef4d36c5840370cdd15048364b0b98e3c4d0...
SELECT * FROM `events_stages_current` LIMIT ?, ... performance_schema 6 997.40 us 6 0 100 0 0 0 0 2026-10-06 08:36:05.695272 2026-10-06 10:09:40.619874 167ac9019acb7c26872adbe7614766467d46f65be6224ce316...
SELECT * FROM `events_waits_history_long` LIMIT ?,... performance_schema 7 996.85 us 7 0 100 0 0 0 0 2026-10-06 09:18:18.868029 2026-10-06 11:17:28.979717 b75b04acd3a2957c203fd0949063a07a27ffeb6b0a8cf998e9...
SELECT COUNT ( * ) AS `row_cou ... nformation_sche... information_schema 1 993.52 us 1 0 100 1 44 1 44 2026-10-06 10:15:33.363132 2026-10-06 10:15:33.363132 326269db6899185a5c79e96243cbaaf6b853e07624d0c7ec54...
SELECT COUNT ( * ) AS `row_cou ... a` . `INNODB_FT... information_schema 1 99.46 us 1 0 100 1 0 1 0 2026-10-06 10:03:20.320821 2026-10-06 10:03:20.320821 7b9394e23469f9b5b1d0f9fc0eb346975770e11151777a3355...
SELECT DISTINCTROW * FROM ( SE ...  BY `modules_or... simpedak_db 308 99.42 ms 308 0 100 220 660 1 2 2026-10-06 09:00:09.279522 2026-10-06 11:47:09.921921 b3a6487cc7aaa3cf478eb00ecac89b1a2dbb39f0809398b9ee...
SELECT * FROM `mysql` . `time_zone_name` LIMIT ? mysql 6 989.64 us 6 0 100 0 0 0 0 2026-10-06 08:46:39.341898 2026-10-06 11:22:18.510041 f3f88dd4a15ef7e56ac06f94037bc0f0175f94ec006404d44f...
SELECT * FROM `mysql` . `help_category` LIMIT ? mysql 7 989.37 us 7 0 100 7 7 1 1 2026-10-06 08:45:01.287714 2026-10-06 11:17:25.537292 0052ceb0de8b0d7f7943fc086617d131c0eb8395d409685766...
SELECT * FROM `kalmut_regactivity_period_perunit` ... simpedak_db 6 987.15 us 6 0 100 0 0 0 0 2026-10-06 09:07:58.383777 2026-10-06 09:48:38.789442 5e95e0aa14e962ee8da973161bff85508eb10f396b5510da31...
SELECT COUNT ( * ) FROM `perfo ... nts_waits_summa... NULL 2 984.66 us 2 0 100 2 0 1 0 2026-10-06 08:56:18.866925 2026-10-06 09:19:32.292720 a17cf6995b830960c371c3c67753c8e4d9d9d0bc3e6ea99b13...
SELECT * FROM `socket_instances` LIMIT ?, ... performance_schema 8 974.13 us 8 0 100 33 33 4 4 2026-10-06 08:24:19.474792 2026-10-06 11:57:42.986359 7f50a4fb3c67d888b053f41cd32b8422b9c15174e710bc5eb5...
SELECT * FROM `mysql` . `columns_priv` LIMIT ? mysql 10 973.30 us 10 0 100 0 0 0 0 2026-10-06 08:44:32.931676 2026-10-06 11:03:14.140673 088110f8c84a60b12229e5c884ac2b8b5e010e7234f65ad9e7...
SELECT * FROM `kalmut_quality_indicator_group` LIM... simpedak_db 6 971.64 us 6 0 100 0 0 0 0 2026-10-06 08:44:11.220202 2026-10-06 10:02:44.509637 aa03763342024c17442c0f1d74d35713c23569935bc2119ef8...
SELECT * FROM `replication_con ... on_configuratio... performance_schema 9 971.36 us 9 0 100 0 0 0 0 2026-10-06 08:24:52.698785 2026-10-06 11:59:33.380701 91fed2810540ea323e7c2a6bab24d527808decc3debe8aefb9...
SELECT * FROM `material-teknik` . `pengeluaran` LI... material-teknik 7 970.53 us 7 0 100 7 7 1 1 2026-10-06 08:15:03.867867 2026-10-06 10:58:32.077992 6a502e232fe3748f3464fded43dc7bf9238f469ede8b102350...
SELECT COUNT ( * ) AS `row_cou ... n_schema` . `IN... information_schema 1 97.80 us 1 0 100 1 0 1 0 2026-10-06 10:00:51.880800 2026-10-06 10:00:51.880800 249b2604dcbb04ae8de9f8a42b0a6b511ac8edcc5c90113a7a...
SELECT * FROM `USER_PRIVILEGES` LIMIT ?, ... information_schema 6 968.59 us 6 0 100 150 150 25 25 2026-10-06 08:58:46.722406 2026-10-06 09:57:58.348654 c811c73d3483e0996ed2492a82a7b6d191dd265e2e4e6e1a96...
SELECT * FROM `INNODB_CMP_PER_INDEX_RESET` LIMIT ?... information_schema 9 965.54 us 9 0 100 0 0 0 0 2026-10-06 08:30:01.156124 2026-10-06 10:02:09.421933 2d549b14fec62b373806210253b628596f670a7d95db17072e...
SELECT * FROM `phpmyadmin` . `pma__column_info` LI... phpmyadmin 12 965.26 us 12 0 100 0 0 0 0 2026-10-06 08:24:39.031077 2026-10-06 11:02:44.330329 bea2a0ec149d65c0dfc9423615d771d137a4fd6f0b77889246...
SELECT * FROM `pma__central_columns` LIMIT ?, ... phpmyadmin 8 964.15 us 8 0 100 0 0 0 0 2026-10-06 08:18:40.722975 2026-10-06 12:03:42.017757 727358c4bc9cfe85984b7c67de53ccc9da3d58ea17a6d00e38...
SELECT COUNT ( * ) AS `row_cou ... _schema` . `INN... information_schema 1 96.69 us 1 0 100 1 0 1 0 2026-10-06 10:03:19.257390 2026-10-06 10:03:19.257390 79ea7875b0ec5154d3a120ac5feb210b5bfd7d98f8ab891828...
SELECT * FROM `accounts` LIMIT ?, ... performance_schema 6 953.63 us 6 0 100 18 18 3 3 2026-10-06 08:23:31.200496 2026-10-06 12:07:44.843571 5affa80a3ec42b1a0fca365bed61708c49be618ef9e343ab17...