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 | film | idx_fk_language_id | 847 | 18992590320 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | megye | PRIMARY | 5 | 5476174704 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 1 | 3786185040 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 607 | 2646973824 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | idx_fk_film_id | 8 | 2483808096 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 1 | 2026714272 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_category | fk_film_category_category | 3 | 1999939392 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 800 | 604159248 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 2 | 446715984 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 201 | 381238704 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 8 | 326136096 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 26 | 268332768 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 25 | 216106176 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 29 | 214521120 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 25 | 171183936 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id_2 | 0 | 0 | 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 | |
mysql | index_column_usage | index_id_2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
performance_schema | status_by_account | ACCOUNT | 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 |
|