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 1751 349828655000 774106000 141122000000 0 0 0 0
pma Init DB 1751 163530791000 511338000 55805000000 0 0 0 0
pma Quit 1783 12452690000 43785000 0 0 0 0 0
root select 47857 23141014657000 706647406000 5162968000000 134858 1055704 0 11884
root alter_table 32 9333927094000 745826138000 25932000000 0 0 1907 0
root create_table 28 3852751948000 269087361000 12069000000 0 0 0 0
root show_keys 1924 3283428310000 1218477282000 1736854000000 1348 25321 0 0
root show_variables 2008 1748568322000 5279970000 178904000000 3110 1151941 0 2008
root show_fields 2069 1620159735000 4460779000 548576000000 52973 270400 0 0
root insert 27 817053161000 100576525000 41277000000 0 0 1291 0
root show_tables 1146 666571116000 5548043000 305603000000 15511 43586 0 0
root show_create_table 1017 523971287000 131159647000 482000000 0 0 0 0
root set_option 6467 434623242000 12640886000 0 0 0 0 0
root create_db 8 397594689000 80089968000 2807000000 0 0 8 0
root show_table_status 1019 268136260000 2150781000 25054000000 4 135 0 0
root Init DB 1747 97021993000 501516000 8855000000 0 0 0 0
root jump_if_not 158213 95920149000 839952000 0 0 0 0 0
root drop_user 3 93631725000 32145947000 4048000000 0 0 0 0
root show_grants 1020 84048950000 830281000 0 0 0 0 0
root freturn 39737 41940817000 632065000 0 0 0 0 0
root show_warnings 896 28166268000 165187000 0 0 0 0 0
root show_status 2 20570676000 19763839000 573000000 900 900 0 2
root Quit 2564 17740538000 221817000 0 0 0 0 0
root show_master_status 92 17427367000 13157425000 0 0 0 0 0
Query results operations