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 | 281906655888 | 208777 | 281906655888 | 0 | 0 | 0 | 0 | 0 | 0 | 76 | 1294336 | 19967278848 | 0 | 0 | 0 | 5 | 13015728 | |
sakila | rental | 48363105120 | 123776 | 48363105120 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 1196032 | 12808709760 | 0 | 0 | 0 | 5 | 13631376 | |
terra | stadt | 19756552992 | 0 | 0 | 728 | 19756552992 | 0 | 0 | 0 | 0 | 2 | 399 | 22334400 | 741 | 25294 | 13282493664 | 11 | 92086368 | |
sakila | inventory | 15493410768 | 33486 | 15493410768 | 0 | 0 | 0 | 0 | 0 | 0 | 19 | 360448 | 3710270784 | 0 | 0 | 0 | 5 | 18262992 | |
sakila | film | 7977685584 | 6103 | 7977685584 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2845535088 | 0 | 0 | 0 | 5 | 16328928 | |
sakila | staff | 7898060016 | 249 | 7898060016 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 66613509072 | 0 | 0 | 0 | 5 | 46040016 | |
terra | landteil | 5946337584 | 0 | 0 | 580 | 5946337584 | 0 | 0 | 0 | 0 | 2 | 421 | 10311312 | 594 | 23016 | 4494292704 | 12 | 12675278880 | |
terra | ist_mitglied_von | 4733165184 | 0 | 0 | 957 | 4733165184 | 0 | 0 | 0 | 0 | 2 | 393 | 13100208 | 967 | 27484 | 1188118272 | 12 | 98367456 | |
sakila | category | 4128046032 | 127 | 4128046032 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3993262944 | 0 | 0 | 0 | 5 | 36732432 | |
terra | land | 2917631376 | 138 | 376223232 | 189 | 2541408144 | 0 | 0 | 0 | 0 | 252 | 5514 | 131376960 | 202 | 8414 | 834384672 | 140 | 2151446352 | |
sakila | film_text | 2818694736 | 26 | 2818694736 | 0 | 0 | 0 | 0 | 0 | 0 | 52 | 3415 | 2711079888 | 0 | 0 | 0 | 33 | 115968864 | |
terra | umfasst | 2262326880 | 0 | 0 | 189 | 2262326880 | 0 | 0 | 0 | 0 | 2 | 393 | 22341792 | 199 | 4348 | 772601808 | 12 | 168374976 | |
terra | berg | 2088192480 | 217 | 365528592 | 105 | 1722663888 | 0 | 0 | 0 | 0 | 412 | 9552 | 141940128 | 118 | 5178 | 624902256 | 221 | 796248816 | |
sakila | film_category | 1738216128 | 6122 | 1738216128 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 824909184 | 0 | 0 | 0 | 5 | 20787888 | |
terra | fluss | 1655326992 | 0 | 0 | 136 | 1655326992 | 0 | 0 | 0 | 0 | 2 | 420 | 12419088 | 152 | 7063 | 253307472 | 11 | 914755248 | |
sakila | customer | 1295136480 | 150 | 1295136480 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 1516426560 | 0 | 0 | 0 | 5 | 29276544 | |
terra | geo_meer | 1132876272 | 0 | 0 | 344 | 1132876272 | 0 | 0 | 0 | 0 | 2 | 415 | 11881056 | 355 | 9702 | 494998416 | 13 | 2611147968 | |
terra | ist_benachbart_zu | 1092905616 | 0 | 0 | 397 | 1092905616 | 0 | 0 | 0 | 0 | 2 | 386 | 9179808 | 406 | 8445 | 343808784 | 12 | 90214608 | |
terra | geht_ueber_in | 1072998432 | 0 | 0 | 39 | 1072998432 | 0 | 0 | 0 | 0 | 2 | 386 | 23245200 | 48 | 1905 | 73320720 | 12 | 476221680 | |
terra | geo_insel | 927836976 | 0 | 0 | 175 | 927836976 | 0 | 0 | 0 | 0 | 2 | 415 | 11255376 | 186 | 4294 | 318934176 | 13 | 109440672 | |
terra | geo_fluss | 837990912 | 0 | 0 | 286 | 837990912 | 0 | 0 | 0 | 0 | 2 | 415 | 6819120 | 297 | 6858 | 251979552 | 13 | 97495200 | |
sakila | city | 721175136 | 253 | 721175136 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1533964608 | 0 | 0 | 0 | 5 | 29687328 | |
sakila | address | 633739392 | 31 | 633739392 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 2344027488 | 0 | 0 | 0 | 5 | 48933456 | |
sakila | store | 520567872 | 3 | 520567872 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 7090554240 | 0 | 0 | 0 | 5 | 54898272 | |
terra | liegt_an | 512526432 | 0 | 0 | 356 | 512526432 | 0 | 0 | 0 | 0 | 2 | 349 | 12088560 | 367 | 12440 | 620866752 | 10 | 936805584 |
|