SELECT * FROM `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 | payment | fk_payment_rental | 16044 | 89.41 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_inventory_id | 20625 | 23.00 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | PRIMARY | 1000 | 6.86 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | inventory | idx_fk_film_id | 5581 | 5.74 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 2 | 4.50 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_category | fk_film_category_category | 1016 | 1.14 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 28 | 1.09 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | pilote | PRIMARY | 2 | 774.59 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 277 | 542.75 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 5 | 89.61 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_store_id | 1 | 45.07 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_address_id | 1 | 36.49 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | idx_fk_store_id | 1 | 35.90 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | category | PRIMARY | 2 | 26.18 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 1 | 13.78 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 1 | 3.19 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | index_column_usage | index_id | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | help_category | name | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | columns | table_id_2 | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | columns | table_id | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | columns | PRIMARY | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | column_type_elements | PRIMARY | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | tablespaces | PRIMARY | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | tablespace_files | file_name | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
|