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 | 32088 | 74749320096 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_store_id_film_id | 9166 | 21545762832 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_inventory_id | 41250 | 18063298176 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 75 | 4289876976 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | PRIMARY | 25 | 1347284400 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | megye | PRIMARY | 2 | 1030008144 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 30 | 967603824 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 12 | 896571456 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_address_id | 2 | 864006000 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 7 | 655121808 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 8 | 533809056 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 3 | 511285104 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 25 | 409551120 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 1 | 301709760 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | idx_fk_store_id | 2 | 88148016 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 4 | 83324736 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 1 | 71047152 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 2 | 63223776 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | idx_fk_film_id | 1 | 40361376 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | PRIMARY | 3 | 12798720 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespace_files | file_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespaces | PRIMARY | 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 | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|