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 payment 146590353888 48158 146590353888 0 0 0 0 0 0 67 1146880 19199979216 0 0 0 5 16921110624
sakila customer 73762362960 50 73762362960 0 0 0 0 0 0 8 180224 4736818416 0 0 0 5 78255936
sakila rental 30625554432 61901 30625554432 0 0 0 0 0 0 70 1196032 10567009728 0 0 0 5 20865504
Stefano vulcano 15884811888 2 15884811888 0 0 0 0 0 0 4 114688 1894300320 0 0 0 5 14165907888
sakila inventory 10543095552 14747 10543095552 0 0 0 0 0 0 15 294912 6642374640 0 0 0 5 21547152
vedettfak fa 5506076400 2 5506076400 0 0 0 0 0 0 5 131072 3166665216 0 0 0 5 2502085344
sakila film_text 4339408656 3 4339408656 0 0 0 0 0 0 4 565 637254288 0 0 0 9 49653120
sakila film 2349327024 1000 2349327024 0 0 0 0 0 0 15 294912 1489352832 0 0 0 5 25476528
sakila store 1822403088 6 1822403088 0 0 0 0 0 0 4 114688 1711759632 0 0 0 5 167332704
test19 ecurie 1725097968 1 1725097968 0 0 0 0 0 0 4 114688 941549136 0 0 0 5 1097630160
sakila staff 1694576928 58 1694576928 0 0 0 0 0 0 5 131072 1111189728 0 0 0 5 73162320
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ Кількість дзвінків кожного абонента 1474912032 25 1474912032 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL
sakila actor 1261551984 2 1261551984 0 0 0 0 0 0 4 114688 1237791984 0 0 0 5 102446784
sakila category 1041306288 17 1041306288 0 0 0 0 0 0 4 114688 801769056 0 0 0 5 428610864
sakila film_category 928374480 1016 928374480 0 0 0 0 0 0 4 114688 644230752 0 0 0 5 261059568
world Country 897597360 2 897597360 0 0 0 0 0 0 2 462 947545632 0 0 0 7 54479568
sakila address 884383104 7 884383104 0 0 0 0 0 0 5 131072 1067854128 0 0 0 5 24507120
test19 pilote 750765840 28 750765840 0 0 0 0 0 0 4 114688 900839808 0 0 0 5 50891280
sakila city 670575312 7 670575312 0 0 0 0 0 0 5 131072 803395296 0 0 0 5 19821648
sakila country 461072304 7 461072304 0 0 0 0 0 0 4 114688 616699248 0 0 0 5 39761568
world CountryLanguage 278692656 1 278692656 0 0 0 0 0 0 2 407 276683616 0 0 0 7 43102224
mysql dd_properties 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL
mysql schemata 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL
mysql tablespace_files 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL
mysql tablespaces 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL
Query results operations