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 | |
---|---|---|---|---|---|---|---|---|---|---|---|
Bibliotca | Libros | PRIMARY | 295 | 2318385168 | 0 | 0 | 0 | 0 | 0 | 0 | |
Bibliotca | Miembros | PRIMARY | 284 | 2116215024 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_title | 225 | 1583605056 | 0 | 0 | 0 | 0 | 0 | 0 | |
Bibliotca | Prestamos | IDMiembro | 76 | 1498712160 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 200 | 1305607248 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 4 | 1139556528 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 1 | 739168320 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 28 | 506237952 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 50 | 389741616 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 200 | 316916160 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | PRIMARY | 25 | 267725040 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 25 | 201572976 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | actor | idx_actor_last_name | 6 | 106301712 | 0 | 0 | 0 | 0 | 0 | 0 | |
Bibliotca | Prestamos | PRIMARY | 10 | 24344496 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 1 | 13783968 | 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 | |
mysql | index_column_usage | index_id_2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id_2 | 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 | 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 |
|