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 | 2 | 5166850128 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 4 | 3043300656 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 125 | 2395474752 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | PRIMARY | 75 | 2048391840 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 27 | 1434864816 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 50 | 1297194096 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 77 | 1156851696 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 9 | 1034440704 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | payment | idx_fk_staff_id | 2 | 999058896 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 29 | 936558480 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 4 | 845738256 | 0 | 0 | 0 | 0 | 0 | 0 | |
TEST AAA | students | PRIMARY | 28 | 834073680 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 3 | 470085264 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 1 | 411243360 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | inventory | idx_fk_film_id | 8 | 213503136 | 0 | 0 | 0 | 0 | 0 | 0 | |
recursos_humanos | Regiones | PRIMARY | 13 | 202089360 | 0 | 0 | 0 | 0 | 0 | 0 | |
Table_insertion | pilote | PRIMARY | 6 | 127337232 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 1 | 55502832 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | store | idx_unique_manager | 1 | 45833568 | 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 | tablespace_files | file_name | 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 | |
mysql | column_type_elements | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|