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 | |
---|---|---|---|---|---|---|---|---|---|---|---|
vedettfak | fa | megyeid | 3 | 4262056128 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | megye | PRIMARY | 65 | 2838891792 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 200 | 2180051808 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | PRIMARY | 50 | 1966035456 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 127 | 1928116608 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 7 | 1638516000 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 54 | 1204864848 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 409 | 927989040 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 7 | 903282336 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 75 | 655137648 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 4 | 501869280 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 1 | 300131040 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 33 | 283942032 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 11 | 217503792 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 6 | 144968208 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | idx_fk_store_id | 6 | 123483360 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 6 | 116738688 | 0 | 0 | 0 | 0 | 0 | 0 | |
sku | Attore | PRIMARY | 6 | 79595472 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | City | PRIMARY | 1 | 32033232 | 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 | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|