rumahsakittuguibu.my.id / 127.0.0.1 / sys / statements_with_full_table_scans

Recent`sys`.`memory_by_host_by_current_bytes`
`simpedak_db`.`hsi_module_item`
`sys`.`wait_classes_global_by_latency`
`sys`.`x$memory_by_host_by_current_bytes`
`sys`.`x$user_summary_by_statement_latency`
`sys`.`memory_by_user_by_current_bytes`
`information_schema`.`ADMINISTRABLE_ROLE_AUTHORIZATIONS`
`information_schema`.`INNODB_METRICS`
`sys`.`host_summary`
`sys`.`innodb_buffer_stats_by_table`
FavoritesThere are no favorite tables.
New
cm9vdA==.YXJzaXBfc3VyYXQ=cm9vdA==.YXJzaXBfc3VyYXQ=0
arsip_surat
cm9vdA==.YmVkX21hbmFqZW1lbjI=cm9vdA==.YmVkX21hbmFqZW1lbjI=0
bed_manajemen2
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.a2V1YW5nYW4=cm9vdA==.a2V1YW5nYW4=0
keuangan
cm9vdA==.bWF0ZXJpYWwtdGVrbmlrcm9vdA==.bWF0ZXJpYWwtdGVrbmlr0
material-teknik
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVuZ2lyaW1hbg==cm9vdA==.cGVuZ2lyaW1hbg==0
pengiriman
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.c2lrX2JyaWRnaW5nX2xhYg==cm9vdA==.c2lrX2JyaWRnaW5nX2xhYg==0
sik_bridging_lab
cm9vdA==.c2ltcGVkYWtfZGI=cm9vdA==.c2ltcGVkYWtfZGI=0
simpedak_db
cm9vdA==.c3lzcm9vdA==.c3lz0
sys

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the 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.

Navigation tree

Customize the 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

Servers

Servers display options.

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

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

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-

Server: 127.0.0.1 »

Database: sys »

View: statements_with_full_table_scans

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

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 Bookmark Query failed Database : Queried time :

Browse mode

Browse mode

Customize 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.0161 seconds.)

SELECT * FROM `statements_with_full_table_scans`

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

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 * 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 `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 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 * FROM `mysql` . `role_edges` LIMIT ?	mysql	10	990.20 us	10	0	100	0	0	0	0	2026-10-06 08:21:48.158854	2026-10-06 14:23:45.176820	c65f34165e53f5c26475baa01ffc1ac28839d00f4c3f331b65...
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 * 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 `user_group_access` LIMIT ?, ...	simpedak_db	7	989.09 us	7	0	100	175	175	25	25	2026-10-06 08:35:39.229845	2026-10-06 12:57:21.215714	0cf5c03078794d585d3d2fa5ac0442ce45db19de20e261fd7e...
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 DISTINCTROW `transactio ... ERE `transactio...	simpedak_db	462	986.64 ms	462	0	100	371892	2950776	805	6387	2026-10-06 09:03:18.269653	2026-10-06 15:21:45.149486	5408eb5668ef43a671cb96054548768e54b33c406506cd41f7...
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 `col` . `name` AS `COLL ... er_set_id` = `c...	bed_manajemen2	104	98.79 ms	104	0	100	28288	32552	272	313	2026-10-06 08:10:45.784876	2026-10-06 14:33:12.716490	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT * FROM `events_waits_current` LIMIT ?, ...	performance_schema	9	979.95 us	9	0	100	0	0	0	0	2026-10-06 08:40:58.668720	2026-10-06 14:41:01.867265	083d8e94d8dc314cc3e24a38c9c5ddaa6f92230300d51427cd...
SELECT * FROM `mysql` . `password_history` LIMIT ?	mysql	8	979.67 us	8	0	100	0	0	0	0	2026-10-06 08:50:57.550507	2026-10-06 14:22:53.145203	1054457d03c9f38bd8402e586e826525b047943c448cfd0834...
SELECT * FROM `events_errors_s ... by_host_by_erro...	performance_schema	6	978.01 us	6	0	100	150	150	25	25	2026-10-06 08:45:33.749893	2026-10-06 13:28:23.973600	e18fc741e825a585dfbbc85b49ac023a2f0049ad09dd8ddec9...
SELECT * FROM `INNODB_CMP` LIMIT ?, ...	information_schema	9	974.41 us	9	0	100	45	45	5	5	2026-10-06 08:17:04.887903	2026-10-06 13:44:29.191770	61edac5abe22c0885c35b102d365182fb3b3f2ca1c2e48feec...
SELECT * FROM `INNODB_TEMP_TABLE_INFO` LIMIT ?, .....	information_schema	9	972.19 us	9	0	100	0	0	0	0	2026-10-06 08:27:31.660306	2026-10-06 14:44:58.161438	1776a6a0f84e57fda0dfb19df6cf7a05a392a759fe43279b30...
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 `mysql` . `time_zone_leap_second` LI...	mysql	7	969.70 us	7	0	100	0	0	0	0	2026-10-06 08:21:17.888205	2026-10-06 13:36:40.573016	58124f7f5e464c401e48972e9ebdeee897300f0720463267a4...
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 `keuangan` . `catatan` LIMIT ?	keuangan	5	964.99 us	5	0	100	5	5	1	1	2026-10-06 08:15:46.023267	2026-10-06 14:59:55.270253	8d1b3e4a238dc6b2f6a18969cde0853c1b7a4fd688be82a49a...
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...

Query results operations