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$schema_table_statistics`
table_schema table_name total_latency rows_fetched fetch_latency rows_inserted insert_latency rows_updated update_latency rows_deleted delete_latency io_read_requests io_read io_read_latency io_write_requests io_write io_write_latency io_misc_requests io_misc_latency
sakila film_category 961561367712 1155026 961561367712 0 0 0 0 0 0 8 180224 949795968 0 0 0 5 14497824
sakila film 507316866144 1078635 507316866144 0 0 0 0 0 0 16 311296 2921678496 0 0 0 5 32704848
sakila film_actor 191522841840 1156400 191522841840 0 0 0 0 0 0 15 294912 1568331072 0 0 0 5 20707104
sakila category 18076337664 35970 18076337664 0 0 0 0 0 0 4 114688 794401872 0 0 0 5 15278208
klo Vehicles 16383230688 167 1148030400 2 104079360 2 122981232 3 15008139696 0 0 0 12 294912 1361428992 11 312577630464
sakila city 4475890848 52 4475890848 0 0 0 0 0 0 7 163840 4586356896 0 0 0 5 76743744
klo RentalPoints 4049425248 139 3673533072 2 167606736 2 117934608 2 90350832 0 0 0 12 294912 1235876400 11 96086586816
klo ChangeLogs 3239701344 404 2314628448 24 925072896 0 0 0 0 0 0 0 11 278528 280102416 10 63077574384
sakila address 2750138160 79 2750138160 0 0 0 0 0 0 8 180224 2999472432 0 0 0 5 71538192
sakila actor 2482747872 2959 2482747872 0 0 0 0 0 0 5 131072 871883760 0 0 0 5 35538624
klo Parks 1959352560 215 1187329440 2 129895920 2 115862736 2 526264464 0 0 0 11 278528 1203308304 10 77800418256
Estudiantes Alumno 1789720944 54 962396160 3 827324784 0 0 0 0 0 0 0 10 262144 540299232 9 93607910880
sakila language 1405114656 75 1405114656 0 0 0 0 0 0 4 114688 991404480 0 0 0 5 55076736
sakila staff 1345699344 4 1345699344 0 0 0 0 0 0 4 114688 1365543168 0 0 0 5 59596944
klo Rentals 1273839072 97 966873600 2 118440960 2 75662400 2 112862112 0 0 0 12 294912 437170272 11 104374578528
sakila customer 1212794352 78 1212794352 0 0 0 0 0 0 9 196608 1484625648 0 0 0 5 54876096
sakila country 875147856 51 875147856 0 0 0 0 0 0 4 114688 872652000 0 0 0 5 41767968
sakila store 812968464 6 812968464 0 0 0 0 0 0 5 131072 858395472 0 0 0 5 35327952
Estudiantes modalidad 785895792 40 753290736 1 32605056 0 0 0 0 0 0 0 8 229376 408939696 7 72194529792
dbcnp tblorders 751554672 58 751554672 0 0 0 0 0 0 0 0 0 8 229376 432685968 7 62904152784
dbcnp tblcnp 663142656 56 663142656 0 0 0 0 0 0 0 0 0 7 212992 403990224 6 80689973232
dbcnp admininfo 662414544 35 662414544 0 0 0 0 0 0 0 0 0 7 212992 214667376 6 60504847392
sys sys_config 448379184 1 448379184 0 0 0 0 0 0 4 114688 733183440 0 0 0 5 38901456
А.С.Ю. Transports 139120608 3 65146752 2 73973856 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL
mysql dd_properties 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL
Query results operations