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 | actor | idx_actor_last_name | 2 | 3787786992 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 225 | 1907543616 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 77 | 1443659712 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 54 | 1372369680 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 2 | 817018752 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 2 | 750064128 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 1 | 464479488 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 1 | 461744976 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_text | PRIMARY | 1 | 347963616 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 25 | 266136288 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 25 | 237925776 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 10 | 177799248 | 0 | 0 | 0 | 0 | 0 | 0 | |
Jugostienda | Jugos | PRIMARY | 6 | 87354432 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 3 | 69528096 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 2 | 68622048 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 1 | 68462064 | 0 | 0 | 0 | 0 | 0 | 0 | |
Veterinaria_ColitaFeliz | Dinero | PRIMARY | 1 | 14468256 | 0 | 0 | 0 | 0 | 0 | 0 | |
Veterinaria_ColitaFeliz | Dueño | PRIMARY | 1 | 13295568 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | referenced_table_catalog | 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 | 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 |
|