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 | customer | idx_fk_store_id | 3 | 4.25 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 150 | 1.74 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | pilote | PRIMARY | 7 | 1.59 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | PRIMARY | 25 | 1.21 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 77 | 1.11 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 2 | 889.02 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_store_id | 3 | 861.35 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | idx_fk_city_id | 205 | 761.51 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | store | idx_unique_manager | 14 | 745.82 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sys | sys_config | PRIMARY | 2 | 592.02 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 75 | 568.54 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | voiture | Id_ecurie | 3 | 456.92 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 111 | 223.30 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 27 | 199.31 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | inventory | idx_fk_film_id | 3 | 122.79 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | ecurie | PRIMARY | 22 | 106.12 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 3 | 85.62 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | voiture | Id_ecurie | 1 | 55.67 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Stefano | vulcano | PRIMARY | 2 | 46.74 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sku | Attore | PRIMARY | 2 | 43.51 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | ecurie | PRIMARY | 2 | 29.97 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | pilote | PRIMARY | 1 | 26.09 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | category | PRIMARY | 1 | 14.12 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | megye | PRIMARY | 1 | 14.09 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | columns | PRIMARY | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
|