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 | category | PRIMARY | 25 | 80359560864 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 125 | 2336270112 | 0 | 0 | 0 | 0 | 0 | 0 | |
e_shop | orders | PRIMARY | 148 | 2262797328 | 0 | 0 | 0 | 0 | 0 | 0 | |
e_shop | customer | PRIMARY | 157 | 2252809152 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 201 | 1814149920 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 49 | 1732323120 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 25 | 1633702752 | 0 | 0 | 0 | 0 | 0 | 0 | |
football | top_scorers | PRIMARY | 103 | 1468418160 | 0 | 0 | 12 | 119178048 | 0 | 0 | |
football | best_teams | PRIMARY | 116 | 1407443664 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 2 | 797998608 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 25 | 765963792 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 77 | 512111424 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 1 | 481261440 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 5 | 437156016 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 50 | 420587904 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | PRIMARY | 25 | 214957776 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 5 | 173251056 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 8 | 136381344 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 2 | 80443440 | 0 | 0 | 0 | 0 | 0 | 0 | |
mystore | users | 3 | 51336384 | 0 | 0 | 0 | 0 | 0 | 0 | ||
sakila | film_category | fk_film_category_category | 1 | 43801296 | 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 | |
sku | Interpreta | codFilm | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|