rumahsakittuguibu.my.id / 127.0.0.1 / sys / statements_with_full_table_scans

Recent`sys`.`metrics`
`sys`.`x$session`
`sys`.`x$ps_schema_table_statistics_io`
`phpmyadmin`.`pma__central_columns`
`simpedak_db`.`modules`
`sys`.`statements_with_full_table_scans`
`mysql`.`time_zone_leap_second`
`sys`.`io_global_by_wait_by_bytes`
`phpmyadmin`.`pma__table_coords`
`simpedak_db`.`kalmut_devopvarmutu`
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.0147 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 `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 `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 `pma__history` LIMIT ?, ...	phpmyadmin	6	992.69 us	6	0	100	0	0	0	0	2026-10-06 08:34:15.509108	2026-10-06 12:19:46.624594	099619e24c68fb55c5b51e0694e316a571026b326bc630c5c2...
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 `events_waits_summary_by_instance` L...	performance_schema	6	988.26 us	6	0	100	150	150	25	25	2026-10-06 08:42:37.335714	2026-10-06 12:52:54.450686	501c023eeb3206b4dddd4b8df6a1a2556742c23c321469e110...
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 `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 `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 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 `phpmyadmin` . `pma__pdf_pages` LIMI...	phpmyadmin	8	952.24 us	8	0	100	0	0	0	0	2026-10-06 08:19:39.377060	2026-10-06 10:57:37.489173	b428811cace2a215aa23df6d92a720c2c8281ac947a36d2410...
SELECT * FROM `phpmyadmin` . `pma__savedsearches` ...	phpmyadmin	9	951.13 us	9	0	100	0	0	0	0	2026-10-06 08:16:08.925269	2026-10-06 11:22:14.527411	880b9616157512439ea9f1a424305ddd51f47c2a17b26876ce...
SELECT `col` . `name` AS `COLL ... er_set_id` = `c...	bed_manajemen2	101	95.85 ms	101	0	100	27472	31613	272	313	2026-10-06 08:10:45.784876	2026-10-06 13:08:38.852352	85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432...
SELECT * FROM `phpmyadmin` . `pma__export_template...	phpmyadmin	9	943.38 us	9	0	100	9	9	1	1	2026-10-06 08:18:25.026755	2026-10-06 12:42:43.668006	c60552150b8d41248fa0025db55aa6be8ef8c389cafbaa82bf...

Query results operations