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 | payment | fk_payment_rental | 64176 | 119729322768 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_inventory_id | 82500 | 31023838560 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 2 | 10083883920 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_store_id_film_id | 18332 | 5262182640 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | PRIMARY | 12 | 4117611168 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 762 | 3721273776 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 2803 | 3306740448 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 2 | 2259103968 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | idx_fk_film_id | 29 | 1743450720 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 111 | 1609287504 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 33 | 1426515024 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 2851 | 1310121120 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | ecurie | PRIMARY | 16 | 1187559120 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 8 | 1062296928 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | voiture | Id_ecurie | 10 | 712329024 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 3 | 511931904 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | PRIMARY | 30 | 215334768 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 33 | 186991728 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 25 | 159482400 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 204 | 155322288 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 3 | 75036192 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | Country | PRIMARY | 2 | 26323440 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
performance_schema | events_waits_summary_by_account_by_event_name | ACCOUNT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|