rumahsakittuguibu.my.id / 127.0.0.1 / sys / x$schema_table_statistics

Recent`performance_schema`.`session_status`
`information_schema`.`COLUMNS`
`sys`.`wait_classes_global_by_avg_latency`
`sys`.`wait_classes_global_by_latency`
`sys`.`x$statement_analysis`
`information_schema`.`INNODB_INDEXES`
`sys`.`io_by_thread_by_latency`
`information_schema`.`KEYWORDS`
`information_schema`.`VIEW_TABLE_USAGE`
`sys`.`user_summary_by_statement_latency`
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: x$schema_table_statistics

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

SELECT * FROM `x$schema_table_statistics`

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

table_schema	table_name	total_latency	rows_fetched	fetch_latency	rows_inserted	insert_latency	rows_updated	update_latency	rows_deleted	delete_latency	io_read_requests	io_read	io_read_latency	io_write_requests	io_write	io_write_latency	io_misc_requests	io_misc_latency
simpedak_db	sidokaf_accreditation_institution_document	21121546503290	8967539	21119686453598	55	1157813896	43	702235796	0	0	19592575	1405551366	17166824533019	210	29223	1998933398	10356469	2146603543777
phpmyadmin	pma__recent	13356831810292	23423	166570912594	22549	12369304214122	22549	820956683576	0	0	3	49152	25845084094	8346	136740864	602316845335	8351	167927526748590
simpedak_db	sidokaf_accreditation_transaction	3560370619515	7419524	3558022266847	0	0	102	2348352668	0	0	40	655360	1336991237	102	1671168	29809167488	105	1935722698406
simpedak_db	accreditation_instrument	1299593350007	449489	1299593350007	0	0	0	0	0	0	899371	164283533	871845449751	0	0	0	449750	121650591612
material-teknik	permintaan	1007468360175	360013	1007468360175	0	0	0	0	0	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
arsip_surat	tbl_suma	755653816557	1460302	754547491035	17	1038929990	1	67395532	0	0	525	8601600	19771205267	20	327680	3395128108	24	417922751625
phpmyadmin	pma__userconfig	481433709192	29046	481398448298	0	0	1	35260894	0	0	3	49152	14468500300	1	16384	682831383	6	28224828047
pengiriman	pengiriman	260015922850	29	259224795260	4	544137106	0	0	4	246990484	4	65536	1575112433	5	81920	4754341345	10	165102812641
phpmyadmin	pma__column_info	193466755286	3058	193466755286	0	0	0	0	0	0	4	65536	51121666014	0	0	0	5	124045372
phpmyadmin	pma__favorite	151742062239	1135	40622163422	252	102528529447	251	8591369370	0	0	3	49152	30834714956	161	2637824	14648318014	166	3169687450776
phpmyadmin	pma__tracking	117440522602	13452	117440522602	0	0	0	0	0	0	3	49152	30027967468	0	0	0	5	147094464
simpedak_db	accreditation_instrument_standard	108117443476	26217	108117443476	0	0	0	0	0	0	45580	14567619	87239189930	0	0	0	22835	6612413550
phpmyadmin	pma__table_info	52399568682	5654	52399568682	0	0	0	0	0	0	3	49152	13801012666	0	0	0	5	142470662
phpmyadmin	pma__table_uiprefs	51742299916	2278	51742299916	0	0	0	0	0	0	3	49152	19517170680	0	0	0	5	146341084
pengiriman	user	46736246996	23	46736246996	0	0	0	0	0	0	3	49152	45743136602	0	0	0	5	405801904
phpmyadmin	pma__central_columns	43377257280	18	43377257280	0	0	0	0	0	0	3	49152	19861985931	0	0	0	5	175705560
phpmyadmin	pma__designer_settings	39973190508	38	39973190508	0	0	0	0	0	0	3	49152	39406293196	0	0	0	5	218790224
simpedak_db	modules	36677747582	43705	36677747582	0	0	0	0	0	0	3	49152	68349792105	0	0	0	5	138827880
arsip_surat	tbl_bidang	32654375350	52932	32654375350	0	0	0	0	0	0	3	49152	1006000780	0	0	0	5	154073798
pengiriman	layanan	25712083256	36	25712083256	0	0	0	0	0	0	3	49152	25064968318	0	0	0	5	143683116
simpedak_db	location_village	20483102755	509	20483102755	0	0	0	0	0	0	291	4767744	40383337626	0	0	0	5	142853043
simpedak_db	user_profile	19619035786	3188	17693681056	0	0	30	1925354730	0	0	5	81920	29156162094	28	458752	8335100930	33	286789491426
simpedak_db	user_group_access	19531723922	52924	19531723922	0	0	0	0	0	0	3	49152	37341070759	0	0	0	5	128344516
simpedak_db	user_log	17164473340	274	14099775532	28	2965748662	2	98949146	0	0	99	1622016	132037854405	28	458752	27462912631	33	820996683447
simpedak_db	location_city	15371520538	1262	15371520538	0	0	0	0	0	0	2528	52863	34795100555	0	0	0	1318	1476739162

Query results operations