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 | film_category | 1.36 s | 1485000 | 1.36 s | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.20 ms | 0 | 0 bytes | 0 ps | 5 | 24.22 us | |
sakila | film | 736.25 ms | 1387351 | 736.25 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.69 ms | 0 | 0 bytes | 0 ps | 5 | 37.20 us | |
sakila | film_actor | 261.86 ms | 1486882 | 261.86 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 17 | 320.00 KiB | 1.96 ms | 0 | 0 bytes | 0 ps | 5 | 30.57 us | |
sakila | category | 26.01 ms | 46294 | 26.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 968.64 us | 0 | 0 bytes | 0 ps | 5 | 38.14 us | |
sakila | city | 5.64 ms | 569 | 5.64 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 4.36 ms | 0 | 0 bytes | 0 ps | 5 | 55.83 us | |
sakila | rental | 4.91 ms | 363 | 4.91 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 53 | 896.00 KiB | 9.65 ms | 0 | 0 bytes | 0 ps | 5 | 43.84 us | |
sakila | store | 4.37 ms | 56 | 4.37 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 4.17 ms | 0 | 0 bytes | 0 ps | 5 | 48.94 us | |
test19 | voiture | 4.19 ms | 71 | 4.19 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 4.06 ms | 0 | 0 bytes | 0 ps | 5 | 55.73 us | |
sakila | staff | 3.77 ms | 203 | 3.77 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.03 ms | 0 | 0 bytes | 0 ps | 5 | 35.45 us | |
sakila | customer | 3.69 ms | 892 | 3.69 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 10 | 208.00 KiB | 2.31 ms | 0 | 0 bytes | 0 ps | 5 | 36.37 us | |
sakila | actor | 3.50 ms | 1967 | 3.50 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 979.53 us | 0 | 0 bytes | 0 ps | 5 | 42.42 us | |
sakila | address | 3.23 ms | 1215 | 3.23 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.65 ms | 0 | 0 bytes | 0 ps | 5 | 39.63 us | |
test19 | ecurie | 2.41 ms | 92 | 2.41 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.16 ms | 0 | 0 bytes | 0 ps | 5 | 47.56 us | |
sakila | language | 2.18 ms | 261 | 2.18 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 708.65 us | 0 | 0 bytes | 0 ps | 5 | 49.94 us | |
sakila | payment | 2.10 ms | 87 | 2.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 50 | 848.00 KiB | 7.93 ms | 0 | 0 bytes | 0 ps | 5 | 39.11 us | |
sakila | inventory | 1.90 ms | 441 | 1.90 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 2.39 ms | 0 | 0 bytes | 0 ps | 5 | 78.21 us | |
sakila | country | 1.87 ms | 563 | 1.87 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 923.53 us | 0 | 0 bytes | 0 ps | 5 | 39.17 us | |
sku | Attore | 1.52 ms | 7 | 1.52 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 822.61 us | 0 | 0 bytes | 0 ps | 5 | 443.10 us | |
test19 | pilote | 982.28 us | 80 | 982.28 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.11 ms | 0 | 0 bytes | 0 ps | 5 | 50.83 us | |
sys | sys_config | 794.61 us | 33 | 794.61 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 899.92 us | 0 | 0 bytes | 0 ps | 5 | 43.05 us | |
sakila | film_text | 758.74 us | 117 | 758.74 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 204 | 12.17 KiB | 1.49 ms | 0 | 0 bytes | 0 ps | 113 | 143.95 us | |
world | Country | 393.75 us | 54 | 393.75 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 52 | 13.20 KiB | 667.07 us | 0 | 0 bytes | 0 ps | 6 | 70.04 us | |
Stefano | vulcano | 258.90 us | 31 | 258.90 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 947.70 us | 0 | 0 bytes | 0 ps | 5 | 384.91 us | |
world | City | 57.18 us | 6 | 57.18 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 392 bytes | 328.47 us | 0 | 0 bytes | 0 ps | 6 | 36.55 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 |
|