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

Recent`mysql`.`time_zone_transition`
`sys`.`x$schema_table_statistics_with_buffer`
`mysql`.`default_roles`
`mysql`.`columns_priv`
`mysql`.`procs_priv`
`phpmyadmin`.`pma__users`
`mysql`.`time_zone_name`
`sys`.`x$memory_global_total`
`simpedak_db`.`local_quality_indicator_document`
`mysql`.`slow_log`
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$statement_analysis

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

SELECT * FROM `x$statement_analysis`

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

query	db	full_scan	exec_count	err_count	warn_count	total_latency	max_latency	avg_latency	lock_latency	rows_sent	rows_sent_avg	rows_examined	rows_examined_avg	rows_affected	rows_affected_avg	tmp_tables	tmp_disk_tables	rows_sorted	sort_merge_passes	digest	first_seen	last_seen
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern...	NULL		19684	0	0	1103914562647104	2106791451648	56081675520	849021000000	0	0	0	0	39282	2	0	0	0	0	729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000...	2026-10-06 08:10:23.687832	2026-10-06 16:54:03.475140
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern...	phpmyadmin		2085	0	0	120781341105984	485567514432	57928530816	82285000000	0	0	0	0	4161	2	0	0	0	0	729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000...	2026-10-06 08:10:24.711752	2026-10-06 16:58:15.023127
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	sys		182103	0	0	48052471012416	1679513472	263757312	24451754000000	179670	1	1085318	6	0	0	0	0	0	0	513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6...	2026-10-06 08:12:29.899908	2026-10-06 16:55:06.500610
REPLACE INTO `phpmyadmin` . `pma__favorite` ( `use...	NULL		246	0	0	14640106156416	211705693056	59512459968	19309000000	0	0	0	0	491	2	0	0	0	0	3f68cdacb0dc8def195c35b2b0d0ad9677d9e170013adb2c51...	2026-10-06 08:10:26.952120	2026-10-06 10:25:39.883890
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	mysql	*	5545	0	19	11815940253312	8006366504448	2130837696	1942999000000	54816	10	386477	70	0	0	389	0	50526	0	c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c...	2026-10-06 08:01:02.943794	2026-10-06 16:58:14.958585
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ...	sys	*	120	0	0	10964172031488	779818440960	91368081792	14267000000	753	6	1518440	12654	0	0	307	33	60216	33	bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...	2026-10-06 08:37:21.878632	2026-10-06 16:42:01.758601
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	NULL		6781	0	0	10329574155264	289514377152	1523253888	2166355000000	8118	1	97791	14	0	0	6781	0	8118	0	65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d...	2026-10-06 08:10:25.928426	2026-10-06 16:53:48.952770
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	simpedak_db		13234	0	0	9726770117376	2229746688	734752512	4161146000000	229267	17	1217719	92	0	0	12315	0	215822	0	d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61...	2026-10-06 08:10:29.090878	2026-10-06 16:53:26.204184
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	simpedak_db		31373	0	0	8683865671104	833384448	276778944	4454508000000	24566	1	167816	5	0	0	0	0	0	0	513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6...	2026-10-06 08:10:29.044349	2026-10-06 16:53:26.196079
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	simpedak_db	*	20454	0	0	8527120407936	1293297408	416692224	3430520000000	80866	4	494378	24	0	0	45043	0	121512	0	f99d3ab026388b996576df9a037e7ae64515b921778806312a...	2026-10-06 08:10:21.686877	2026-10-06 16:53:26.181774
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	simpedak_db		12121	0	0	8124481295424	4696099200	670198464	4177682000000	275114	23	1260994	104	0	0	93	0	262543	0	c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c...	2026-10-06 08:10:18.929984	2026-10-06 16:53:26.197437
SELECT COUNT ( * ) AS `c` FROM ( SELECT `document_...	simpedak_db	*	252	0	0	7993451816064	63900749952	31719864384	53139000000	252	1	569	2	0	0	504	0	0	0	8586314de6146035fdf39233e80d7d1bade017e7566e476ac3...	2026-10-06 09:03:18.576000	2026-10-06 16:52:55.807223
SELECT `document_id` , `document_event_id` , `docu...	simpedak_db	*	252	0	0	7887777393600	35175306816	31300678656	39831000000	569	2	3276135	13001	0	0	252	0	569	0	76a75a5e759b4af598f59ae43eb8e53b98be9c5f925f1d7a33...	2026-10-06 09:03:18.606916	2026-10-06 16:52:55.838223
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	information_schema	*	302	0	0	7507367315136	1027831491648	24858572544	93606000000	518	2	6590	22	0	0	267	0	0	0	6b962281752cce8cb8541a21b1d4e4db06b701224fba881b1f...	2026-10-06 08:10:24.443675	2026-10-06 16:48:00.553999
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	NULL	*	15947	0	0	7035404635584	1560102336	441073152	2913508000000	60101	4	367940	23	0	0	35905	0	96312	0	f99d3ab026388b996576df9a037e7ae64515b921778806312a...	2026-10-06 08:01:08.620581	2026-10-06 16:53:48.930222
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan...	sys	*	119	0	0	7033246923456	294172519680	59102694144	14068000000	609	5	252089	2118	0	0	166	0	3083	0	92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc...	2026-10-06 09:03:06.973504	2026-10-06 16:51:41.672184
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	sys		10113	0	0	6774575805504	2822369472	669644352	2777097000000	101464	10	522541	52	0	0	9349	0	93752	0	d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61...	2026-10-06 08:12:29.831238	2026-10-06 16:55:06.507437
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	performance_schema		8498	0	0	6728632440192	30145078080	791548992	2819765000000	435062	51	1459285	172	0	0	44	0	432075	0	c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c...	2026-10-06 08:10:12.324925	2026-10-06 16:53:50.804341
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	sys	*	12769	0	99	6621789949632	12024507456	518371776	3737847000000	513	0	48793	4	0	0	12813	0	11225	0	65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d...	2026-10-06 08:12:29.832683	2026-10-06 16:55:06.508205
SHOW SESSION VARIABLES LIKE ?	NULL	*	4462	0	0	6400951659648	2486854656	1434318912	333231000000	4462	1	2583498	579	0	0	4462	0	0	0	6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0...	2026-10-06 08:09:57.961405	2026-10-06 17:02:21.122200
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	performance_schema		8785	0	0	6197010460992	2310369984	705384576	2661672000000	114450	13	578957	66	0	0	8025	0	104551	0	d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61...	2026-10-06 08:10:28.438222	2026-10-06 16:53:50.850552
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	mysql	*	14885	0	26	6059233005696	6340149504	406995264	2466350000000	62625	4	354685	24	0	0	30491	0	91188	0	f99d3ab026388b996576df9a037e7ae64515b921778806312a...	2026-10-06 07:58:51.818954	2026-10-06 16:58:14.944959
COMMIT	simpedak_db		125	0	0	5878887004224	250371628416	47031087168	0	0	0	0	0	0	0	0	0	0	0	f2b9be5f0f32ca7507e4ddf133cd2fad0993a1c26fde9caa6f...	2026-10-06 07:49:00.468593	2026-10-06 16:52:28.175967
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ...	sys		6161	0	0	5734449122688	8492043456	930631104	2103693000000	391251	64	995837	162	0	0	223	0	390429	0	c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c...	2026-10-06 08:12:26.213811	2026-10-06 16:55:06.469394
SELECT * FROM `INNODB_COLUMNS` LIMIT ?, ...	information_schema	*	11	0	0	5629870179648	597279264192	511806379968	38049000000	275	25	275	25	0	0	11	11	0	0	1512ccbc467635564d751a38813be9534f3a3cf75c1a1f59a8...	2026-10-06 08:58:43.005179	2026-10-06 15:53:10.007017

Query results operations