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.0152 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 18375 0 0 1011174537499776 2106791451648 55029693888 792850000000 0 0 0 0 36672 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:23.687832 2026-10-06 15:30:19.014099
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern... phpmyadmin 1824 0 0 103847707476864 485567514432 56933899776 72036000000 0 0 0 0 3639 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:24.711752 2026-10-06 15:30:21.625531
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 167132 0 0 44064722827008 1562041728 263480256 22416395000000 164920 1 996155 6 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:12:29.899908 2026-10-06 15:30:11.385960
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 * 4991 0 19 11463413644800 8006366504448 2296794240 1749567000000 49491 10 346296 69 0 0 382 0 45590 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:01:02.943794 2026-10-06 15:30:16.947549
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 113 0 0 10301706477504 779818440960 91165276800 13084000000 703 6 1379768 12210 0 0 286 31 55672 31 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2026-10-06 08:37:21.878632 2026-10-06 15:28:55.084148
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL 6599 0 0 10227846949632 289514377152 1549851264 2108972000000 7936 1 95203 14 0 0 6599 0 7936 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:10:25.928426 2026-10-06 15:29:30.407801
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 12443 0 0 9133318935936 2171564928 733921344 3934819000000 215324 17 1145543 92 0 0 11567 0 202476 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:29.090878 2026-10-06 15:30:18.958123
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db * 19118 0 0 7968893018112 1293297408 416692224 3206831000000 75482 4 461898 24 0 0 42123 0 113640 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:10:21.686877 2026-10-06 15:30:18.946400
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 27759 0 0 7695600823872 833384448 277056000 3948759000000 21513 1 147815 5 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:10:29.044349 2026-10-06 15:30:18.953927
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 11225 0 0 7503694937856 4696099200 668259072 3877305000000 247660 22 1137046 101 0 0 83 0 235935 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:18.929984 2026-10-06 15:29:49.344300
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL * 15279 0 0 6737549487552 1560102336 440796096 2790238000000 57596 4 352615 23 0 0 34402 0 92304 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:01:08.620581 2026-10-06 15:29:30.383804
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 111 0 0 6468823453248 294172519680 58277621376 13084000000 534 5 230618 2078 0 0 152 0 2814 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2026-10-06 09:03:06.973504 2026-10-06 15:00:19.931014
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 8035 0 0 6383608508160 30145078080 794319552 2667836000000 408589 51 1372144 171 0 0 44 0 405742 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:12.324925 2026-10-06 15:30:09.354627
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 9379 0 0 6262846170048 2214231552 667704960 2565649000000 94252 10 485659 52 0 0 8687 0 87242 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:12:29.831238 2026-10-06 15:30:11.390016
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... information_schema * 267 0 0 6212549423808 1027831491648 23267716992 83440000000 440 2 5474 21 0 0 239 0 0 0 6b962281752cce8cb8541a21b1d4e4db06b701224fba881b1f... 2026-10-06 08:10:24.443675 2026-10-06 15:30:07.360463
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 11935 0 87 6177113684352 10325600064 517540608 3489106000000 433 0 45118 4 0 0 11982 0 10765 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:12:29.832683 2026-10-06 15:30:11.390777
SELECT COUNT ( * ) AS `c` FROM ( SELECT `document_... simpedak_db * 188 0 0 5966342501184 63900749952 31735656576 40613000000 188 1 405 2 0 0 376 0 0 0 8586314de6146035fdf39233e80d7d1bade017e7566e476ac3... 2026-10-06 09:03:18.576000 2026-10-06 15:21:45.185060
SHOW SESSION VARIABLES LIKE ? NULL * 4153 0 0 5947169394816 2486854656 1431825408 310113000000 4153 1 2404587 579 0 0 4153 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2026-10-06 08:09:57.961405 2026-10-06 15:30:28.949241
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 8409 0 0 5917402498176 2310369984 703445184 2547771000000 108770 13 550379 65 0 0 7687 0 99346 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:28.438222 2026-10-06 15:30:09.360083
SELECT `document_id` , `document_event_id` , `docu... simpedak_db * 188 0 0 5878171645632 35175306816 31266600768 29672000000 405 2 2441227 12985 0 0 188 0 405 0 76a75a5e759b4af598f59ae43eb8e53b98be9c5f925f1d7a33... 2026-10-06 09:03:18.606916 2026-10-06 15:21:45.216725
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... mysql * 13506 0 26 5490442855872 6340149504 406441152 2237376000000 56682 4 321024 24 0 0 27567 0 82596 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 07:58:51.818954 2026-10-06 15:30:16.935414
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 5602 0 0 5253190383168 8492043456 937557504 1918603000000 355597 63 907350 162 0 0 223 0 354824 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:12:26.213811 2026-10-06 15:30:11.323824
SELECT * FROM `INNODB_COLUMNS` LIMIT ?, ... information_schema * 10 0 0 5121696003840 597279264192 512169600384 37326000000 250 25 250 25 0 0 10 10 0 0 1512ccbc467635564d751a38813be9534f3a3cf75c1a1f59a8... 2026-10-06 08:58:43.005179 2026-10-06 14:50:02.838316
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 11926 0 0 4968301732992 1222648128 416415168 1988695000000 47621 4 293400 25 0 0 26344 0 71856 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:12:26.420122 2026-10-06 15:30:11.380784