SELECT * FROM `x$schema_index_statistics`
|
table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film_category | PRIMARY | 1485000 | 1237069932384 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 1386684 | 658303608336 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | PRIMARY | 1486800 | 244862655840 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 46215 | 21987064176 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | ecurie | PRIMARY | 20 | 4788793680 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 11 | 2131189104 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 25 | 1662815088 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 100 | 1605490128 | 0 | 0 | 0 | 0 | 0 | 0 | |
sku | Attore | PRIMARY | 9 | 1305091392 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 9 | 997494432 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | voiture | Id_ecurie | 17 | 946773696 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | pilote | PRIMARY | 4 | 929928912 | 0 | 0 | 0 | 0 | 0 | 0 | |
Table_insertion | ecurie | PRIMARY | 65 | 580235568 | 0 | 0 | 0 | 0 | 0 | 0 | |
Table_insertion | voiture | Id_ecurie | 24 | 452736768 | 0 | 0 | 0 | 0 | 0 | 0 | |
Table_insertion | pilote | PRIMARY | 23 | 375045264 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 16 | 298156320 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 401 | 183330048 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 4 | 116806272 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | City | PRIMARY | 4 | 75655008 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | Country | PRIMARY | 4 | 45351504 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 2 | 30975120 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
performance_schema | table_io_waits_summary_by_index_usage | OBJECT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespaces | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|