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_category | PRIMARY | 3300000 | 2651755814400 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 3081620 | 1425314520960 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | PRIMARY | 3304000 | 526046847744 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 102800 | 47263089456 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | megye | PRIMARY | 2 | 2403763824 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 2 | 1075044960 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 200 | 756055872 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_address_id | 110 | 705660912 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 147 | 688664064 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 1 | 673722720 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 226 | 671105424 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 64 | 492239616 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 700 | 478041696 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 200 | 375220032 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_actor | idx_fk_film_id | 18 | 353406768 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | idx_fk_store_id | 4 | 349143168 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_category | fk_film_category_category | 20 | 329461968 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | idx_fk_address_id | 18 | 245908608 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 702 | 244583328 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | payment | idx_fk_staff_id | 8 | 217505376 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 20 | 200114112 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 20 | 73075200 | 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 | |
performance_schema | table_io_waits_summary_by_index_usage | OBJECT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|