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 | 834288 | 1360865343552 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_inventory_id | 1072500 | 323539982832 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 3 | 67760856240 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_store_id_film_id | 187903 | 28917332928 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 61391 | 22135799664 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 11000 | 7865850960 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_category | fk_film_category_category | 11176 | 2493962064 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 262 | 2370772800 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 75 | 1398967680 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 87 | 767027184 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | idx_fk_address_id | 5 | 688916448 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 1 | 605768064 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | PRIMARY | 123 | 547654272 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 82 | 334094112 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 87 | 302913072 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 10 | 201754608 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 8 | 157694592 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 2 | 70590960 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 1 | 51427728 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 1 | 48172608 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | idx_fk_store_id | 1 | 29259120 | 0 | 0 | 0 | 0 | 0 | 0 | |
sku | Attore | PRIMARY | 1 | 10545216 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 0 | 0 | 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 |
|