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`
[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 17528 0 0 953438407391808 2106791451648 54394958592 756937000000 0 0 0 0 34980 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:23.687832 2026-10-06 14:42:24.728065
REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern... phpmyadmin 1663 0 0 92715173501184 485567514432 55751701824 65842000000 0 0 0 0 3317 2 0 0 0 0 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... 2026-10-06 08:10:24.711752 2026-10-06 14:41:59.377005
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 140653 0 0 37140447846528 1562041728 264034368 18889635000000 138640 1 837878 6 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:12:29.899908 2026-10-06 14:42:24.678532
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 * 4680 0 19 11272041368640 8006366504448 2408447808 1644162000000 46100 10 321569 69 0 0 380 0 42570 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:01:02.943794 2026-10-06 14:42:14.769795
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL 6333 0 0 10094138061696 289514377152 1593626112 2031611000000 7771 1 92833 15 0 0 6333 0 7771 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:10:25.928426 2026-10-06 14:42:04.755808
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 99 0 0 9510093762624 779818440960 96061410432 12174000000 628 6 1310382 13236 0 0 259 28 49478 28 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2026-10-06 08:37:21.878632 2026-10-06 14:40:15.691974
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 12007 0 0 8821405966464 2171564928 734475456 3801438000000 209106 17 1112875 93 0 0 11154 0 196434 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:29.090878 2026-10-06 14:42:02.771639
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db * 18316 0 0 7635981697344 1293297408 416692224 3073225000000 72293 4 442475 24 0 0 40359 0 108888 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:10:21.686877 2026-10-06 14:42:02.751688
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 27366 0 0 7566242546304 833384448 276224832 3879533000000 21487 1 146558 5 0 0 0 0 0 0 513931926a5cef8e76cd0f4279226f8e729f2ee6a83827c0b6... 2026-10-06 08:10:29.044349 2026-10-06 14:42:02.763904
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... simpedak_db 10840 0 0 7259185537344 4696099200 669644352 3743193000000 242313 22 1107411 102 0 0 82 0 230868 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:18.929984 2026-10-06 14:42:02.765206
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL * 14917 0 0 6576932366784 1560102336 440796096 2723645000000 56233 4 344303 23 0 0 33587 0 90120 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 08:01:08.620581 2026-10-06 14:42:04.731914
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... information_schema * 253 0 0 6205333223232 1027831491648 24526936512 79071000000 427 2 5422 21 0 0 226 0 0 0 6b962281752cce8cb8541a21b1d4e4db06b701224fba881b1f... 2026-10-06 08:10:24.443675 2026-10-06 14:41:43.725166
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 104 0 0 6192146188800 294172519680 59539611456 12589000000 509 5 219917 2115 0 0 146 0 2680 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2026-10-06 09:03:06.973504 2026-10-06 14:07:29.710767
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 7725 0 0 6149827824192 30145078080 795981888 2564911000000 393183 51 1319391 171 0 0 43 0 390440 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:10:12.324925 2026-10-06 14:42:21.807998
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... performance_schema 8130 0 0 5718846991104 2310369984 703168128 2461539000000 105508 13 533680 66 0 0 7430 0 96308 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:28.438222 2026-10-06 14:41:56.630158
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 8544 0 0 5698797279552 2214231552 666873792 2340081000000 85332 10 439164 51 0 0 7880 0 78640 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:12:29.831238 2026-10-06 14:42:24.683073
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys * 10730 0 84 5576168969280 10325600064 519480000 3137896000000 402 0 41424 4 0 0 10780 0 10544 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:12:29.832683 2026-10-06 14:42:24.683820
SHOW SESSION VARIABLES LIKE ? NULL * 3883 0 0 5551234760448 2486854656 1429608960 289614000000 3883 1 2248257 579 0 0 3883 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2026-10-06 08:09:57.961405 2026-10-06 14:42:27.797476
SELECT COUNT ( * ) AS `c` FROM ( SELECT `document_... simpedak_db * 164 0 0 5204377548864 63900749952 31733994240 35883000000 164 1 377 2 0 0 328 0 0 0 8586314de6146035fdf39233e80d7d1bade017e7566e476ac3... 2026-10-06 09:03:18.576000 2026-10-06 14:36:49.674394
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... mysql * 12675 0 26 5161853608704 6340149504 406995264 2102652000000 53289 4 301961 24 0 0 25959 0 77772 0 f99d3ab026388b996576df9a037e7ae64515b921778806312a... 2026-10-06 07:58:51.818954 2026-10-06 14:42:14.754331
SELECT `document_id` , `document_event_id` , `docu... simpedak_db * 164 0 0 5133345377472 35175306816 31300678656 25835000000 377 2 2128687 12980 0 0 164 0 377 0 76a75a5e759b4af598f59ae43eb8e53b98be9c5f925f1d7a33... 2026-10-06 09:03:18.606916 2026-10-06 14:36:49.705512
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... sys 5232 0 0 4922670886848 8492043456 940605120 1791381000000 336359 64 847704 162 0 0 218 0 335643 0 c0d9adc65303cbad4ff4e71fab7bb4f071392ea4456d3d741c... 2026-10-06 08:12:26.213811 2026-10-06 14:42:19.819576
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... NULL 6350 0 0 4737259470528 6052011264 745834752 1511301000000 68678 11 367354 58 0 0 6349 0 68678 0 d729cc74b9ca9bf3f11493ec73f93430c3a0d05a09b1141a61... 2026-10-06 08:10:25.926742 2026-10-06 14:42:04.754157
SELECT ( `cat` . `name` COLLATE `utf8_tolower_ci` ... mysql 2759 0 0 4695577226496 630542053440 1701677952 882071000000 5517 2 62137 23 0 0 2759 0 5517 0 65ac3bed35307c7b61b3d7f2ea0f6e94a087f4a2c830cd7d4d... 2026-10-06 08:13:16.692591 2026-10-06 14:42:14.777709

|
|
|
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