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 | 915.61 ms | 272751 | 915.61 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 67 | 1.09 MiB | 11.93 ms | 0 | 0 bytes | 0 ps | 5 | 43.05 us | |
sakila | rental | 175.64 ms | 350629 | 175.64 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 70 | 1.14 MiB | 6.06 ms | 0 | 0 bytes | 0 ps | 5 | 40.61 us | |
sakila | inventory | 42.33 ms | 88091 | 42.33 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 15 | 288.00 KiB | 3.25 ms | 0 | 0 bytes | 0 ps | 5 | 22.73 us | |
sakila | country | 27.06 ms | 50 | 27.06 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 26.00 ms | 0 | 0 bytes | 0 ps | 5 | 110.62 us | |
sakila | film | 14.46 ms | 10081 | 14.46 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.70 ms | 0 | 0 bytes | 0 ps | 5 | 57.55 us | |
sakila | language | 4.45 ms | 75 | 4.45 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.06 ms | 0 | 0 bytes | 0 ps | 5 | 66.37 us | |
sakila | customer | 3.79 ms | 212 | 3.79 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 10 | 208.00 KiB | 6.45 ms | 0 | 0 bytes | 0 ps | 5 | 50.29 us | |
world | CountryLanguage | 3.64 ms | 27 | 3.64 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 485 bytes | 3.46 ms | 0 | 0 bytes | 0 ps | 14 | 109.53 us | |
sakila | film_category | 3.10 ms | 10160 | 3.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 549.31 us | 0 | 0 bytes | 0 ps | 5 | 20.40 us | |
sakila | city | 2.61 ms | 47 | 2.61 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 4.56 ms | 0 | 0 bytes | 0 ps | 5 | 44.44 us | |
sakila | address | 1.06 ms | 45 | 1.06 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 1.68 ms | 0 | 0 bytes | 0 ps | 5 | 38.31 us | |
sakila | category | 917.70 us | 187 | 917.70 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 917.43 us | 0 | 0 bytes | 0 ps | 5 | 45.06 us | |
test19 | voiture | 829.72 us | 5 | 829.72 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 2.80 ms | 0 | 0 bytes | 0 ps | 5 | 41.91 us | |
sys | sys_config | 731.29 us | 1 | 731.29 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 965.29 us | 0 | 0 bytes | 0 ps | 5 | 47.12 us | |
sakila | film_text | 291.86 us | 1 | 291.86 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 442 bytes | 2.36 ms | 0 | 0 bytes | 0 ps | 4 | 31.43 us | |
sakila | staff | 203.44 us | 23 | 203.44 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 917.46 us | 0 | 0 bytes | 0 ps | 5 | 35.26 us | |
sakila | store | 159.73 us | 22 | 159.73 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 839.34 us | 0 | 0 bytes | 0 ps | 5 | 44.61 us | |
vedettfak | fa | 101.09 us | 1 | 101.09 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 12 | 240.00 KiB | 1.85 ms | 0 | 0 bytes | 0 ps | 5 | 39.75 us | |
world | Country | 33.70 us | 1 | 33.70 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 462 bytes | 467.02 us | 0 | 0 bytes | 0 ps | 4 | 31.28 us | |
world | City | 23.46 us | 1 | 23.46 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 392 bytes | 595.46 us | 0 | 0 bytes | 0 ps | 4 | 25.55 us | |
sku | Attore | 18.16 us | 1 | 18.16 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 739.33 us | 0 | 0 bytes | 0 ps | 5 | 199.73 us | |
test19 | pilote | 18.11 us | 1 | 18.11 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 991.25 us | 0 | 0 bytes | 0 ps | 5 | 44.46 us | |
test19 | ecurie | 9.27 us | 1 | 9.27 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 893.55 us | 0 | 0 bytes | 0 ps | 5 | 50.27 us | |
mysql | dd_properties | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|