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 | 169.82 ms | 96279 | 169.82 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 67 | 1.09 MiB | 11.10 ms | 0 | 0 bytes | 0 ps | 5 | 35.25 us | |
sakila | rental | 114.01 ms | 119773 | 114.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 70 | 1.14 MiB | 68.06 ms | 0 | 0 bytes | 0 ps | 5 | 66.50 us | |
sakila | inventory | 24.92 ms | 42093 | 24.92 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 23 | 416.00 KiB | 7.30 ms | 0 | 0 bytes | 0 ps | 5 | 38.73 us | |
sakila | film_actor | 9.13 ms | 6119 | 9.13 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 17 | 320.00 KiB | 5.44 ms | 0 | 0 bytes | 0 ps | 5 | 43.23 us | |
sakila | film | 6.96 ms | 3841 | 6.96 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 2.95 ms | 0 | 0 bytes | 0 ps | 5 | 38.26 us | |
sakila | language | 5.88 ms | 2206 | 5.88 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 734.67 us | 0 | 0 bytes | 0 ps | 5 | 58.08 us | |
sakila | customer | 4.95 ms | 3688 | 4.95 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 1.61 ms | 0 | 0 bytes | 0 ps | 5 | 56.75 us | |
sakila | address | 4.85 ms | 2006 | 4.85 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.05 ms | 0 | 0 bytes | 0 ps | 5 | 47.27 us | |
sakila | country | 4.13 ms | 93 | 4.13 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 3.89 ms | 0 | 0 bytes | 0 ps | 5 | 48.74 us | |
test19 | ecurie | 4.04 ms | 4 | 4.04 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.47 ms | 0 | 0 bytes | 0 ps | 5 | 1.74 ms | |
sakila | staff | 3.99 ms | 315 | 3.99 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.88 ms | 0 | 0 bytes | 0 ps | 5 | 55.72 us | |
vedettfak | megye | 2.88 ms | 44 | 2.88 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 699.44 us | 0 | 0 bytes | 0 ps | 5 | 197.05 us | |
test19 | voiture | 2.18 ms | 3 | 2.18 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.38 ms | 0 | 0 bytes | 0 ps | 5 | 59.36 us | |
sakila | city | 2.15 ms | 115 | 2.15 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.28 ms | 0 | 0 bytes | 0 ps | 5 | 64.57 us | |
sakila | store | 1.75 ms | 221 | 1.75 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 697.00 us | 0 | 0 bytes | 0 ps | 5 | 35.82 us | |
vedettfak | fa | 1.55 ms | 6 | 1.55 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 12 | 240.00 KiB | 2.32 ms | 0 | 0 bytes | 0 ps | 5 | 303.00 us | |
sakila | actor | 1.42 ms | 341 | 1.42 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.02 ms | 0 | 0 bytes | 0 ps | 5 | 77.62 us | |
Stefano | vulcano | 854.86 us | 3 | 854.86 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 847.23 us | 0 | 0 bytes | 0 ps | 5 | 286.24 us | |
world | City | 793.55 us | 27 | 793.55 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 27 | 2.02 KiB | 906.53 us | 0 | 0 bytes | 0 ps | 6 | 41.92 us | |
test19 | pilote | 726.97 us | 4 | 726.97 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 881.22 us | 0 | 0 bytes | 0 ps | 5 | 50.02 us | |
sakila | category | 691.34 us | 3 | 691.34 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 838.88 us | 0 | 0 bytes | 0 ps | 5 | 35.88 us | |
Table_insertion | pilote | 639.04 us | 27 | 639.04 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 849.75 us | 0 | 0 bytes | 0 ps | 5 | 39.41 us | |
world | CountryLanguage | 350.47 us | 54 | 350.47 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 52 | 2.30 KiB | 547.17 us | 0 | 0 bytes | 0 ps | 8 | 46.72 us | |
world | Country | 334.81 us | 4 | 334.81 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 462 bytes | 172.30 us | 0 | 0 bytes | 0 ps | 6 | 41.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 |
|