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 | address | 5.93 ms | 30 | 5.93 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 5.87 ms | 0 | 0 bytes | 0 ps | 5 | 35.47 us | |
sakila | staff | 5.47 ms | 4 | 5.47 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 5.41 ms | 0 | 0 bytes | 0 ps | 5 | 106.89 us | |
sakila | rental | 4.20 ms | 2 | 4.20 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 4.28 ms | 0 | 0 bytes | 0 ps | 5 | 47.39 us | |
test19 | ecurie | 3.97 ms | 2 | 3.97 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.13 ms | 0 | 0 bytes | 0 ps | 5 | 60.66 us | |
sakila | language | 2.01 ms | 125 | 2.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 916.94 us | 0 | 0 bytes | 0 ps | 5 | 408.66 us | |
sakila | film | 1.49 ms | 130 | 1.49 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.39 ms | 0 | 0 bytes | 0 ps | 5 | 39.63 us | |
sakila | country | 1.29 ms | 79 | 1.29 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 955.68 us | 0 | 0 bytes | 0 ps | 5 | 38.83 us | |
sakila | customer | 1.24 ms | 26 | 1.24 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 1.54 ms | 0 | 0 bytes | 0 ps | 5 | 56.32 us | |
sakila | city | 1.08 ms | 52 | 1.08 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.27 ms | 0 | 0 bytes | 0 ps | 5 | 36.15 us | |
Stefano | vulcano | 1.08 ms | 5 | 1.08 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 844.40 us | 0 | 0 bytes | 0 ps | 5 | 519.61 us | |
test19 | voiture | 983.50 us | 3 | 983.50 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.12 ms | 0 | 0 bytes | 0 ps | 5 | 98.67 us | |
test19 | pilote | 843.04 us | 2 | 843.04 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 770.84 us | 0 | 0 bytes | 0 ps | 5 | 305.71 us | |
sakila | store | 821.97 us | 5 | 821.97 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 860.48 us | 0 | 0 bytes | 0 ps | 5 | 45.40 us | |
sakila | actor | 753.37 us | 2 | 753.37 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.00 ms | 0 | 0 bytes | 0 ps | 5 | 36.70 us | |
world | Country | 34.60 us | 2 | 34.60 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 462 bytes | 246.15 us | 0 | 0 bytes | 0 ps | 5 | 27.51 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 | |
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 | |
mysql | foreign_keys | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_column_usage | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|