Drop files here

SQL upload ( 0 ) x -

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:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `x$user_summary_by_statement_type`
user statement total total_latency max_latency lock_latency rows_sent rows_examined rows_affected full_scans
background select 1 3182001000 3182001000 0 1 1 0 0
pma show_tables 2164 441640680000 774106000 178152000000 0 0 0 0
pma Init DB 2164 207857285000 511338000 71016000000 0 0 0 0
pma Quit 2198 15292873000 43785000 0 0 0 0 0
root select 56069 25323193297000 706647406000 5339865000000 140581 1157217 0 13011
root alter_table 32 9333927094000 745826138000 25932000000 0 0 1907 0
root create_table 30 4134376765000 281169329000 12227000000 0 0 0 0
root show_keys 2306 3369193250000 1218477282000 1736854000000 1348 25321 0 0
root show_variables 2464 2142805152000 5279970000 218579000000 3566 1413664 0 2464
root show_fields 2535 1782775250000 4460779000 549933000000 52973 270400 0 0
root insert 27 817053161000 100576525000 41277000000 0 0 1291 0
root show_tables 1372 744904560000 5548043000 317062000000 15511 43586 0 0
root show_create_table 1248 565479964000 131159647000 830000000 0 0 0 0
root set_option 7948 535506282000 12640886000 0 0 0 0 0
root show_table_status 1526 401668208000 2150781000 27359000000 4 135 0 0
root create_db 8 397594689000 80089968000 2807000000 0 0 8 0
root jump_if_not 287785 168885828000 839952000 0 0 0 0 0
root Init DB 2137 119957942000 501516000 10911000000 0 0 0 0
root show_grants 1254 104467909000 830281000 0 0 0 0 0
root drop_user 3 93631725000 32145947000 4048000000 0 0 0 0
root freturn 70547 68810264000 632065000 0 0 0 0 0
root show_warnings 1092 34058692000 165187000 0 0 0 0 0
root Quit 3153 21912149000 221817000 0 0 0 0 0
root show_status 2 20570676000 19763839000 573000000 900 900 0 2
root show_master_status 103 17885032000 13157425000 0 0 0 0 0
Query results operations