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 | city | PRIMARY | 25 | 3735353424 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 59 | 2216574096 | 0 | 0 | 0 | 0 | 0 | 0 | |
kupa | csapat | PRIMARY | 943 | 2047156848 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | idx_fk_film_id | 3 | 1289392896 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 200 | 1015197216 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 200 | 833021904 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 1 | 760659504 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 50 | 581405088 | 0 | 0 | 0 | 0 | 0 | 0 | |
kupa | meccs | PRIMARY | 17 | 251754624 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | PRIMARY | 25 | 175021968 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 25 | 150417168 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 1 | 53660112 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | index_column_usage | index_id_2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | index_column_usage | index_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_key_column_usage | column_id | 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 | |
performance_schema | table_io_waits_summary_by_index_usage | OBJECT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | check_constraints | 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 |
|