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 | city | 6.79 ms | 135 | 6.79 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 6.76 ms | 0 | 0 bytes | 0 ps | 5 | 62.92 us | |
sakila | payment | 6.39 ms | 84 | 6.39 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 50 | 848.00 KiB | 14.58 ms | 0 | 0 bytes | 0 ps | 5 | 100.71 us | |
sakila | rental | 5.51 ms | 82 | 5.51 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 53 | 896.00 KiB | 13.33 ms | 0 | 0 bytes | 0 ps | 5 | 36.38 us | |
test19 | pilote | 4.47 ms | 110 | 4.47 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.61 ms | 0 | 0 bytes | 0 ps | 5 | 42.63 us | |
sku | Attore | 4.34 ms | 18 | 4.34 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.39 ms | 0 | 0 bytes | 0 ps | 5 | 61.18 us | |
sakila | film | 3.78 ms | 3135 | 3.78 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 3.54 ms | 0 | 0 bytes | 0 ps | 5 | 46.29 us | |
sakila | staff | 3.26 ms | 162 | 3.26 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 2.48 ms | 0 | 0 bytes | 0 ps | 5 | 28.99 us | |
sakila | customer | 3.00 ms | 150 | 3.00 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 2.17 ms | 0 | 0 bytes | 0 ps | 5 | 56.50 us | |
sakila | language | 2.81 ms | 125 | 2.81 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.29 ms | 0 | 0 bytes | 0 ps | 5 | 64.99 us | |
sakila | country | 1.60 ms | 151 | 1.60 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.14 ms | 0 | 0 bytes | 0 ps | 5 | 64.74 us | |
sakila | address | 1.10 ms | 8 | 1.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.43 ms | 0 | 0 bytes | 0 ps | 5 | 41.57 us | |
test19 | ecurie | 1.00 ms | 26 | 1.00 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.18 ms | 0 | 0 bytes | 0 ps | 5 | 63.06 us | |
sakila | actor | 997.12 us | 54 | 997.12 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.22 ms | 0 | 0 bytes | 0 ps | 5 | 48.74 us | |
sys | sys_config | 932.43 us | 28 | 932.43 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.07 ms | 0 | 0 bytes | 0 ps | 5 | 71.10 us | |
sakila | store | 902.81 us | 8 | 902.81 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.07 ms | 0 | 0 bytes | 0 ps | 5 | 50.99 us | |
world | Country | 570.29 us | 110 | 570.29 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 102 | 25.94 KiB | 1.04 ms | 0 | 0 bytes | 0 ps | 8 | 61.89 us | |
world | City | 556.99 us | 96 | 556.99 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 78 | 5.36 KiB | 950.17 us | 0 | 0 bytes | 0 ps | 11 | 19.24 ms | |
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 | |
mysql | tablespace_files | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|