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 | 175 | 3403207104 | 0 | 0 | 0 | 0 | 0 | 0 | |
world | Country | PRIMARY | 12 | 3097634496 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 136 | 1760309232 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | megye | PRIMARY | 1 | 907501056 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 28 | 903186768 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_address_id | 11 | 706149840 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 16 | 553915824 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 50 | 488796528 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 103 | 287747856 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_category | fk_film_category_category | 1 | 286537680 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 10 | 223582128 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 25 | 194106528 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 25 | 193508304 | 0 | 0 | 0 | 0 | 0 | 0 | |
sku | Attore | PRIMARY | 7 | 94428576 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 4 | 59693040 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 18 | 52058160 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | index_column_usage | index_id | 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 | 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 | |
mysql | tablespaces | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespace_files | file_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|