SELECT * FROM `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 | 16.99 ms | 16049 | 16.99 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 48 | 816.00 KiB | 5.36 ms | 0 | 0 bytes | 0 ps | 5 | 31.00 us | |
sakila | rental | 16.85 ms | 16044 | 16.85 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 51 | 864.00 KiB | 7.26 ms | 0 | 0 bytes | 0 ps | 5 | 33.80 us | |
sakila | film_category | 14.36 ms | 1000 | 14.36 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.16 ms | 0 | 0 bytes | 0 ps | 5 | 13.11 ms | |
world | City | 5.91 ms | 4079 | 5.91 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4081 | 267.27 KiB | 5.53 ms | 0 | 0 bytes | 0 ps | 4 | 19.73 us | |
sakila | film_actor | 4.77 ms | 5462 | 4.77 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 15 | 288.00 KiB | 1.56 ms | 0 | 0 bytes | 0 ps | 5 | 49.18 us | |
sakila | film | 4.38 ms | 1000 | 4.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 15 | 288.00 KiB | 1.87 ms | 0 | 0 bytes | 0 ps | 5 | 33.97 us | |
sakila | inventory | 3.97 ms | 4581 | 3.97 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 14 | 272.00 KiB | 1.97 ms | 0 | 0 bytes | 0 ps | 5 | 34.09 us | |
vedettfak | fa | 2.92 ms | 1258 | 2.92 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 10 | 208.00 KiB | 1.90 ms | 0 | 0 bytes | 0 ps | 5 | 37.99 us | |
Stefano | vulcano | 2.70 ms | 4 | 2.70 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.70 ms | 0 | 0 bytes | 0 ps | 5 | 35.05 us | |
sakila | customer | 1.96 ms | 599 | 1.96 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.62 ms | 0 | 0 bytes | 0 ps | 5 | 40.26 us | |
Table_insertion | ecurie | 1.94 ms | 4 | 1.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.19 ms | 0 | 0 bytes | 0 ps | 5 | 40.97 us | |
sakila | address | 1.83 ms | 603 | 1.83 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.43 ms | 0 | 0 bytes | 0 ps | 5 | 41.29 us | |
world | Country | 1.78 ms | 239 | 1.78 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 241 | 61.37 KiB | 1.74 ms | 0 | 0 bytes | 0 ps | 4 | 17.15 us | |
sakila | country | 1.56 ms | 135 | 1.56 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.41 ms | 0 | 0 bytes | 0 ps | 5 | 68.36 us | |
sakila | film_text | 1.41 ms | 1000 | 1.41 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2002 | 116.49 KiB | 2.17 ms | 0 | 0 bytes | 0 ps | 1004 | 190.42 us | |
sakila | staff | 1.30 ms | 2 | 1.30 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.41 ms | 0 | 0 bytes | 0 ps | 5 | 34.98 us | |
world | CountryLanguage | 1.21 ms | 984 | 1.21 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 986 | 37.87 KiB | 1.08 ms | 0 | 0 bytes | 0 ps | 4 | 28.37 us | |
sakila | city | 1.08 ms | 626 | 1.08 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.06 ms | 0 | 0 bytes | 0 ps | 5 | 51.18 us | |
Table_insertion | voiture | 1.06 ms | 14 | 1.06 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.08 ms | 0 | 0 bytes | 0 ps | 5 | 30.86 us | |
TlapaleriaMalfoy | Registro | 989.06 us | 9 | 989.06 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.13 ms | 0 | 0 bytes | 0 ps | 5 | 51.63 us | |
sakila | actor | 804.84 us | 200 | 804.84 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 950.02 us | 0 | 0 bytes | 0 ps | 5 | 60.16 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 777.05 us | 3 | 777.05 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | store | 758.48 us | 2 | 758.48 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 940.61 us | 0 | 0 bytes | 0 ps | 5 | 29.25 us | |
sakila | language | 746.05 us | 6 | 746.05 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 857.79 us | 0 | 0 bytes | 0 ps | 5 | 59.67 us | |
test19 | voiture | 727.38 us | 14 | 727.38 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 950.42 us | 0 | 0 bytes | 0 ps | 5 | 40.72 us |
|