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 | 32088 | 72418708560 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_inventory_id | 41250 | 19046706624 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | PRIMARY | 6 | 4090345776 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_store_id_film_id | 9166 | 4073452944 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 402 | 2743694448 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 487 | 2130436704 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 29 | 1413669840 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | idx_fk_film_id | 5 | 1378479168 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | ecurie | PRIMARY | 16 | 1187559120 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 63 | 1136281872 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 4 | 1047210384 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | voiture | Id_ecurie | 10 | 712329024 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 438 | 655345152 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | PRIMARY | 27 | 198533280 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 25 | 159482400 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 3 | 75036192 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 2 | 64897008 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | Country | PRIMARY | 2 | 26323440 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 4 | 16683216 | 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 | |
mysql | column_type_elements | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespaces | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespace_files | file_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|