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 | 48132 | 148244047248 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_inventory_id | 61875 | 29594634960 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 16745 | 8753963856 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 3000 | 4343244576 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_address_id | 26 | 1349039472 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 54 | 1250152992 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 8 | 1078623216 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_category | fk_film_category_category | 3050 | 1058233968 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 25 | 976861776 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 38 | 973418160 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 201 | 652811280 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 76 | 488902128 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 3 | 481614144 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 25 | 272564160 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 2 | 74053056 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | Country | PRIMARY | 3 | 50457792 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | index_column_usage | index_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mydb | data_atualizacao | fk_data_atualizacao_jogo1_idx | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id_2 | 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 | |
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 | tablespace_files | file_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|