Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$statement_analysis
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.0149 seconds.)
SELECT * FROM `x$statement_analysis`
querydbfull_scanexec_counterr_countwarn_counttotal_latencymax_latencyavg_latencylock_latencyrows_sentrows_sent_avgrows_examinedrows_examined_avgrows_affectedrows_affected_avgtmp_tablestmp_disk_tablesrows_sortedsort_merge_passesdigestfirst_seenlast_seen
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern... NULL 22598 0 0 1294785866147904 2106791451648 57296289024 974668000000 0 0 0 0 45099 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:23.687832 2026-10-06 21:27:19.477518
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern... phpmyadmin 2691 0 0 157089026772288 485567514432 58375699200 106085000000 0 0 0 0 5373 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:24.711752 2026-10-06 21:27:17.468641
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 220959 0 0 58205624218560 1679513472 263203200 29630551000000 218152 1 1317332 6 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:12:29.899908 2026-10-06 21:27:17.401882
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 * 6306 0 20 12324044611008 8006366504448 1954075968 2210295000000 61231 10 437103 69 0 0 402 0 56150 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:01:02.943794 2026-10-06 21:27:05.341528
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 137 0 0 12076423594560 779818440960 88148968128 16595000000 853 6 1795784 13108 0 0 352 37 69304 37 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2026-10-06 08:37:21.878632 2026-10-06 20:53:27.139793
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 41831 0 0 11515981419072 944760960 275116608 5901458000000 33656 1 226460 5 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:10:29.044349 2026-10-06 21:27:11.374674
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 15001 0 0 11045274911424 2229746688 736137792 4693372000000 263755 18 1394998 93 0 0 13997 0 248740 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:29.090878 2026-10-06 21:27:11.465046
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL 7736 0 0 10827634124736 289514377152 1399409856 2445794000000 9129 1 111208 14 0 0 7736 0 9129 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:10:25.928426 2026-10-06 21:27:13.441253
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db * 23686 0 0 9869725195200 1293297408 416415168 3967107000000 94020 4 573138 24 0 0 52068 0 140448 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:10:21.686877 2026-10-06 21:27:11.456307
SELECT COUNT ( * ) AS `c` FROM ( SELECT `document_... simpedak_db * 302 0 0 9580739440896 63900749952 31724297280 62955000000 302 1 850 3 0 0 604 0 0 0 8586314de6146035fdf39233e80d7d1bade017e7566e476ac3... 2026-10-06 09:03:18.576000 2026-10-06 19:44:06.783104
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 14274 0 0 9541831358592 4696099200 668259072 4901237000000 334435 23 1535237 108 0 0 101 0 318714 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:18.929984 2026-10-06 21:27:11.358645
SELECT `document_id` , `document_event_id` , `docu... simpedak_db * 302 0 0 9464040960192 35175306816 31337804160 47669000000 850 3 3930510 13015 0 0 302 0 850 0 76a75a5e759b4af598f59ae43eb8e53b98be9c5f925f1d7a33... 2026-10-06 09:03:18.606916 2026-10-06 19:44:06.815156
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... information_schema * 356 0 0 9271161222336 1027831491648 26042432832 111428000000 618 2 7794 22 0 0 317 0 0 0 6b962281752cce8cb8541a21b1d4e4db06b701224fba881b1f... 2026-10-06 08:10:24.443675 2026-10-06 21:16:44.614935
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 149 0 0 8431074235584 294172519680 56584255104 17270000000 785 5 303448 2037 0 0 202 0 3733 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2026-10-06 09:03:06.973504 2026-10-06 21:05:46.597345
COMMIT simpedak_db 170 0 0 8381958024960 250371628416 49305439872 0 0 0 0 0 0 0 0 0 0 0 f2b9be5f0f32ca7507e4ddf133cd2fad0993a1c26fde9caa6f... 2026-10-06 07:49:00.468593 2026-10-06 19:45:18.945587
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 11599 0 0 7793391063744 2822369472 671860800 3179562000000 116549 10 600312 52 0 0 10729 0 107762 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:12:29.831238 2026-10-06 21:27:17.406014
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 14718 0 135 7661455057152 12967606080 520311168 4307934000000 646 0 59043 4 0 0 14753 0 12408 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:12:29.832683 2026-10-06 21:27:17.406894
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL * 17311 0 0 7645864561920 1560102336 441627264 3166670000000 65271 4 399478 23 0 0 38976 0 104592 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:01:08.620581 2026-10-06 21:27:21.350407
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 9659 0 0 7644660753600 30145078080 791271936 3207966000000 493547 51 1660462 172 0 0 49 0 490189 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:12.324925 2026-10-06 21:27:19.356106
SHOW SESSION VARIABLES LIKE ? NULL * 5150 0 0 7413170768640 2486854656 1439305920 385323000000 5150 1 2981850 579 0 0 5150 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2026-10-06 08:09:57.961405 2026-10-06 21:27:23.345029
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 10164 0 0 7147750843584 2310369984 703168128 3062963000000 132704 13 671832 66 0 0 9314 0 121539 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:28.438222 2026-10-06 21:27:19.405378
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... mysql * 17326 0 26 7055528044032 6340149504 406995264 2869605000000 72897 4 413166 24 0 0 35481 0 106224 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 07:58:51.818954 2026-10-06 21:27:22.177370
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 7140 0 0 6618597156288 8492043456 926752320 2428930000000 455116 64 1161583 163 0 0 232 0 454193 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:12:26.213811 2026-10-06 21:27:17.337994
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 15005 0 0 6252118561728 1222648128 416415168 2501987000000 60127 4 369415 25 0 0 33080 0 90192 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:12:26.420122 2026-10-06 21:27:17.396813