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 | 96264 | 214.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_inventory_id | 123750 | 54.31 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | inventory | idx_store_id_film_id | 27498 | 7.03 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | pilote | PRIMARY | 4 | 5.06 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | ecurie | PRIMARY | 4 | 4.11 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 38 | 3.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | PRIMARY | 25 | 1.59 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_staff_id | 1 | 1.12 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | PRIMARY | 39 | 999.09 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 25 | 874.97 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 15 | 802.09 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sys | sys_config | PRIMARY | 1 | 691.33 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | voiture | Id_ecurie | 3 | 577.96 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | store | PRIMARY | 18 | 78.30 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 1 | 60.68 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | store | idx_unique_manager | 1 | 57.17 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 13 | 46.31 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 1 | 40.24 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | idx_fk_address_id | 1 | 38.36 us | 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 | foreign_keys | referenced_table_catalog | 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 |
|