Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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
Options
Set default
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$host_summary_by_statement_type`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
host statement total total_latency max_latency lock_latency rows_sent rows_examined rows_affected full_scans
192.168.30.20 select 3031 3015191569000 631667023000 532428000000 29248 91678 0 972
192.168.30.20 show_keys 59 369258152000 74768932000 32839000000 99 960 0 0
192.168.30.20 show_tables 883 280372337000 6227800000 134906000000 1431 6284 0 0
192.168.30.20 create_table 1 231571738000 231571738000 1361000000 0 0 0 0
192.168.30.20 create_db 3 194187774000 79676395000 713000000 0 0 3 0
192.168.30.20 show_variables 94 158636209000 12439041000 11442000000 1750 53788 0 94
192.168.30.20 show_fields 107 111773756000 3764184000 57068000000 573 3306 0 0
192.168.30.20 set_option 1108 110708552000 6709278000 0 0 0 0 0
192.168.30.20 grant 3 107731906000 44027104000 1390000000 0 0 0 0
192.168.30.20 alter_user 2 60668188000 30689000000 2564000000 0 0 0 0
192.168.30.20 revoke 2 54915647000 44561462000 1950000000 0 0 0 0
192.168.30.20 create_user 1 41205341000 41205341000 1105000000 0 0 0 0
192.168.30.20 Init DB 234 23089328000 574947000 4865000000 0 0 0 0
192.168.30.20 show_table_status 24 20622974000 5331192000 15325000000 0 93 0 0
192.168.30.20 Execute 45 15216367000 1150796000 6554000000 45 45 0 0
192.168.30.20 show_create_table 30 15011680000 5234926000 2330000000 0 0 0 0
192.168.30.20 Prepare 45 9895976000 1715895000 0 0 0 0 0
192.168.30.20 Quit 762 6016657000 61559000 0 0 0 0 0
192.168.30.20 show_grants 47 5992993000 258409000 0 0 0 0 0
192.168.30.20 show_status 3 5138986000 3202174000 523000000 1350 1350 0 3
192.168.30.20 error 42 3791620000 630609000 0 0 0 0 0
192.168.30.20 show_slave_status 44 3360740000 253251000 0 0 0 0 0
192.168.30.20 show_binlogs 26 3324168000 840062000 0 0 0 0 0
192.168.30.20 show_master_status 44 2434242000 200282000 0 0 0 0 0
192.168.30.20 show_warnings 20 1387444000 141887000 0 0 0 0 0
Query results operations