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`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
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 21843 0 0 1242741867352128 2106791451648 56894280768 941666000000 0 0 0 0 43591 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:23.687832 2026-10-06 20:07:05.849306
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern... phpmyadmin 2545 0 0 147839954947776 485567514432 58090331520 100184000000 0 0 0 0 5081 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:24.711752 2026-10-06 20:07:16.909156
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 210571 0 0 55506793462848 1679513472 263480256 28252906000000 207844 1 1255244 6 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:12:29.899908 2026-10-06 20:06:59.485109
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 * 6137 0 20 12216723644736 8006366504448 1990647360 2150220000000 60104 10 427325 70 0 0 399 0 55237 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:01:02.943794 2026-10-06 20:06:45.457684
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 134 0 0 12074956583040 779818440960 90111355776 16595000000 853 6 1795784 13401 0 0 349 37 69304 37 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2026-10-06 08:37:21.878632 2026-10-06 20:06:59.436055
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL 7603 0 0 10753867410624 289514377152 1414370880 2404506000000 8956 1 108810 14 0 0 7603 0 8956 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:10:25.928426 2026-10-06 20:06:47.444178
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 14525 0 0 10681015812480 2229746688 735306624 4547394000000 254579 18 1348036 93 0 0 13553 0 240119 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:29.090878 2026-10-06 20:07:12.861763
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 38400 0 0 10590780612672 944760960 275670720 5429476000000 30632 1 207095 5 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:10:29.044349 2026-10-06 20:07:01.494282
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 * 22742 0 0 9474047945856 1293297408 416415168 3808029000000 90216 4 550182 24 0 0 50004 0 134880 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:10:21.686877 2026-10-06 20:07:12.845551
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` ... simpedak_db 13682 0 0 9152666587584 4696099200 668813184 4699337000000 319622 23 1464902 107 0 0 98 0 304649 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:18.929984 2026-10-06 20:07:12.824574
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... information_schema * 344 0 0 8390596076928 1027831491648 24391179072 107597000000 583 2 7252 21 0 0 307 0 0 0 6b962281752cce8cb8541a21b1d4e4db06b701224fba881b1f... 2026-10-06 08:10:24.443675 2026-10-06 19:57:01.093551
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 COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 141 0 0 8139104865216 294172519680 57724063488 16238000000 710 5 292749 2076 0 0 192 0 3598 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2026-10-06 09:03:06.973504 2026-10-06 19:39:01.390207
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 11325 0 0 7603228414080 2822369472 671306688 3104953000000 113947 10 586834 52 0 0 10475 0 105343 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:12:29.831238 2026-10-06 20:06:59.489081
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL * 16934 0 0 7476184108224 1560102336 441350208 3095814000000 63849 4 390837 23 0 0 38127 0 102312 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:01:08.620581 2026-10-06 20:07:14.801554
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 14374 0 114 7449227113536 12569476608 518094720 4207388000000 569 0 54747 4 0 0 14419 0 12331 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:12:29.832683 2026-10-06 20:06:59.489845
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 9371 0 0 7417818937152 30145078080 791548992 3112685000000 476939 51 1605040 171 0 0 48 0 473660 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:12.324925 2026-10-06 20:06:53.481888
SHOW SESSION VARIABLES LIKE ? NULL * 4991 0 0 7179784335360 2486854656 1438474752 373205000000 4991 1 2889789 579 0 0 4991 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2026-10-06 08:09:57.961405 2026-10-06 20:07:18.802161
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 9850 0 0 6933641966784 2310369984 703722240 2974341000000 128557 13 650851 66 0 0 9025 0 117740 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:28.438222 2026-10-06 20:06:53.487772
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... mysql * 16728 0 26 6800957908992 6340149504 406441152 2767310000000 70165 4 397687 24 0 0 34187 0 102204 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 07:58:51.818954 2026-10-06 20:07:15.188124
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 6977 0 0 6476117506560 8492043456 928137600 2373619000000 446331 64 1135836 163 0 0 231 0 445432 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:12:26.213811 2026-10-06 20:06:59.424300
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 14601 0 0 6082200393984 1222648128 416415168 2433593000000 58535 4 359537 25 0 0 32185 0 87768 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:12:26.420122 2026-10-06 20:06:59.471197

|
|
|
Number of rows:
Filter rows:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query