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.0150 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 15963 0 0 846892565678016 2106791451648 53053453440 689932000000 0 0 0 0 31855 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:23.687832 2026-10-06 12:35:43.802696
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern... phpmyadmin 1276 0 0 68464113007680 485567514432 53655219072 50598000000 0 0 0 0 2543 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:24.711752 2026-10-06 12:35:42.727926
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 120580 0 0 31871605461696 1562041728 264311424 16213741000000 118880 1 718379 6 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:12:29.899908 2026-10-06 12:35:43.744209
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 * 4157 0 19 10927876033152 8006366504448 2628707328 1459618000000 41613 10 286617 69 0 0 367 0 38438 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:01:02.943794 2026-10-06 12:21:28.996141
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL 5674 0 0 9734577832512 289514377152 1715530752 1838572000000 6641 1 81207 14 0 0 5674 0 6641 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:10:25.928426 2026-10-06 12:35:32.822574
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 11218 0 0 8268770397888 2171564928 736968960 3557514000000 198936 18 1059072 94 0 0 10399 0 186569 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:29.090878 2026-10-06 12:35:17.453686
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 80 0 0 7943553753408 779818440960 99294376896 10451000000 503 6 1102324 13779 0 0 213 23 38740 23 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2026-10-06 08:37:21.878632 2026-10-06 12:11:51.422829
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db * 16911 0 0 7053753500352 1293297408 416969280 2839522000000 66664 4 408403 24 0 0 37284 0 100608 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:10:21.686877 2026-10-06 12:35:17.433206
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 10083 0 0 6754685955264 4696099200 669644352 3480068000000 226818 22 1031488 102 0 0 77 0 216031 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:18.929984 2026-10-06 12:35:17.447243
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 23740 0 0 6576997197888 833384448 276778944 3373699000000 18433 1 126518 5 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:10:29.044349 2026-10-06 12:35:17.445948
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL * 14146 0 0 6238900219968 1560102336 440796096 2584318000000 53306 4 326347 23 0 0 31849 0 85416 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:01:08.620581 2026-10-06 12:35:28.839715
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 99 0 0 5915063314368 294172519680 59747957568 11836000000 484 5 209225 2113 0 0 140 0 2545 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2026-10-06 09:03:06.973504 2026-10-06 12:21:57.619730
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 6728 0 0 5426375595264 30145078080 806510016 2234866000000 346592 52 1162621 173 0 0 42 0 344249 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:12.324925 2026-10-06 12:35:32.866970
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 7100 0 0 5014870690752 2310369984 706215744 2133497000000 93934 13 473962 67 0 0 6456 0 85355 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:28.438222 2026-10-06 12:35:32.898474
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 7339 0 0 4888129207104 2214231552 666042624 2022178000000 72158 10 370917 51 0 0 6724 0 66094 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:12:29.831238 2026-10-06 12:35:43.747821
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 9240 0 84 4821744927168 10325600064 521696448 2703025000000 372 0 36896 4 0 0 9289 0 9894 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:12:29.832683 2026-10-06 12:35:43.748562
SELECT COUNT ( * ) AS `c` FROM ( SELECT `document_... simpedak_db * 151 0 0 4798310422464 63900749952 31776660864 33335000000 151 1 362 2 0 0 302 0 0 0 8586314de6146035fdf39233e80d7d1bade017e7566e476ac3... 2026-10-06 09:03:18.576000 2026-10-06 12:34:14.329897
SHOW SESSION VARIABLES LIKE ? NULL * 3346 0 0 4766885345664 2486854656 1424621952 248699000000 3346 1 1937334 579 0 0 3346 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2026-10-06 08:09:57.961405 2026-10-06 12:35:45.659459
SELECT `document_id` , `document_event_id` , `docu... simpedak_db * 151 0 0 4728938647680 35175306816 31317302016 23801000000 362 2 1959518 12977 0 0 151 0 362 0 76a75a5e759b4af598f59ae43eb8e53b98be9c5f925f1d7a33... 2026-10-06 09:03:18.606916 2026-10-06 12:34:14.361174
SELECT * FROM `INNODB_COLUMNS` LIMIT ?, ... information_schema * 9 0 0 4626690299712 597279264192 514076576832 36466000000 225 25 225 25 0 0 9 9 0 0 1512ccbc467635564d751a38813be9534f3a3cf75c1a1f59a8... 2026-10-06 08:58:43.005179 2026-10-06 12:21:13.466059
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... mysql * 11193 0 25 4567018809600 6340149504 407826432 1860819000000 47036 4 266857 24 0 0 22959 0 68868 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 07:58:51.818954 2026-10-06 12:35:29.266617
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... mysql 2409 0 0 4494531263040 630542053440 1865695104 774358000000 4932 2 55271 23 0 0 2409 0 4932 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:13:16.692591 2026-10-06 12:21:29.002005
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 4557 0 0 4358451883968 8492043456 956397312 1561627000000 298284 65 752577 165 0 0 214 0 297703 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:12:26.213811 2026-10-06 12:33:43.833565
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL 5691 0 0 4263434697600 6052011264 748882368 1396670000000 60958 11 326229 57 0 0 5690 0 60958 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:25.926742 2026-10-06 12:35:32.818975